Db2 12 for z/OS Introduction to System Administration

Schedule

Start End Duration Location Details

Course Details

Db2 12 for z/OS Introduction to System Administration

Course Code: CV853G

Duration: 3 Days

Prerequisites: 

•    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 Description:

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

Course Objectives: 

•    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 procedures for a Db2 subsystem
•    Explain Db2 program flow for all environments
•    Explain parameter setting for the IRLM
•    Invoke and utilize 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

Intended Audience:

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

Course Outlines: 

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

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

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

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

Program flow for all environment
•    Connection types and language interfaces
•    Program flow

TSO and batch environments
•    TSO
•    Utilities

Transaction flow in IMS and CICS (optional)
•    Transaction processing
•    Thread reuse
•    SIGNON exit

CICS - Db2 environment (optional)
•    CICS connections to Db2
•    DSNC transaction    IMS - Db2 environment (optional)
•    IMS-Db2 introduction
•    IMS TM
•    IMS/DLI batch environment

Distributed - Db2 environment

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

Logging

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

Db2 utilities
•    Categorization
•    DSNJU003 and DSNJU004
•    BACKUP and RESTORE SYSTEM

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

Recovery

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

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

Java with Db2 (optional)
•    Java

Administrative task scheduler (optional)
•    Overview
•    Routines
•    Scheduling features
•    Life cycle
•    Synchronization
•    Commands