Kurs Db2 12 for zOS: Basics for DBA Beginners (CV042G)

Seminarinhalte

• Describe several services provided in a z/OS environment
• Explain workloads in the batch environment
• Explain workloads in the online environment
• Describe job roles in a z/OS environment
• Log On to TSO/E
• Navigate TSO/E and ISPF
• Use TSO commands
• Setup and utilize JCL (Job Control Language)
• Utilize SDSF
• Describe the different types of data sets in a z/OS environment
• Allocate data sets and list data set information and content
• Create and modify data set content
• 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