IBM


IBM Professional Certification Program

Accelerate insight. Improve skills. Get certified now.

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


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, 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



Promotions


Connect with Us