Db2 for z/OS Systems Programmers - Installation, Migration, Operation & Recovery

What you will learn

On successful completion of this course you will be able to:

• understand the db2 installation process
• 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
• interpret common error messages, and decide upon the actions required
• plan for Db2 migration
• describe the address space structure and components of a Db2 subsystem
• describe the address space structure and components of a Db2 subsystem
• understand and implement Db2 system and data recovery and restart procedures
• understand the control and use Db2 trace information to perform system and application tuning
• describe the concepts of Db2 data sharing and its uses
• describe the need for the Coupling Facility structures used by Db2 data sharing
• understand how data sharing is implemented and controlled
• identify monitoring and performance issues for a Db2 data sharing environment.
• understand the commonly used problem determination tools
• implement security for the Db2 system.

Who Should Attend

Systems Programmers working in a Db2 for z/OS environment.

Prerequisites

A sound understanding of the z/OS computing environment and an understanding of Db2 for z/OS at the conceptual and terminological levels.

Duration

5 days

Fee (per attendee)

P.O.A.

This includes free online 24/7 access to course notes.

Hard copy course notes are available on request from rsmshop@rsm.co.uk

at £50.00 plus carriage per set.

Course Code

DSAX

Contents

Db2 System Architecture

Architecture overview; Working Storage Areas; Buffer, Sort, RID & EDM pools; Buffer Pools - 64 bit addressing; EDM pool; Sort pool; RID pool; Db2 Attachments; System data sets & databases; Db2 objects; Object characteristics; SQL overview; DB2 Interactive (DB2I); Basic Db2 operations; Db2 commands; DB2I commands panel.

Db2 System Installation & Migration Overview

Definitions; Db2 modes (Db2 11); Db2 Function Levels (Db2 12); Installation / Migration step; The major Installation / Migration tasks; Additional tasks and jobs; Loading Db2 libraries (the SMP/E process); The installation CLIST; Invoking the installation CLIST; Updating the CLIST defaults (DSNTIJXZ); DSNTIPA1 - Installation CLIST Main Panel; DSNTIP0A - data sharing options (Type INSTALL); DSNTIP0B - data sharing options (Type MIGRATE); Installation CLIST Panels (Db2 12 for z/OS); Optional Installation Panels; DSNTIPC, DSNTIPC1 - CLIST calculations; The customised jobs; Jobs DSNTIJUx - Define parameters.

Db2 System Migration & Modification

Migration considerations; Pre-migration queries (DSNTIJPM); Migration compatibility; Migration tasks; Prerequisites & maintenance level of current system; Integrity of current system; Back-up current system; Migration steps; Other migration tasks; Fallback; Enabling New Function Mode (ENFM) jobs; Activate (change Function Level) jobs; Updating Db2 - using the installation CLIST; Updating Db2 - modifying the generated job(s); Invoking modified parameters; -SET SYSPARM command.

Data Sharing Overview

Parallel sysplex; the Coupling Facility; Db2 data sharing concepts; reasons for data sharing; data integrity issues; Coupling Facility structures.

Data Integrity & Consistency

Group buffer pools; GBP processing; GBP parameters; lock structure; controlling global locking; real and false lock contention; lock negotiation; shared communications area.

Implementing Data Sharing

Enabling data sharing; adding additional members to data sharing group; merging data.

Db2 Data Recovery

Backup & recovery components; Invoking online utilities using Db2i; Invoking utilities - dataset names; Invoking utilities - control statements; Controlling utilities using Db2i; COPY utility; COPYTOCOPY; MERGECOPY utility; QUIESCE utility; RECOVER utility; Point-In-Time recovery; REBUILD INDEX utility; REPORT utility; MODIFY utility; Other online utilities; Stand-alone utilities (service aids); Catalog & directory recovery; Catalog & directory point in time recovery; P-I-T recovery implications.

Db2 System Recovery

Db2 command format; Starting Db2; Integrity - normal termination; Integrity - abnormal termination; Log Initialisation; Current Status Rebuild; Forward Log Recovery; Backward Log Recovery; Processing log records; In-doubt resolution; Deferred restart: effect on committed UORs, effect on in-flight UORs; Delaying backout of long running tasks; Effect of delaying backout; Conditional restart: Control Record, log Truncation / limit restart, bypass backout / cold start; Conditional restart implications; Maintaining data integrity with conditional restart; Stopping Db2; BACKUP SYSTEM utility; BACKUP SYSTEM control data; RESTORE SYSTEM utility; Restoring to a point in time.

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; Logging parameters - size & number of logs; logging parameters - checkpoints; Checkpoint records; Forcing an archive log.

Stand-Alone Utilities (service aids)

Invoking stand-alone utilities; DSN1COPY stand-alone utility; DSN1PRNT stand-alone utility; DSNJU004 (print log map) stand-alone utility; DSNJU003 (change log inventory) stand-alone utility; DSN1LOGP stand-alone utility; DSN1CHKR stand-alone utility; DSN1COMP stand-alone utility; DSNJLOGF stand-alone utility; DSNJCNVB stand-alone utility.

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.

Catalog & Directory Recovery

Catalog / Directory recovery implications; Recovery sequence; Catalog & Directory point-in-time recovery; Recovery implications - DEFINE option; Recovery implications - FASTSWITCH; Recovery implications - identity columns & sequences; System-wide points of consistency.

Operational Considerations for Data Sharing

Commands; Db2 member failure; retained locks; Coupling Facility failure; duplexing group buffer pools; recovery considerations; using and monitoring data sharing environments; performance considerations.

Db2 Security Administration

Security overview; Address space authorisation; Protected access profiles; Permitting RACF access; Protecting Db2 datasets; Security management (Db2 or RACF); Security strategy (Transaction Manager or Db2); Security management (centralised or decentralised); Traditional Db2 security mechanism; Security terminology; Authorisation id; Maintaining security; Data Control Language; Administrative authorities; Additional administrative authorities; Explicit & implicit privileges; Ownership considerations; Level of access; Using VIEWs; Multi-Level Security overview; Security labels; Row level granularity; Multi-Level Security and SELECT; Multi-Level Security and INSERT; Multi-Level Security and UPDATE; Multi-Level Security and DELETE; Multi-Level Security and utilities; Row and column access; Row permissions; Column masks; Db2 security using RACF profiles; RACF / Db2 External Security Module; Installation; Mapping Db2 authorisation checks; Scope of RACF classes; Multi-subsystem scope classes; Single subsystem scope classes; Customisation; Db2 objects and RACF classes; Profiles.

Connecting to Db2

Db2 Attachments; Db2 connections (Attachments); Universal Language Interface Module (DSNULI); DSNULI entry points; TSO Attachment; Job DSNTIJVC - Build the CLIST library; Make libraries available to TSO; Connect DB2I panels to main panel; Invoking TSO Attachment; CICS Attachment; CICS / Db2 connection; Defining Db2CONN; Defining Db2ENTRY; Defining Db2TRAN; Controlling CICS Attachment; IMS Attachment; IMS Subsystem Member (SSM); Subsystem Member relationships; Resource Translation Table (RTT); Controlling the IMS attachment; IMS Subsystem Member (SSM); Subsystem Member relationships; Resource Translation Table (RTT); Controlling the IMS attachment; Distributed Data Facility; VTAM components; Enabling TCP/IP communication; Communications tables; Distributed security.

Db2 Monitoring & Control

Db2 commands; Controlling the Db2 subsystem; Controlling the IRLM; Controlling the TSO Attachment; Controlling the CICS Attachment; Controlling the IMS Attachment; Issuing commands using Db2 Interactive; Controlling Distributed Data Facility; Controlling logging; Controlling buffer pools; Controlling data sharing; Controlling utilities; Controlling Resource Limit Facility; Controlling databases; Controlling threads; Controlling procedures; Controlling functions; Db2 traces; Trace classes; Controlling traces.

Problem Determination

Basic code structure; Db2 subcomponents; Db2 control block structure; Db2 page sets; Page set structure; Index structure; Index keys and pointers; Data navigation; RIDs, map ids, pointers and holes; Row headers; Row data format; Versions and system pages; OBDREC entries; Version examples; Identifying and handling problems; Basic dump analysis; 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 datasets.

Performance Overview

What is 'performance'?; Performance objectives; Workload categories; Service Level Agreements; Performance factors; System parameters; EDM pool size; Buffer pool sizes; Bufferpool thresholds; Bufferpool development; Database design factors; Application design factors; Db2 traces.