Number of questions: 60
Number of questions to pass: 42
Time allowed: 90 mins
Status: Live
An IBM Certified Administrator on IBM Db2 12 for z/OS is the lead database administrator for the Db2 product on the z/OS operating system. This individual has significant experience as a DBA and extensive knowledge of Db2, up to and including Db2 12 for z/OS Function Level 506. This individual is capable of performing intermediate to advanced tasks related to database design and implementation, operation and recovery, security and auditing, distributed connectivity, performance, installation and migration/upgrades specific to the z/OS operating system.
This exam consists of 7 sections described below. For more detail, please see the study guide on the Exam Preparation tab.
Section 1: Database Design and Implementation 22%
Design tables and views
Explain the different performance implications of identity column, ROWID, and sequence column definitions
Design indexes
Design universal table spaces
Perform partitioning
Normalize data (E-R model, process model) and translate data model into physical model
Understand and describe Db2 database enforced integrity rules
Use the appropriate method to alter Db2 objects
Explain the use and impact of different encoding schemes
Section 2: Operation and Recovery 20%
Explain and execute commands and subcommands for normal operational conditions
Explain and execute commands and utility control statements for use in abnormal conditions
Load and unload data into and from Db2 tables
Reorganize objects when necessary
Monitor objects by collecting statistics
Monitor and manage threads and utilities
Identify and respond to advisory/restrictive statuses on Db2 objects
Identify and perform problem determination
Perform object and catalog/directory health checks
Identify and perform actions needed to protect databases from planned and unplanned outages
Identify and perform actions needed to recover data to a consistent point in time
Section 3: Security and Auditing 10%
Explain privileges and authorities
Protect access to Db2 and its objects
Audit Db2 activity and resources and identify primary audit techniques
Identify and respond appropriately to symptoms from trace output or error messages that signify security problems
Explain and use roles, trusted context, data masking and encryption
Section 4: Performance 21%
Plan for performance monitoring by setting up and running monitoring procedures
Analyze performance (manage and tune CPU requirements, memory, I/O, locks, response time, index and table compression)
Analyze and respond to RUNSTATS statistics analysis
Determine when and how to perform REBIND
Describe Db2 interaction with Workload Manager (WLM)
Review and tune SQL
Monitor dynamic SQL performance
Design features for performance
Explain how to control and influence access paths
Section 5: Installation and Migration 9%
Recommend settings for critical Db2 system parameters
Identify and explain Db2 data sharing components and commands
Describe use of premigration checklists
Describe the function of the catalog and directory
Demonstrate understanding of the Db2 12 continuous delivery process
Explain the migration process and activation of new function levels
Section 6: Additional Database Functionality 9%
Explain and use SQL constructs
Explain the use of stored procedures
Explain the use of SQL/XML and XQuery
Explain the use of user-defined functions
Explain and use global variables
Describe the use of triggers, merge statement, pagination options and JSON support
Section 7: Distributed Access 9%
Demonstrate understanding of distributed data access and the role of the communications database
Demonstrate understanding of Distributed Data Facility (DDF) implementation options
Recommend values for critical DDF configuration settings
Understanding and implementing distributed data access
Describe Db2 support for Native REST services and differentiate from RESTful API
Actualkey IBM C1000-078 exam pdf, Certkingdom IBM C1000-078 PDF
Best IBM C1000-078 Certification, IBM C1000-078 Training at certkingdom.com
