IBM Introduction to DB2 for z/OS for Systems and Operations Personnel
- Course Code CV021G
- Duration 3 days
Course Delivery
Jump to:
Course Delivery
This course is available in the following formats:
-
Company Event
Event at company
-
Public Classroom
Traditional Classroom Learning
-
Virtual Learning
Learning that is virtual
Request this course in a different delivery format.
Course Overview
TopDB2 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.
Course Schedule
TopTarget Audience
TopThis 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.
Course Objectives
Top- 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
Course Content
TopCONTENTS:
- z/OS Prequisite Review
- DB2 Relational Database Concepts
- Structured Query Language (SQL) and SPUFI
- DB2 Objects
- The DB2 System
- DB2 Commands and Program Preparation
- DB2 Utilities
- DB2 Shutdown, Startup, and Recovery
Course Prerequisites
TopYou should have a working knowledge of z/OS, TSO, ISPF, and SDSF - sequential, partitioned, and VSAM data sets - basic JCL
- CV021G
- IBM Introduction to DB2 for z/OS for Systems and Operations Personnel
- Database Management & Development
- CV021G | IBM Introduction to DB2 for z/OS for Systems and Operations Personnel | Training Course | IBM.
- IBM