CV852 IBM DB2 11 for zOS System Administration

5 Days

30 CPD hours

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

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.

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 SET LOG SUSPEND and SET LOG RESUME
• 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