dB2 for zOS system administration

In DB2 for zOS System Administration training course, delegates will acquire a view of the architecture and fundamental processes required to manage a DB2 11 for z/OS subsystem.

  • 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
  • Working knowledge of SQL
  • At least one year as a z/OS systems programmer or equivalent experience
  • Or, one year working with DB2 on the mainframe as a DBA on the mainframe or equivalent experience

This course is for system administrators, database administrators.

 

" cols="40" >

This course is for system administrators, database administrators.

By attending DB2 for zOS System Administration workshop, Participants will learn 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
  • The use of DSN command processor running in batch and foreground
  • Use views to minimize users' ability to see into the DB2 catalog
  • See how the catalog (through grant activity) controls access to data
  • Search the catalog for problem situations
  • Use the catalog and DB2 utilities to determine data recovery requirements
  • Describe Internal Resource Lock Manager (IRLM) in a DB2 environment
  • Implement DB2 and Resource Access Control Facility (RACF) security
  • Describe DB2 program flow for all environments
  • Display normal and problem threads and database status
  • See how the SQL Processor Using File Input (SPUFI) AUTOCOMMIT option defers the COMMIT/ROLLBACK decision
  • Interpret lock displays
  • Identify and cancel particular threads
  • Describe available DB2 utilities to manage system and user page sets