Db2 12 for z/OS Introduction to System Administration

After completing this course, students should be able to:

• Start and stop a Db2 subsystem
• Use the SET SYSPARM command
• Access the system log to gather information about the subsystem initialization, operation, or shutdown
• Describe the components and address space structure of a Db2 subsystem
• Explain the use of RACF (or another external security program) for Db2 connection security
• Explain the use of Roles and Trusted Contexts
• Implement security procedures for a Db2 subsystem
• Explain Db2 program flow for all environments
• Explain parameter setting for the IRLM
• Invoke and utilize Db2 TSO facilities
• Use the Db2 Catalog to monitor subsystem authorizations
• Work with the Active Log data sets
• Explain Db2 logging
• Use SET LOG SUSPEND and SET LOG RESUME
• Use DSNJU004 to print log map and interpret the results
• Use DSNJU003 to rename Db2 data sets
• Plan for recovery of a BSDS failure
• Monitor and control a Db2 subsystem
• Explain transaction flow in IMS and CICS environments (optional)
• Describe the CICS and DB2 environment (optional)

Explain the difference between JDBC and SQLJ

Participants should have the following knowledge and skills.

• Understanding of the objects (such as databases, table spaces, tables, indexes, and so forth) used in a Db2 subsystem
• Basic knowledge of SQL
• At least one year as a z/OS systems programmer or equivalent knowledge

OR

• At least one year as a Db2 for z/OS Database Administrator

System Administrators, #GOATs and Database Administrators