DB2 10 for zOS System Administration

Schedule

Start End Duration Location Details

Course Details

DB2 10 for zOS System Administration

Course Code: CV851G

Duration: 5 days

Prerequisite:

You should have an understanding of the objects (tables, indexes, databases, and so forth) used in DB2 systems, and of how those objects are created, managed, and recovered.

These skills can be developed by taking the DB2 Database Administration Workshop (CF83) / DB2 9 for z/OS Database Administration Workshop Part 1 (CV830) or through equivalent experience. You should also have a working knowledge of SQL. The DB2 SQL Workshop (CF12) / SQL Workshop - Instructor Led Online (3E120) provides that.

Course Description:

The course is updated for DB2 10 for z/OS. This is the version of the course DB2 10 for z/OS System Administration - ILO (3V851).

Administrators of DB2 10 for z/OS can acquire a view of the architecture and fundamental processes required to manage a DB2 10 for z/OS subsystem. Engage in lectures and hands-on labs to gain experience to:

  • Relate the z/OS IPL process to a DB2 subsystem
  • Explain effects of stopping and starting DB2
  • Explain how DB2 sets and use Integrated Catalog Facility (ICF) catalog names

Course Objectives:

  • Start and stop the DB2 subsystem
  • Explain the allocation CLIST used at logon for DB2 data sets
  • Use Set SYSPARM command
  • Locate the Command recognition character for the DB2 subsystem
  • Query the system log to gain knowledge about the IPL process and information in the system log when DB2 is initialized or stopped
  • Explore DB2 Address Spaces information
  • Select the DB2 functions that best satisfy your site requirements
  • Explain the use of RACF for DB2 connection security

Intended Audience:

This intermediate course is for system administrators, database administrators, and other technical individuals, who manage and implement DB2 10 for z/OS.

Course Outlines:

  • Basic architecture and fundamental mechanisms
  • System security
  • DB2 program flow for all environments
  • TSO and batch environments
  • DB2 authorization
  • Logging
  • DB2 9 for z/OS utilities
  • Object recovery
  • Transaction flow in IMS and CICS
  • CICS - DB2 environment
  • Operations (monitoring and controlling DB2)
  • System recovery/restart
  • IMS - DB2 environment
  • Distributed - DB2 environment