CV021G - Introduction to DB2 for z/OS for Systems and Operations Personnel

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.

Duration: 3.0 days

Enquire Now

Start learning today!

Click Hereto customize your Training


  • 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


  • 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 Summary


Day 1

  • Unit 1: z/OS Prerequisite Review
  • Exercise 1: Connecting to z/OS and Creating Data Sets
  • Exercise 1 Review
  • Unit 2: DB2 Relational Database Concepts
  • Unit 3: Structured Query Language (SQL) and SPUFI
  • Exercise 2: SQL and SPUFI
  • Exercise 2 Review
  • Unit 4: DB2 Objects (Databases and Table Spaces)
  • Exercise 3: Databases and Table Spaces
  • Exercise 3 Review
  • Unit 4: DB2 Objects (Tables, Indexes, and Views)

Day 2

  • Exercise 4: Tables, Indexes, and Views
  • Exercise 4 Review
  • Unit 4: DB2 Objects (Qualified Names, Implicit Object Creation, and SQL Statements)
  • Exercise 5: Qualified Names, Implicit Object Creation, and SQL Statements
  • Exercise 5 Review
  • Unit 5: The DB2 System
  • Exercise 6: The DB2 System
  • Exercise 6 Review
  • Unit 6: DB2 Commands and Program Preparation

Day 3

  • Exercise 7: DB2 Commands
  • Exercise 7 Review
  • Unit 7: DB2 Utilities
  • Exercise 8: DB2 Utilities
  • Exercise 8 Review
  • Unit 8: DB2 Shutdown, Startup, and Recovery
  • Exercise 9: DB2 Recovery
  • Exercise 9 Review
  • Unit 9: Course Summary


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.


  • Z/OS, TSO, ISPF, and SDSF
  • Sequential, partitioned, and VSAM data sets
  • Basic JCL



This course is not associated with any Certification.

Course Benefits

  • Career growth
  • Broad Career opportunities
  • Worldwide recognition from leaders
  • Up-to Date technical skills
  • Popular Certification Badges

IBM Popular Courses


"IBM OpenPages: Create Standard Reports-Part 5" is a tutorial or instructional module that is likely part of a series on using the IBM OpenPages software. In th


"IBM Safer Payments Hands-On Technical Primer Training (V6.3)" is an immersive and practical learning program designed to equip participants with the essential


"IBM Safer Payments Hands-On SysOps Training (v6.3)" is a specialized and practical training program offered by IBM. This training focuses on educating System O
Enquire Now
By clicking "Submit", I agree to the Terms Of Use and Privacy Policy