Beschreibung
Administrators of DB2 11 for z/OS can acquire a view of the architecture and fundamental processes required to manage a DB2 11 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
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
Training Paths that reference this course are:
Database Administration Core
System Administration