DB2 10 for z/OS Utilities for Database Administrators – CV871GCR

Enrol Details

Course Code: CV871G Brand: HDM – Db2 for z/OS Category: Analytics Skill Level: Intermediate Duration: 24H Modality:CR Audience

Please refer to course overview.

Prerequisites

You should have attended course:

_x000D_
_x000D_

DB2 9 for z/OS Database Administration Workshop Part 1 (CV830) or DB2 10 for z/OS Database Administration Workshop Part 1 (CV831), or have attained a similar level of knowledge

_x000D_

Short Summary

This course is designed to teach you advanced topics about DB2 for z/OS utilities Overview

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 (CV831) 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.

Topic

(CV831) utilities review
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)
Appendix: Clone tables

The course includes extensive machine exercises.

Objectives

Use RUNSTATS to accelerate the performance of a given SQL access

_x000D_

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

_x000D_

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

_x000D_

Load partitions in parallel

_x000D_

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

_x000D_

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

_x000D_

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

_x000D_

admin