Course details

DB2 11 for z/OS beginning 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.

Target Audience:

  • This beginning DB2 basic 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.

Objectives:

  • Describe several services provided in a z/OS environment
  • Explain workloads in the batch environment
  • Explain workloads in the online environment
  • Create and modify data set content
  • Give an overview of the DB2 9 environment
  • Describe and utilize DB2 Objects
  • Describe job roles in a z/OS environment
  • Describe and utilize several DB2 Utilities
  • Log On to TSO/E
  • Describe the DB2I (DB2 Interactive Facility) environment
  • Navigate TSO/E and ISPF
  • Use SPUFI (SQL Processing Using File Input) to compose and execute SQL
  • Use TSO commands
  • Setup and execute DB2 Commands
  • Setup and utilize JCL (Job Control Language)
  • Understand DB2 Logging
  • Describe DB2 program preparation process
  • Describe the different types of data sets in a z/OS environment
  • Understand DB2 startup and shutdown
  • Allocate data sets and list data set information and content
  • Understand and utilize DB2 recovery strategies

Pre-Requisites

There are no formal prerequisites for this course.

Updated on 13 August, 2015

About Global Knowledge Egypt

Global Knowledge is the worldwide leader in IT and business skills training. They deliver via training centers, private facilities, and the Internet, enabling their customers to choose when, where, and how they want to receive training programs and learning services.

See all Global Knowledge Egypt courses
Are you from Global Knowledge Egypt ? Claim your course!
Courses you can instantly connect with... Do an online course on Database Management starting now. See all courses

Is this the right course for you?

Rate this page

Didn't find what you were looking for ?

or