Db2 12 for z/OS Introduction to System Administration (CV853G)

Db2 12 for z/OS Introduction to System Administration (CV853G)

Overview

This course provides students with an introduction to the skills and knowledge needed to administer a Db2 12 for z/OS system.

Objectives

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 procredures for a Db2 subsystem
  • Explain Db2 program flow for all environments
  • Explain parameter setting for the IRLM
  • Invoke and utilitze 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
  • And much more

Course Outline

1. Starting, stopping, and accessing Db2

  • Starting Db2 as part of the z/OS IPL process
  • Data set allocation and APF authorization
  • The START DB2 and STOP DB2 commands
  • zParms, DSNTIJUZ, and DSNZPARM
  • Address spaces
  • IRLM and lock storage

 

2. Db2 components and processes

  • BSDS and logging
  • Catalog and directory
  • Program preparation and execution
  • Transaction execution
  • Data sharing in the sysplex

 

3. System security

  • Protecting Db2 data sets
  • Controlling connections to Db2
  • Db2 authorization exits
  • Trusted context and roles
  • Securing an application server

 

4. Db2 authorization

  • Authorizations
  • Controlling access for dynamic and static SQL
  • Access control authorization exits
  • Distributed security

5. Program flow for all environments

  • Connection types and language interfaces
  • Program flow

 

6. TSO and batch environments

  • TSO
  • Utilities

7. Transaction flow in IMS and CICS (optional) 

  • Transaction processing
  • Thread reuse
  • SIGNON exit

 

8. CICS - Db2 environment (optional) 

  • CICS connections to Db2
  • DSNC transaction

 

9. IMS - Db2 environment (optional) 

  • IMS-Db2 introduction
  • IMS TM
  • IMS/DLI batch environment

 

10. Distributed - Db2 environment

  • Distributed attachment
  • Location aliases
  • DDF profiling
  • Block fetch
  • Db2 REST services

11. Logging

  • The Db2 log
  • Log commands
  • Archiving considerations
  • BSDS

 

12. Db2 utilities

  • Categorization
  • DSNJU003 and DSNJU004
  • BACKUP and RESTORE SYSTEM

 

13. Operations (monitoring and controlling Db2) 

  • Issuing Db2 commands
  • Basic workload controls
  • Monitoring and controlling utilities
  • DISPLAY commands
  • Starting / stopping databases

 

14. Recovery

  • Planning for recovery
  • Table space recovery
  • Log considerations
  • DISPLAY and SET LOG commands
  • Recovery considerations

 

15. System recover/restart

  • System checkpoints
  • System restart after normal shutdown
  • Page externalization
  • Two-phase commit processing
  • System restart after system failure
  • Recovery considerations

 

16. Java with Db2 (optional) 

  • Java

 

17. Administrative task scheduler (optional) 

  • Overview
  • Routines
  • Scheduling features
  • Life cycle
  • Syncronization
  • Commands
  • 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
Course ID:
CV853G


Show Schedule for: