This course introduces the skills and knowledge required to administer a Db2 13 for z/OS system. Utilizing the lecture and a z/OS lab environment, learners will gain practical practice starting, stopping, and accessing Db2; examining the zParms and data sets; connecting to a Db2 subsystem via Data Studio; querying the catalog; exploring RACF; examining threads; working with DB2I; modifying Db2 active and archived logs; utilizing online utilities; monitoring and controlling Db2; recovering the catalog and directory; and using the administrative task scheduler.
TARGET AUDIENCE:
This course is intended for z/OS system administrators, database administrators, or other technical individuals who will be managing Db2 13 for z/OS.
COURSE PREREQUISITES:
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 knowledgeOR • At least one year as a Db2 for z/OS database administrator
COURSE CONTENT:
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)
COURSE OBJECTIVE:
• 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
FOLLOW ON COURSES:
Not available. Please contact.