CMDBID: 100271 | Course Code: CV853G | Duration: 3 Days
Overview>
This course provides students with an introduction to the skills and knowledge needed to administer a Db2 12 for z/OS system.
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.
Skills Gained>
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)
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
Outline>
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
Our Clients
Our clients have included prestigious national organisations such as Oxford University Press, multi-national private corporations such as JP Morgan and HSBC, as well
as public sector institutions such as the Department of Defence and the Department of Health.