Test 734: DB2 9 Advanced Database Administrator for Linux UNIX and Windows

Section 1 - Database Design (14%)

1. Ability to design, create and manage table spaces
2. Ability to design, create and manage buffer pools
3. Ability to design and configure federated database access

Section 2 - Data Partioning and Clustering (15%)

1. Ability to design, create, and manage database partitioning
2. Ability to design, create and manage multi-dimensional clustered tables
3. Ability to design, create, and manage table partioning
4. Knowledge of Balance Configuration Unit (BCU)

Section 3 - High Availability and Diagnostics (20%)

1. Ability to manage database logs for recovery
2. Ability to use advanced backup features
3. Ability to use advanced recovery features
4. Ability to enhance database availability
5. Ability to use diagnostic tools (db2pd, db2mtrk, inspect, db2dart, db2diag)

Section 4 - Performance and Scalability (33%)

1. Identify and use DB2 registry variables that affect database system performance
2. Identify and use configuration parameters that affect database system performance
3. Knowledge of query optimizer concepts
4. Ability to manage and tune database, instance and application memory and I/O
5. Ability to use Data Compression
6. Ability to analyze performance problems
7. Ability to manage a large number of users and connections
8. Ability to determine the more appropriate index
9. Ability to exploit parallelism

Section 5 - Security (8%)

1. Knowledge of external authentication mechanisms
2. Ability to implement data encryption
3. Ability to implement Label Based Access Control (LBAC)
4. Ability to use DB2 Audit

Section 6 - Connectivity and Networking (10%)

1. Ability to configure client server connectivity (e.g., db2discovery)
2. Ability to manage connections to host systems
3. Ability to identify and resolve connection problems