02 9482 8200 info@datasync.com.au

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

Format

Classroom and hands on lab exercises.

Course Schedule »