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