IBM


IBM Professional Certification Program

Accelerate insight. Improve skills. Get certified now.

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


cert assess save

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



Promotions


Connect with Us