Introduction to DB2 for zOS for Systems and Operations Personnel

• Give an overview of the DB2 9 environment
• Describe and utilize DB2 Objects
• Describe and utilize several DB2 Utilities
• Describe the DB2I (DB2 Interactive Facility) environment
• Use SPUFI (SQL Processing Using File Input) to compose and execute SQL
• Setup and execute DB2 Commands
• Understand DB2 Logging
• Describe DB2 program preparation process
• Understand DB2 startup and shutdown
• Understand and utilize DB2 recovery strategies

This course is for beginning DB2 for z/OS database administrators who need to acquire the basic skills required to administer a DB2 database in a z/OS environment.

You should have a working knowledge of

\n
• z/OS, TSO, ISPF, and SDSF
\n
• sequential, partitioned, and VSAM data sets
\n
• and basic JCL
\n

• Give an overview of the DB2 9 environment
• Describe and utilize DB2 Objects
• Describe and utilize several DB2 Utilities
• Describe the DB2I (DB2 Interactive Facility) environment
• Use SPUFI (SQL Processing Using File Input) to compose and execute SQL
• Setup and execute DB2 Commands
• Understand DB2 Logging
• Describe DB2 program preparation process
• Understand DB2 startup and shutdown
• Understand and utilize DB2 recovery strategies