On-site & Public, Instructor-led, Hands-on IT Training
(International 01) 908.233.8900
  400+ Course Offerings:

Search for Course:

DB3010 DB2 for z/OS Database Administration
Duration 5 Days
Delivery Method Instructor Led, Hands-on workshops
Public Price $2950.00

DESCRIPTION (Return to Top)

This course provides guidance information for Database and System Administration personnel responsible for the DB2 production and test Data Bases. The course covers creation, utility support, recovery, monitoring and management of DB2 Databases. Physical Database Implementation and control are the key issues addressed by this course. The majority of the course concentrates on the Application DBA role and responsibilities.

AUDIENCE (Return to Top)

DB2 Database and System Administrators who will be designing and managing DB2 Databases.

OBJECTIVES (Return to Top)

Upon successful completion of this course, the student will be able to:

  • Understand The DB2 System and Data Objects
  • How to Create the DB2 Data Objects
  • DB2 Naming Conventions
  • The DB2 System Objects impacted when creating Data Objects
  • DB2 Tablespace and Index Space Management
  • How to use the DB2 Catalog to monitor your DB2 Databases
  • How to Alter your DB2 Data Objects for performance and usability
  • How to populate and maintain DB2 Databases using the DB2 utilities
  • How to prepare for Recovery
  • DB2 Database Recovery
  • How to use DB2 commands to monitor DB2 databases
  • Security authorization requirements
  • Support your Development Group

TOPICS (Return to Top)
  • Introduction
  • Database Object Creation
  • Table Creation
  • Indexes
  • Populating Your Database
  • Preparing Your Database for Use
  • Altering Tablespace Objects
  • REORG Utility
  • Altering Tables, Indexes and Adding Views
  • Introduction to Recovery
  • Application Support


Introduction to DB2 & SQL coding basics (DB1000); TSO/ISPF, MVS JCL (MF1010).