The IBM Certified Database Administrator is the lead database administrator (DBA) for the DB2 product on the z/OS operating system. This individual has significant experience as a DBA and extensive knowledge of DB2, specifically
the new features and functionality related to version 10. This person is capable of performing the intermediate to advanced tasks related to database design and implementation, operation and recovery, security and auditing,
performance, and installation and migration/upgrades specific to the z/OS operating system.
Test information:
Number of questions: 67
Time allowed in minutes: 90
Required passing score: 60%
Languages: English
The IBM Certified Database Administrator is the lead database administrator (DBA) for the DB2 product on the z/OS operating system. This individual has significant experience as a DBA and extensive knowledge of DB2, specifically the new features and functionality related to version 10. This person is capable of performing the intermediate to advanced tasks related to database design and implementation, operation and recovery, security and auditing, performance, and installation and migration/upgrades specific to the z/OS operating system.
Section 1 – Database Design and Implementation (30%)
Design tables and views
Explain the different performance implications of identity column, row ID, and sequence column definitions (applications, utilities), reorder row format, hash access
Design indexes
Design table spaces (choose a DB2 page size, clustering) and determine space attributes
Perform partitioning
Normalize data (E-R model, process model) and translate data model into physical model (denormalize tables)
Implement user-defined integrity rules
Use the appropriate method to alter DB2 objects
Create and Manage XML and LOB objects
Understand impacts of different encoding schemes
Implementing data distribution and replication
Section 2 – Operation and Recovery (28.5%)
Knowledge of commands for normal operational conditions
Knowledge of commands and utility control statements for use in abnormal conditions
Identify and perform actions that are needed to protect databases from planned and unplanned outages and ensure that timely image copies are taken periodically
Load and unload data into and from the created tables
Reorganize objects when necessary
Monitor the object by collecting statistics
Monitor and manage threads and utilities
Identify and respond to advisory/restrictive statuses on objects
Understanding the significance of checkpoints
Identify and perform problem determination
Perform health checks
Develop backup and recovery scenarios
Describe the special considerations for recovery in a data sharing environment
Understand the concept of disaster recovery
Understanding the concept of virtual storage constraints and limitations
Section 3 – Security and Auditing (9%)
Understanding 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
Create and maintain roles and trusted contexts
Implementing column and row level authorizations
Section 4 – Performance (28.5%)
Plan for performance monitoring by setting up and running monitoring procedures
Analyze performance
Analyze and respond to RUNSTATS statistics analysis
Determine when and how to perform REBIND
Calculate cache requirements for new applications
Understanding and implementing data distribution and replication
Describe DB2 interaction with WLM
Interpret traces and explain the performance impact of different DB2 traces
Identify and respond to critical performance metrics
Review and tune SQL
Dynamic SQL Performance
Design features for performance
Section 5 – Installation and Migration / Upgrade (4%)
Understand the critical ZPARMs
Identify the migration/upgrade modes
Identify & explain Datasharing components
IBM Certified Database Administrator – DB2 10 for z/OS
Job Role Description / Target Audience
The IBM Certified Database Administrator is the lead database administrator (DBA) for the DB2 product on the z/OS operating system. This individual has significant experience as a DBA and extensive knowledge of DB2, specifically the new features and functionality related to version 10. This person is capable of performing the intermediate to advanced tasks related to database design and implementation, operation and recovery, security and auditing, performance, and installation and migration/upgrades specific to the z/OS operating system.
Recommended Prerequisite Skills
Experience as a database administrator on DB2 10 for z/OS DBA and system programming DBA areas
At least two years experience in database administration for the z/OS operating system
Some knowledge and experience in both the application DBA and system programming DBA areas
Knowledge of SQL
Capability to work independently and effectively in complex environments
QUESTION 1
Workload Manager (WLM) manages how many concurrent stored procedures can run in an
address space and the number of concurrent stored procedures in an address space cannot
exceed the value of the NUMTCB parameter. Which statement about the value of NUMTCB is
correct?
A. NUMTCB parameter must be set to 1 for Java stored procedures.
B. NUMTCB parameter must be set to 1 for REXX stored procedures.
C. NUMTCB parameter can be a value greater than 1 for native SQL stored procedures.
D. NUMTCB parameter can be a value greater than 1 when a stored procedure invokes DB2
utilities.
Answer: B
Explanation:
QUESTION 2
If a single row of the PLAN_TABLE has a ‘Y’ value in more than one of the sort composite
columns, what is indicated?
A. The next sort step will perform two sorts.
B. There are multiple sorts in the plan step.
C. One sort in the plan step will accomplish two tasks.
D. Two sorts are performed on the new table of a star join.
Answer: C
Explanation:
QUESTION 3
What IBM provided stored procedure will access DB2 real time statistics tables?
A. DSNAEXP
B. DSNAIMS
C. DSNACCOX
D. DSNLEUSR
Answer: C
Explanation:
QUESTION 4
The EXPLAIN STMTCACHE ALL statement provides information about SQL tuning. Which
information is part of the DSN_STATEMENT_CACHE_TABLE?
A. Filter factor information.
B. Stage 1 and stage 2 information.
C. Number of columns used in an index.
D. Number of times an SQL statement is executed.
Answer: D
Explanation:
QUESTION 5
Which two of the following DB2 performance features will ignore clustering in favor of faster insert
performance? (Choose two.)
A. Append
B. Inline LOBs
C. Member cluster
D. Volatile table
E. Include columns
Answer: A,C
Explanation:
Click here to view complete Q&A of C2090-612 exam
Certkingdom Review
Best IBM C2090-612 Certification, IBM C2090-612 Training at certkingdom.com