z/OS and DB2 Basics for DB2 for z/OS DBA Beginners Cairo

Course details

DB2 11 for z/OS beginning DBAs can develop fundamental skills or recognition through lectures and hands-on exercises of:

• TSO/E and ISPF
• Data sets
• DB2 Objects
• Structured Query Language
• DB2 Commands
• JCL and SDSF
• DB2 Utilities
• DB2 Logging
• DB2 Program Preparation

The course materials cover DB2 11 for z/OS.

Target Audience:

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

Objectives:

• Describe several services provided in a z/OS environment
• Explain workloads in the batch environment
• Explain workloads in the online environment
• Create and modify data set content
• Give an overview of the DB2 9 environment
• Describe and utilize DB2 Objects
• Describe job roles in a z/OS environment
• Describe and utilize several DB2 Utilities
• Log On to TSO/E
• Describe the DB2I (DB2 Interactive Facility) environment
• Navigate TSO/E and ISPF
• Use SPUFI (SQL Processing Using File Input) to compose and execute SQL
• Use TSO commands
• Setup and execute DB2 Commands
• Setup and utilize JCL (Job Control Language)
• Understand DB2 Logging
• Describe DB2 program preparation process
• Describe the different types of data sets in a z/OS environment
• Understand DB2 startup and shutdown
• Allocate data sets and list data set information and content
• Understand and utilize DB2 recovery strategies

Pre-Requisites

There are no formal prerequisites for this course.