Db2 for z/OS 13: Introduction to System Administration

Unit 1: Starting, Stopping, and Accessing Db2
Unit 2: Db2 Components and Processes
Unit 3: System Security
Unit 4: Db2 Authorization
Unit 5: Program Flow for All Environments
Unit 6: TSO and Batch Environments
Unit 7: Transaction Flow in IMS and CICS (optional)
Unit 8: CICS - Db2 Environment (optional)
Unit 9: IMS - Db2 Environment (optional)
Unit 10: Distributed - Db2 Environment
Unit 11: Logging
Unit 12: Db2 Utilities
Unit 13: Operations (Monitoring and Controlling Db2)
Unit 14: Recovery
Unit 15: System Recover / Restart
Unit 16: Java with Db2 (optional)
Unit 17: Administrative Task Scheduler (optional)

This course is intended for z/OS system administrators, database administrators, or other technical individuals who will be managing Db2 13 for z/OS.

Participants should have the following skills:

• A basic understanding of the objects (such as databases, table spaces, tables, indexes, etc) 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

• Start the Db2 subsystem using command syntax
• Identify and describe the function of the three required Db2 address spaces
• Describe the Db2 program preparation process, including precompilation, compilation, link editing, and binding steps
• Apply RACF commands to assign and manage access permissions for user groups
• Explain Trusted Contexts and Roles, then create and test them
• Check SYSADM authority and work with secondary authorization IDs and database privileges
• Explain Db2 program flow for all environments
• Run a Db2 program in a TSO batch environment
• Identify the steps involved in transaction processing and the purpose of the Db2 SIGNON protocol in CICS and IMS
environments
• Explain the role and configuration of the CICS Db2 Attachment Facility in establishing connections between CICS and Db2
subsystems
• Explain the role of the Subsystem Member (SSM) in controlling Db2 connections within IMS environments
• Explain the characteristics and functionality of Distributed Data Facility (DDF) transactions in Db2 for z/OS, including
their classification and usage with Workload Manager (WLM)
• Explain the role of the Db2 log in data recovery and system restart processes
• Explain the operation of the Db2 BACKUP SYSTEM utility, including system preparation, invocation of the DFSMShsm fast
replication function and updating the BSDS
• Demonstrate the use of Db2 commands to monitor and control utilities and connections
• Describe the components and function of a Unit of Recovery (UR) in Db2, including the role of log RBSa and the process of
back-chaining records for rollback
• Describe the phases of Db2 system restart following a system failure, including log initialization, current status
rebuild, forward log recovery, and backward log recovery
• Execute a restart following a normal shutdown and an abnormal shutdown
• Explain how JDBC enables Java applications to access Db2 for z/OS
• Explain the synchronization process and command operations of the Db2 administrative task scheduler and the steps to
start or stop the scheduler manually