On-site & Public, Instructor-led, Hands-on IT Training
800.756.3000
(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.



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 build 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


TOPICS (Return to Top)
  • Introduction
  • Database Object Creation
  • Basic Table Creation
  • Indexes
  • Populating Your Database
  • Preparing Your Database for Use
  • REORG Utility
  • Altering your Tablespace Objects
  • Altering Tables and Indexes
  • Advanced Object Creation
  • Introduction to Recovery
  • Introduction to Performance


PREREQUISITES (Return to Top)

Introduction to DB2 & SQL coding basics; MVS JCL, TSO, ISPF, EDIT.