Arrow Education reçoit la certification QUALIOPI
La certification QUALIOPI permet à nos clients de faire financer les formations de leurs collaborateurs par les organismes financeurs.
Introduction to DB2 for zOS for Systems and Operations Personnel
CODE: CV021G
DURÉE: 21 Hours (3 Jours)
PRIX H.T.: €2 325,00
Description
DB2 11 for z/OS beginning DBAs can develop fundamental skills or recognition through lectures and hands-on exercises of:
- DB2 Objects
- Structured Query Language
- DB2 Commands
- DB2 Utilities
- DB2 Logging
- DB2 Program Preparation
The course materials cover DB2 11 for z/OS.
Objectifs
- 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
Audience
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.
Prérequis
You should have a working knowledge of
- z/OS, TSO, ISPF, and SDSF
- sequential, partitioned, and VSAM data sets
- and basic JCL
Programme
- 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