IBM Professional Certification Program

Accelerate insight. Improve skills. Get certified now.

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

This page is currently being updated to reflect the latest resources and courses available to help you prepare for this certification test.

Courses and publications are offered to help you prepare for the certification tests. The courses are recommended, but not required, before taking a certification test.

Study Guide for the certification test.

All Course Formats

Course title: DB2 9 for z/OS System Administration

Course duration: 5 days

Course number: CV85x


Administrators of DB2 9 for z/OS can acquire a view of the architecture and fundamental processes required to manage a DB2 9 for z/OS subsystem. Engage in lectures and hands-on labs to gain experience to: relate the z/OS IPL process to a DB2 subsystem, explain effects of stopping and starting DB2, explain how DB2 sets and use Integrated Catalog Facility (ICF) catalog names, the use of DSN command processor running in batch and foreground, use views to minimize users' ability to see into the DB2 catalog, see how the catalog (through grant activity) controls access to data, search the catalog for problem situations, use the catalog and DB2 utilities to determine data recovery requirements, describe Internal Resource Lock Manager (IRLM) in a DB2 environment, implement DB2 and Resource Access Control Facility (RACF) security, describe DB2 program flow for all environments, display normal and problem threads and database status, see how the SQL Processor Using File Input (SPUFI) AUTOCOMMIT option defers the COMMIT/ROLLBACK decision, interpret lock displays, identify and cancel particular threads, describe available DB2 utilities to manage system and user page sets.

This course is the classroom delivered version of DB2 9 for z/OS System Administration - Instructor Led Online (3V85).

Course title: DB2 9 for z/OS Implementation Workshop

Course duration: 5 days

Course number: CV86x


This course is for installers of DB2 UDB for z/OS V8 and/or migration to DB2 9 for z/OS using the Install CLIST. You will be involved in lectures to understand DB2 UDB for z/OS and DB2 9 Components and pointer and the processes involved to install and or migrate DB2. To reinforce the lectures a series of labs are provided to give you hands-on experience installing DB2 UDB V8 and migrating to DB2 9 for z/OS.

This is the classroom version of the Instructor Led Online (ILO) course DB2 for z/OS Implementation Workshop - Instructor Led Online (3L861)

Retail Book

Written with system administrators in mind, this reference offers information about both DB2 and z/OS operating systems as well as guidance for preparing for the IBM Certification Test 737. Helpful and thorough, this technical guide summarizes the new features of DB2 9 environments and provides essential system administration information, such as installation and maintenance procedures. With chapters on troubleshooting, performance and tuning, and securing and auditing, as well as practice questions, this reference is a one-stop shop for DB2 system administrators.


Connect with Us