Formation DB2 13 for z/OS : Introduction to System Administration

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.

Objectif opérationnel :

Savoir administrer un système DB2 13 pour z/OS.

Objectifs pédagogiques : 

Cette formation DB2 13 System Administration vous donne les connaissances et compétences pour : 

• 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

Public :

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

Prérequis :

Participants should have the following 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

Starting, stopping, and accessing Db2

Db2 components and processes

System security

Db2 authorization

Program flow for all environments

TSO and batch environments

Transaction flow in IMS and CICS (optional)

CICS - Db2 environment (optional)

IMS - Db2 environment (optional)

Distributed - Db2 environment

Logging

Db2 utilities

Operations (monitoring and controlling Db2)

Recovery

System recover/restart

Java with Db2  (optional)

Administrative task scheduler (optional)