Db2 13 for z/OS Utilities for Database Administrators (CV972G)

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)
mostrar detailes

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)