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.


* Actual course outline may vary depending on offering center. Contact your sales representative for more information.

Learning Objectives

Please refer to course overview

  • Course Outline

  • Start and stop the DB2 subsystem
    Explain the allocation CLIST used at logon for DB2 data sets
    Use Set SYSPARM command
    Locate the Command recognition character for the DB2 subsystem
    Query the system log to gain knowledge about the IPL process and information in the system log when DB2 is initialized or stopped
    Explore DB2 Address Spaces information
    Select the DB2 functions that best satisfy your site requirements
    Explain the use of RACF for DB2 connection security
    Explain the use of Roles and Trusted Context
    Implement security procedures for a DB2 environment
    Describe the components and address space structure of a DB2 subsystem
    Explain DB2 Program Flow for all environments
    Invoke and use DB2 TSO Facilities
    Use the DB2 Catalog to monitor authorizations
    Increase the size of the Active Log data sets
    Explain DB2 Logging
    Use DSNJU004 to Print Log Map
    Interpret the output of the Print Log Map Utility DSNJU004
    Use DSNJU003 to rename DB2 data sets
    Plan for recovery of a BSDS failure
    Monitor and control DB2
    Explain transaction flow in IMS and CICS
    Describe the CICS and DB2 environment
    Make use and implement the extended 10-byte RBA and LRSN


This is an intermediate course for system administrators, database administrators, and other technical individuals, who manage and implement DB2 10 for z/OS.




An understanding of the objects (tables, indexes, databases, and so forth) used in DB2 systems, and of how those objects are created, managed, and recovered. These skills can be developed by taking the DB2 Database Administration Workshop (CF83G) / (CV830) or through equivalent experience; a working knowledge of SQL. The SQL Workshop (CE120G) / (3E12G) provides that; At least one year as a z/OS systems programmer or equivalent experience


Length: 5.0 days (40 hours)


Not Your Location? Change

Course Schedule:

To request a custom delivery, please chat with an expert.