IBM Professional Certification Program

Certify your skills. Accelerate your career.

Test C2090-317: DB2 11 System Administrator for z/OS

It is highly recommended that you use a variety of resources to prepare for certification exams. 

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. When preparing for the certification test, keep in mind that real world experience is required to stand a reasonable chance of passing the certification test.  Courseware does not replace the requirement for experience.  Please note that course offerings are continuously being added and updated.  If you want to purchase a training course, feel free to contact an IBM Global Training Provider.

Web Resource

Welcome to the new home for IBM product documentation. Customize IBM Knowledge Center to design the experience that you want with the technology, products, and versions that you use. You can also interact with IBM and with your colleagues by using the My Knowledge Center features.

All Course Formats

Course title: New Functions and Features in DB2 11 for z/OS

Course duration: 3 Days

Course number: CV320G

Abstract: Learn about the new features and enhancements of DB2 11 for z/OS, including the technical detail of the functional enhancements of this significant new version of DB2 for z/OS.

Course title: DB2 10 for z/OS Database Administration Workshop Part 1

Course duration: 5

Course number: CV831G

Abstract: This course provides you with instruction on how to physically implement a logical database design in DB2. The course includes instruction on DB2 data management, DB2 catalog tables, the bind process, database utilities such as LOAD and REORG, and security considerations.

Course title: DB2 11 for z/OS System Administration

Course duration: 5 Days

Course number: CV852G

Abstract: Administrators of DB2 11 for z/OS can acquire a view of the architecture and fundamental processes required to manage a DB2 11 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

    Course title: DB2 10 for z/OS Implementation Workshop

    Course duration: 5 Days

    Course number: CV861G

    Abstract: This course is for installers of DB2 9 z/OS and/or migration to DB2 10 for z/OS using the Install CLIST. You are involved in lectures that explain DB2 10 components and pointers, and the processes used to install or migrate from DB2 9 for z/OS. To reinforce the lectures, a series of labs are provided to give you hands-on experience installing DB2 9 for z/OS and migrating to DB2 10 for z/OS. The hands-on labs include exercises to: Install DB2 9 for z/OS subsystem Verify with the sample applications Perform parameter updates Migrate to DB2 10 conversion mode Fall back to DB2 9 for z/OS Migrate again to DB2 10 conversion mode Enable new function mode Verify with the sample applications Precompile option NEWFUN(V9)

    Course title: DB2 10 for z/OS System Performance Analysis and Tuning

    Course duration: 4 Days

    Course number: CV951G

    Abstract: This course explains how to monitor and tune DB2 10 for z/OS from a system point of view.

  • Retail Book

    Retail Publications for IBM Training and Documentation


    Connect with Us