About this Course

Duration 1 Day

This course provides attendees with a comprehensive introduction to the operation of Db2 for z/OS systems. The course examines normal start-up, operation, and shut-down of the Db2 system, plus the additional steps that may be required following an abnormal termination. The need for deferred and conditional restarts is discussed, as are the methods of setting these up, and evaluating any additional work that may be required following the use of these methods. The diagnosis and resolution of other problems that may occur are also discussed, such as out of sync. Log files, out of space datasets, and read/write errors on recovery datasets.


While in-depth knowledge of Db2 is not required, a basic understanding of relational databases would be beneficial. Familiarity with TSO/ISPF, JCL and operations in a z/OS environment is assumed.

Delegates will learn how to

  • describe the actions taken during normal start-up, operation, and shut-down of the Db2 system
  • explain the actions to take during start-up following an abnormal termination
  • understand the need for deferred restart, how it is controlled, and the effect it will have on the Db2 system and data
  • explain the need for conditional restart, how it is controlled, and the effect it will have on the Db2 system and data
  • analyse any outstanding work following a conditional or deferred restart, and take the actions required to complete it
  • interpret common error messages, and decide upon the actions required.


Db2 Overview

Architecture overview; Working Storage Areas; Storage Pools; Buffer Pools; Db2 attachments; Logging & Recovery Data Sets; System databases; Db2 Objects; Object characteristics; SQL overview; Db2 Interactive (Db2i).

Db2 System & Operations

Issuing Db2 commands; Starting Db2; Phase 1: Log Initialisation; Phase 2: Current Status Rebuild; Phase 3: Forward Log Recovery; Phase 4: Backward Log Recovery; Processing log records; Controlling Lock Manager (IRLM); Controlling Distributed Data Facility; Controlling CICS attachment; Controlling IMS attachment; Db2 commands to control other resources; Stopping Db2.

Db2 Logging

Db2 logging; Unit of Recovery; Two-phase commit protocol; Active log parameters; Checkpoint parameters; Checkpoint records; Logging commands: SET LOG, DISPLAY, ARCHIVE.

Abnormal Termination & Restart

Db2 error messages & reason codes; Data integrity considerations; Log initialisation / Current Status Rebuild; Forward log recovery; Backward log recovery; In-doubt resolution; Processing log records; Deferred restart; Deferred restart: effect on committed UoRs, effect on in-flight UoRs; Limiting backout of long running task; Effect of delaying backout; Conditional restart; Conditional Restart Control Record; Conditional restart: log truncation, limit restart, bypass backout, cold start, what's lost?, DSN1LOGP, cleaning up.

Problem Analysis and Handling

Basic code structure; Db2 subcomponents; Db2 control blocks; Messages & codes; Basic dump analysis; identifying SQL statement; Diagnosis tools: traces, utilities; Possible problem areas.

1 Day

Training delivered by an IBM Global Training Provider
Delivery Method

Delivery method


Face-to-face learning in the comfort of our quality nationwide centres, with free refreshments and Wi-Fi.

Find dates and prices

Online booking is currently not available for this course, to find out more please call us on 0113 220 7150 or email us at info@qa.com to discuss how we can help.

Trusted, awarded and accredited

Fully accredited to ensure we provide the highest possible standards in learning

All third party trademark rights acknowledged.