|
|
|
|
|
NWDB3010 DB2 for z/OS Database Administration
DESCRIPTION
This 5 day 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
DB2 Database and System Administrators who will be designing and managing DB2 Databases.
OBJECTIVES
Upon successful completion of this course, the student will be able to:
- 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 Update the DB2 Catalog to reflect production volumes in test
- 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
- Introduction
- System Structure Overview
- Database Object Creation
- Indexes
- Partitioning
- DB2 Commands
- The DB2 Catalog
- DB2 Utilities Overview
- Loading & Managing DB2 Databases
- CHECK
- Backup
- Recovery
- RUNSTATS & REORG
- Database Performance
- EXPLAIN & THE PLAN_TABLE
- Database Operations and Procedures (Optional)
PREREQUISITES
Introduction to DB2 & SQL coding basics; MVS JCL, TSO, ISPF, EDIT.
|
|
|
|
