Information
Overview
This course is designed to teach database administrators advanced topics about Db2 for z/OS utilities with a combination of lecture materials and extensive lab exercises.
Audience
Database Administrators
Prerequisites
Students should already have basic skills in the main utilities.
Objective
- RUNSTATS, DSN1COPY,REPAIR, and DIAGNOSE
- LOAD and REBUILD INDEX performance and availability
- Online CHECK DATA
- REORG performance and availability
- UNLOAD performance and availability
- Generic utility jobs (LISTDEF and TEMPLATE)
Course Outline
- RUNSTATS, DSN1COPY,REPAIR, and DIAGNOSE
- LOAD and REBUILD INDEX performance and availability
- Online CHECK DATA
- REORG performance and availability
- UNLOAD performance and availability
- Generic utility jobs (LISTDEF and TEMPLATE)
