Code: CV04
Duration: 5 days
Description
DB2 11 for z/OS beginner 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.
Outcomes
- 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 description 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
Audience
This beginner’s DB2 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.
Prerequisites
There are no formal prerequisites for this course.
Format
Classroom and extensive hands on lab exercises.
Please contact us for more information.