DB2 10 for z/OS System Administration Schulung

• 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

Seminar-Ziele:

• 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
• Explain the use of Roles and Trusted Context
• Implement security procedures for a DB2 environment
• Describe the components and address space structure of a DB2 subsystem
• Explain DB2 Program Flow for all environments
• Explain parameter settings for the IRLM
• Display storage values for the IRLMPROC
• Dynamically change IRLM storage
• Estimate lock storage required for the IRLM
• Invoke and use DB2 TSO Facilities
• Use the DB2 Catalog to monitor authorizations
• Increase the size of the Active Log data sets
• Explain DB2 Logging
• Use SET LOG SUSPEND and SET LOG RESUME
• Use DSNJU004 to Print Log Map
• Interpret the output of Print Log Map
• Use DSNJU003 to rename DB2 data sets
• Plan for recovery of a BSDS failure
• Monitor and control DB2
• Explain transaction flow in IMS and CICS
• Describe the CICS and DB2 environment
• Explain the difference between JDBC and SQLJ