IBM Professional Certification Program

Certify your skills. Accelerate your career.

Test 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, SMS)

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

  4. Evaluate appropriate subsystem parameter (DSNZPARM) settings

  5. Evaluate appropriate migration to extended RBA/LRSN tasks

Section 2 - Security and Auditing (12%)

  1. Given a scenario, demonstrate knowledge of how to protect DB2 subsystem and resources (implementing external security only)

    1. Knowledge of various System authorities

    2. Support for distributed identities, connection level security enforcement

    3. Program authorization and masking including enhancements

  2. Describe auditing techniques (policies)

  3. Describe role-based security and the advantage of deploying it (trusted context)

Section 3 - System Operation and Maintenance (17%)

  1. Describe how to use and manage DB2 components and processes (adminitrative task scheduler) (REPAIR, STOSPACE, DSNJU003, DSN1COMP)

  2. Demonstrate knowledge of DB2 commands

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

  4. Knowledge of DB2 data sharing system operation and maintenance

  5. Knowledge of distributed functionality

Section 4 - Backup and Recovery (17%)

  1. Demonstrate knowledge of advanced backup and recovery (system level, data set level, undo, redo, backup, flash copy, DSS, HSM, DSNJU004, DSN1COPY, DSN1LOGP, DSN1PRNT, Extended RBA, 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

  5. Knowledge of consideration/impact of extended and non-extended RBA/LRSN tasks

Section 5 - Performance and Tuning (22%)

  1. Given a scenario, analyze performance

  2. Demonstrate knowledge of how buffer pools and system parameters (DSNZPARMs) can affect performance - concurrency

  3. Demonstrate knowledge of persistance threads (bind parameters, reallocate, protected threads)

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

  5. Given a scenario, describe techniques to achieve efficient use of memory (flash memory, large buffer pools) Statement Cache (Dynamic, Static, EDM Pool)

  6. Demonstrate knowledge of workload manager (WLM) settings for DB2

  7. Knowledge of RUNSTATS (autonomic, manual, RTS, and feedback)

  8. Knowledge of Reorg in the context of system tuning and performance (system level settings, subsystem parameters, reduction of indirect references)

  9. Knowledge of specialty engines and how they affect performance (ziips)

Section 6 - Troubleshooting (13%)

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

  2. Demonstrate knowledge of DB2 commands and traces for troubleshooting

  3. Describe how to identify distributed threads

  4. Demonstrate knowledge of diagnostic utilities (REPAIR, DSNJU003, DSN1CHKR)

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


Connect with Us