CV972G  Db2 13 for z/OS Utilities for Database Administrators

Duration:    3 Days

Level:          Intermediate

Audience:   Systems Administrator

Next Sessions
Start (YYYY-MM-DD) End (YYYY-MM-DD) Language Amount
2024-05-06 2024-05-08 English 2175 EUR 1587
2024-05-20 2024-05-22 English 2175 EUR 1601
2024-06-03 2024-06-05 English 2175 EUR 1615
2024-06-17 2024-06-19 English 2175 EUR 1629
2024-07-01 2024-07-03 English 2175 EUR 1643
2024-07-15 2024-07-17 English 2175 EUR 1657
2024-07-29 2024-07-31 English 2175 EUR 1671
2024-08-12 2024-08-14 English 2175 EUR 1685
2024-08-26 2024-08-28 English 2175 EUR 1699
2024-09-09 2024-09-11 English 2175 EUR 1713
2024-09-23 2024-09-25 English 2175 EUR 1727
2024-10-07 2024-10-09 English 2175 EUR 1741
2024-10-21 2024-10-23 English 2175 EUR 1755
2024-11-04 2024-11-06 English 2175 EUR 1769
2024-11-18 2024-11-20 English 2175 EUR 1783
2024-12-02 2024-12-04 English 2175 EUR 1797
2024-12-16 2024-12-18 English 2175 EUR 1811
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.

Prerequisites

Students should already have basic skills in the main utilities. 

  • 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)
  • 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)