> > > CV851G Detaillierte Beschreibung

DB2 10 for z/OS System Administration (CV851G)

Kursbeschreibung Kurstermine Detaillierter Kursinhalt

Detaillierter Kursinhalt

Basic architecture and fundamental mechanisms

  • Explain the principles of:
    • IPLing z/OS
    • 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


  • 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