Db2 for z/OS 13: Introduction to System Administration (CV854G)

Overview

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.

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.

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 knowledge

OR

  • At least one year as a Db2 for z/OS database administrator

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
Afficher les détails

Course Outline

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)