DB2 10 for z/OS System Administration

dettagliati del corso
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