IBM Professional Certification Program

Certify your skills. Accelerate your career.

Test C2090-737: DB2 9 System Administrator for z/OS Exam

Note: This test will be withdrawn on Apr 30 2016.
The replacement test is: (C2090-317) DB2 11 System Administrator for z/OS

This certification exam certifies that the successful candidate has important knowledge, skills, and abilities necessary to describe the architecture and administer the processes required to plan, install, manage, and tune secure DB2 for z/OS environments.

Section 1 - Installation and Migration (15%)

  1. Given a scenario, demonstrate knowledge of the installation/migration plan process

  2. Given a scenario, describe how to execute the installation/migration plan

  3. Evaluate appropriate DSNZPARM settings

Section 2 - Security and Auditing (7%)

  1. Given a scenario, demonstrate knowledge of how to protect DB2 subsystem and resources

  2. Describe auditing techniques

  3. Describe role-based security and the advantage of deploying it

Section 3 - System Operation and Maintenance (21.5%)

  1. Describe how to use and manage DB2 components and processes

  2. Demonstrate knowledge of DB2 commands

  3. Given a scenario, describe how to monitor an dcontrol DB2 threads

  4. Demonstrate knowledge of DB2 commands

Section 4 - Backup and Recovery (20%)

  1. Demonstrate knowledge of system level backup and recovery procedures

  2. Given a scenario, describe how to recover from system failures

  3. Describe the process for disaster recovery

Section 5 - Performance and Tuning (21.5%)

  1. Given a scenario, analyze performance

  2. Demonstrate knowledge of how buffer pools and ZPARMs can affect performance

  3. Demonstrate knowledge of statistics, tools, and traces used for monitoring

  4. Given a scenario, describe techniques to achieve efficient use of memory

  5. Demonstrate knowledge of workload manager settings for DB2

Section 6 - Troubleshooting (15%)

  1. Given a scenario, describe which documentation can be used to solve a problem

  2. Demonstrate knowledge of operator commands and traces fro troubleshooting

  3. Describe how to identify contention problems

  4. Demonstrate knowledge of diagnostic utilities

  5. Given a scenario, identify and resolve data sharing problems


Connect with Us