Db2 12 for z/OS Introduction to System Administration
This course provides students with an introduction to the skills and knowledge needed to administer a Db2 12 for z/OS system.
Duration: 30-35hrs
Course Content:
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 environments
- - 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
- - Syncronization
- - Commands