DB2 9 for z/OS Utilities for Database Administrators
- Vendor:
- IBM Corporation
- Course:
- CV870
- Start Date:
- Wednesday, October 3, 2012
- Length:
- 3 Days
- Location:
- Atlanta, GA
- Tuition:
- $2,010
-
May
30
Atlanta, GA
Course Description
This is the classroom version of Instructor Led Online DB2 9 for z/OS Utilities for Database Administrators ILO (3V870)
This course is designed to teach you advanced topics about DB2 for z/OS utilities. It is assumed that you attended course DB2 9 for z/OS Database Administration Workshop Part 1 (CV830) so that you already have basic skills about the main utilities. Recovery-oriented topics are not part of this course, so such utility functions are not presented.
Skills Gained
- DB2 9 for z/OS Database Administration Workshop Part 1 (CV830) utilities review
- More on utilities and their functions (RUNSTATS, DSN1COPY, REPAIR, 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)
- Appendix: Clone tables
The course includes extensive machine exercises.
Who Can Benefit
This is an intermediate course for DB2 for z/OS database administrators who have basic skills required to administer a DB2 database and want to extend their skills.
Prerequisites
You should have complete:
- DB2 9 for z/OS Database (CV830)
- Administration Workshop Part 1, or have attained a similar level of knowledge.
