CV87: DB2 10 for z/OS Utilities for Database Administrators

Code: CV87
Duration: 3 days

Description

This course is designed to teach you advanced topics about DB2 for z/OS utilities. It is assumed that you attended course DB2 10 for z/OS Database Administration Workshop Part 1 (CV83) 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.

Outcomes

Use RUNSTATS to accelerate the performance of a given SQL access

Employ DSN1COPY, REPAIR, and DIAGNOSE for DBA tasks which are not recovery-oriented

Use parallel index build with the LOAD, REORG and REBUILD INDEX utilities

Load partitions in parallel

Determine the appropriate LOAD options to use while considering concurrency and performance requirements

Choose appropriate options with REORG and UNLOAD to achieve optimal performance and availability

Provide appropriate LISTDEF, TEMPLATE, and OPTIONS utility control statements for use in DB2

Audience

This intermediate course is 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 attended:

course DB2 10 for z/OS Database Administration Workshop Part 1 (CV83)or have attained a similar level of knowledge