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
 
 
Duration5 Days
Delivery MethodInstructor Led, Hands-on workshops
Public Price$3200.00


DESCRIPTION (Return to Top)

Starting with a logical data model we guide you through the implementation of a fully functional DB2 production database. During the hands-on workshops you will create basic database objects, use DB2 utilities to populate, manage and recover your objects and perform basic management and monitoring procedures. Physical Database Implementation and control are the key issues addressed by this course. The majority of the content concentrates on the Application DBAs 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:

  • Describe the DB2 System and Data Objects
  • Create DB2 Data Objects
  • Implement DB2 Naming Conventions
  • Identify the DB2 System Objects impacted when creating Data Objects
  • Manage DB2 Tablespace and Index Spaces
  • Use the DB2 Catalog to monitor your DB2 Databases
  • Alter your DB2 Data Objects for performance and usability
  • Populate and maintain DB2 Databases using the DB2 utilities
  • Prepare your Database for Recovery
  • Perform basic Database Recovery
  • Use DB2 commands to monitor DB2 databases
  • Identify 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


PREREQUISITES (Return to Top)

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