IBM Professional Certification Program

Certify your skills. Accelerate your career.

Test C2090-617: DB2 10 System Administrator for z/OS

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, tune and secure DB2 for z/OS environments.

Section 1 - Installation and Migration (20%)

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

  2. Ability to identify additional environments necessary (WLM, Unix system services, XML schema support, RACF or equivalent)

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

  4. Evaluate appropriate DSNZPARM settings

Section 2 - Security and Auditing (13%)

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

    1. New system authorities

    2. Support for distributed identities, connection level security enforcement

  2. Describe auditing techniques (policies)

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

Section 3 - System Operation and Maintenance (13%)

  1. Describe how to use and manage DB2 components and processes (new options to reorg catalog)

  2. Demonstrate knowledge of DB2 commands

  3. Given a scenario, describe how to monitor and control DB2 threads

Section 4 - Backup and Recovery (17%)

  1. Demonstrate knowledge of system level backup and recovery procedures (HSM, flash copy, etc.)

  2. Given a scenario, describe how to recover from system failures (restart, conditional restart)

  3. Describe the process for disaster recovery

  4. Describe DB2 data sharing recovery scenarios

Section 5 - Performance and Tuning (22%)

  1. Given a scenario, analyze performance

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

  3. Demonstrate knowledge of statistics, tools, and traces used for monitoring (trace definitions)

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

  5. Demonstrate knowledge of workload manager settings for DB2

  6. Knowledge of autonomic vs manual RUNSTATS

Section 6 - Troubleshooting (16%)

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

  2. Demonstrate knowledge of operator commands and traces for troubleshooting

  3. Describe how to identify contention problems

  4. Demonstrate knowledge of diagnostic utilities

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


Connect with Us