DB2 10 for z/OS System Administration (CV851G) – Outline

Detailed Course Outline

Basic architecture and fundamental mechanisms
  • Explain the principles of:
    • IPLing z/OS
    • TSO/E LOGON
    • Allocation CLIST
    • Control of DB2
    • START DB2 process
    • DSNZPARM member
    • DB2 address space structure
    • DB2 log
    • Catalog and directory
    • Data sharing feature
    • Connection process
    • Command routing process
    • Program preparation and execution processes
    • Transaction and points of consistency
  • Set up and tune the IRLM
  • Recognize the important IRLM parameters
System security
  • Protect DB2 data sets when DB2 is up or down
  • Protect connections to DB2
  • Describe the high-level operation of DB2 security exits
DB2 program flow for all environments
  • Describe DB2 program execution
  • Explain what a DB2 thread is
  • Explain commit processing
  • Describe connection types
    • DSN
    • CAF
    • IMS
    • CICS
    • RRSAF
TSO and batch environments
  • Describe TSO facilities
  • Describe the facilities of DB2I
  • Invoke the DSN command processor in various ways
  • Invoke DB2 utilities
  • Describe the QMF environment
DB2 authorization
  • Provide appropriate authorization for your user community
  • Monitor authorization in the DB2 catalog
  • Effectively assign administrative authorities like SYSADM, DBADM, and BINDAGENT
  • Create objects for others
Logging
  • Explain the basic algorithms of the DB2 logging facility
  • Set up and operate your log efficiently
  • Recover from BSDS failures
  • Recover from certain lost log data set situations
  • Explain the use of the log maintenance tools
DB2 9 for z/OS utilities
  • Categorize and discuss DB2 utilities
  • Explain how to back up and recover DB2 objects using BACKUP SYSTEM and RESTORE SYSTEM utilities
  • Define high-level qualifier for catalog and directory
  • Rename DB2 data sets
  • Print log map of BSDS
Object recovery
  • Describe the different types of application recovery
  • Perform various health checks to detect damaged data
  • Read the log using DSN1LOGP
  • Avoid certain lost log scenarios
Transaction flow in IMS and CICS
  • Describe the two-phase commit process
  • Explain thread recycling and the complete connection process for a DB2 thread
  • Describe the input to and output from a SIGNON exit
CICS - DB2 environment
  • Outline a CICS connection to DB2
  • Use the DSNC transaction
  • Encourage CICS thread recycling
Operations (monitoring and controlling DB2)
  • Monitor and control DB2
  • Train operators at your local site
  • Discuss the functions of ATS (Administrative Task Scheduler)
System recovery/restart
  • Describe the DB2 restart process following both normal and abnormal terminations
  • Prevent restart failures
  • Recover from restart failures
  • Begin planning for offsite recovery
IMS - DB2 environment
  • Integrate IMS transactions into the DB2 environment
  • Integrate IMS BATCH jobs into the DB2 environment
  • Control which plans, subsystems, and connection IDs transactions and batch jobs use
Distributed - DB2 environment
  • Describe the use of DB2 for z/OS enterprise servers in a multitier environment
  • Explain the difference between JDBC and SQLJ
  • Describe the Java database connectivity capabilities: use SQLJ and/or JDBC
  • Document the requirements to set up the DB2 and Java environment in a z/OS environment