DB2 for z/OS: Operations

Objectives

On successful completion of this course attendees will be able 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.

Who Should Attend

This course is suitable for all those involved in the day to day operation of a DB2 for z/OS sub-system.

Prerequisites

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.

Contents.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.

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 Redo/Undo records; Deferred Restart; Deferred Restart - effect on committed UoRs; Deferred Restart - effect on in-flight UoRs; Delaying backout of long running tasks; Effect of delaying backout; Conditional restart; Conditional restart control record; Conditional restart - log truncation; Conditional restart - limit restart; Conditional restart - bypass backout; Conditional restart - cold start; Conditional restart - What's lost?; Conditional restart - DSN1LOGP; Conditional restart - cleaning up.

Problem Resolution

Basic code structure; DB2 subcomponents; DB2 control blocks; Page set structure; Problem handling; basic dump analysis; Identifying SQL statement; Diagnosis tools: traces, utilities; Possible problem areas; Active log out of space; Active log I/O errors; Archive log I/O errors; BSDS errors; Forced single BSDS mode; Recovering BSDS; Data errors; Down level data sets.