You are here:  

Db2 12 for z OS Introduction to System Administration CV853G

Duration: 
3 days
Codes: 
CV853G
Versions: 
12
View Dates
Download Outline

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

Course 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

Related Courses

 

Thinking about Onsite?

If you need training for 3 or more people, you should ask us about onsite training. Putting aside the obvious location benefit, content can be customised to better meet your business objectives and more can be covered than in a public classroom. It's a cost effective option.

Submit an enquiry from any page on this site, and let us know you are interested in the requirements box, or simply mention it when we contact you.

Upcoming Dates

  • GREEN This class is Guaranteed To Run.
  • SPVC - Self-Paced Virtual Class.
  • Click a Date to Enroll.
Course Location Days Cost Date
Live Virtual Live Virtual3 2250 £2250 2019-09-23
Live Virtual Live Virtual3 2250 £2250 2019-10-28
Somerset Bath3 2250 £2250 2019-10-28
Live Virtual Live Virtual3 2250 £2250 2019-11-25
Live Virtual Live Virtual3 2250 £2250 2019-12-10
Live Virtual Live Virtual3 2250 £2250 2020-01-22
Live Virtual Live Virtual3 2250 £2250 2020-01-28