DB2 10 for z/OS System Administration

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