IBM Professional Certification Program

Certify your skills. Accelerate your career.

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


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 11 for z/OS Database Administration Workshop Part 1

Course duration: 5 Days

Course number: CV832G

Abstract:

This intermediate course is for future DB2 for z/OS database administrators who need to acquire the basic skills required to administer a DB2 database.


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 11 for zOS Implementation Workshop

    Course duration: 5 Days

    Course number: CV862G

    Abstract: This course is for installers of DB2 10 z/OS and/or migration to DB2 11 for z/OS using the Install CLIST. The participants are involved in lectures that explain DB2 11 components and pointers, and the processes used to install or migrate from DB2 10 for z/OS. To reinforce the lectures, a series of labs are provided to give each participant hands-on experience installing DB2 10 for z/OS and migrating to DB2 11 for z/OS.


  • Retail Book

    Retail Publications for IBM Training and Documentation


    Promotions


    Connect with Us