Overview

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.

Skills Covered

  • 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

Who Should Attend

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.

Course Curriculum

Prerequisites

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

Download Syllabus

Course Modules

Request More Information

Training Options

Intake: Available Upon Request
Duration: 3 Days
Guaranteed: TBC
Modality: ILT
Price:

RM5,440.00Enroll Now

Exam:
Intake: Available Upon Request
Duration: 3 Days
Guaranteed: TBC
Modality: VILT
Price:

RM5,440.00Enroll Now

Exam: