Test 000-614: DB2 10.1 Advanced DBA for Linux UNIX and Windows

An IBM Certified Advanced Database Administrator is the lead DBA for the DB2 products on one or more of the following platforms: Linux, UNIX (including AIX, HP-UX, and Sun Solaris), and Windows. This individual has extensive experience as a DBA and extensive knowledge of DB2 10.1. This person is capable of performing the advanced tasks such as performance, high availability, security and networking that are required.

Section 1 - Database Design (17%)

1. Ability to design, create and manage database storage paths
2. Ability to design, create and manage table spaces
3. Ability to design, create and manage buffer pools
4. Ability to design and configure a database for multi-temperature data
5. Ability to use Data Studio to manage database environments

Section 2 - Data Partioning and Clustering (20%)

1. Ability to design, create, and manage database partitioning (DPF)
2. Ability to design, create, and manage multi-dimensional clustered tables
3. Ability to design, create, and manage range partioning
4. Ability to design, create, and manage insert time clustering tables
5. Ability to design, create, and manage range clustering tables

Section 3 - High Availability and Diagnostics (24%)

1. Ability to manage database logs for recovery
2. Ability to use advanced backup features
3. Ability to use advanced recovery features
4. Knowledge of Work Load Manager (WLM)
5. Ability to use High Availability Disaster Recovery (HADR)
6. Ability to determine the appropriate diagnostic tool to use for a given scenario

Section 4 - Performance and Scalability (24%)

1. Knowledge of query optimizer concepts
2. Ability to manage and tune database, instance and application memory and I/O
3. Ability to use compression
4. Given a scenario, resolve performance problems
5. Ability to determine the appropriate index for a given scenario
6. Ability to exploit parallelism

Section 5 - Advanced Concepts (15%)

1. Knowledge of how/when to create a federated database environment
2. Knowledge of replication
3. Knowledge of pureScale
4. Knowledge of how/when to use the DB2 Audit facility