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.
DB2 for z/OS: Operations
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.
- 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.
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.
Face-to-face learning in the comfort of our quality nationwide centres, with free refreshments and Wi-Fi.
Find dates and prices
We have 2 courses available across 1 locations on 2 different dates
EastCall us on 0345 074 7998 to discuss availability in this region.Contact us
LondonCall us on 0345 074 7998 to discuss availability in this region.Contact us
MidlandsCall us on 0345 074 7998 to discuss availability in this region.Contact us
NorthCall us on 0345 074 7998 to discuss availability in this region.Contact us
ScotlandCall us on 0345 074 7998 to discuss availability in this region.Contact us
South1 Location / 2 coursesView dates
Attend from AnywhereCall us on 0345 074 7998 to discuss availability in this region.Contact us
All locations1 Location / 2 coursesView dates
Fully accredited to ensure we provide the highest possible standards in learning