IMS Database Recovery Control (DBRC)

Duration: 5 Days

Method: Instructor led, Hands-on workshops

Price: $2950.00

Course Code: IM2010

Audience

IMS professionals (systems programmers, database administrators, senior application programmers, technical support staff) who want a detailed understanding of DBRC and its use in managing and recovering IMS logs, databases, and systems

Objectives

Upon successful completion of this course, the student will be able to:

Allocate, initialize, maintain and recover RECON datasets
Use the GENJCL function to build JCL for IMS database and log recovery utilities
Use and maintain DBRC log dataset information
Register full function, Fast Path DEDB, and HALDB databases in order to manage recovery and to protect against invalid use of them
Describe the authorization process and its function in protecting database integrity
Describe the interaction between IMS database utilities and DBRC
Use and maintain DBRC’s information about database reorganizations, image copies, change accumulations, recoveries and batch backouts
Understand, use, and maintain the information in your installation’s RECON

Prerequisites

A working knowledge of TSO/ISPF, z/OS JCL, VSAM AMS, and an understanding IMS database utilities and IMS online logging.

Topics

I. DBRC Overview
- Environments that require
- Functions
- Subsystem definition
- System Log control
- Database recovery support
- Database open/update check
- Data sharing support
- Tracking subsystems
- Supporting IMSplex
- Database registration required for
- Fast Path DEDB registration required for
- HALDB registration required
- Components
II. RECON Data Sets
- Purpose, records, and rules
- Planning considerations
- Initializing
- Recovery Control Utility
- Executing DSPURX00
- Time stamps
- RECON status information
- Online DBRC commands
- RECON records formats and keys
- HANDS ON LAB
III. Subsystem Interaction
- Overview
- Sign-on Normal
- Authorization
- Sign-off Normal
- Sign-off Abnormal
- Sign-on Recovery Start
- Sign-on Recovery End
- Sign-on Failures
- Abends with and without ESTAE
- Subsystem commands: CHANGE, DELETE, LIST, NOTIFY
- HANDS ON LAB
IV. Logging
- Overview
- Implementation
- Batch Log Control: PRILOG family of records, archiving
- DBRC commands for Batch job step logs
- IMS Online Logging: description of OLDS, SLDS, RLDS
- PRIOLD / SECOLD records
- Archiving
- PRISLD / SECSLD records
- PRILOG / SECLOG records for online
- PRILOG family inactive log data set compression
- DBRC Commands for OLD, SLDS, RLDS: CHANGE, DELETE, LIST
- DBRC log records: keys and layout
- HANDS ON LAB
V. Database Registration
- Registration required for
- Registration overvies
- Full function registration: command and parameters
- Share level descriptions
- Non-recoverable databases
- Full function database records (DB, DBDS): information and usage
- Fast Path DEDB Registration: commands and parameters
- Fast Path DEDB records (DB, AREA, ADS): information and usage
- HALDB Registration: commands and parameters
- HALDB records (MASTER, PARTITION, DBDS): information and usage
- Commands to:
  - Change information for DB, DBDS, AREA, PARTITION
  - Remove subsystem authorization
- GROUPS: definition of types, commands to create, change, and list
- RECON DATABASE RECORDS summary and record keys
- HANDS ON LAB
VI. Subsystem Interaction & Authorization
- Overview
- Requested by / Released by
- Subsystem access inter
- Authorization checks: database not registered, authorization prohibited, image copy needed, read only, quiesce held or in progress, backout needed, recovery needed, access intent compatibilitiy, encoded and held authorization states
- Authorization failures
- IRLM compatibility checks
- OPEN for update processing checks
- Data set first update: DSSN, USID
- I/O errors
- Un-authorization
- LIST.HISTORY command
- NOTIFY.ALLOC command
- Authorization records summary
- HANDS ON LAB – authorization
- HANDS ON LAB- Reorganization and Image Copy
VII. Reorganization & Image Copy
- Database utilities overview
- Utility interfaces
- Utility interaction with DBRC
- Unload, Scan Reload, Prefix update
- HALDB Online Reorg
- DBRC Commands for Reorg records
- Image Copy (batch, concurrent, image copy 2,)
- Image copy completion: DBRC RECON record cleanup
- GENMAX and RECOVPD
- DBRC Commands for IMAGE records
- RECON REORG & IMAGE record summary and keys
VIII. Change Accumulation
- Why run
- Groups
- Commands for CAGRP
- RECON records for CAGRP and CA executions
- CA & CAGRP Commands: LIST, CHANGE, DELETE
- CA log selection
- RECON records, keys & summary
- HANDS ON LAB
IX. Database Recovery
- Overview
- DBRC recovery interactions
- GENJCL recovery
- Selecting full recovery input
- Selecting time stamp recovery input
- Sample recovery skeletal JCL
- HALDB Index / ILDS rebuild
- RECON database recovery records, keys & summary
- HANDS ON LAB
X. Generating JCL
- GENJCL overview
- DSPURX00 JCL
- Skeletal JCL
- Command and parameters
- Keywords and keyword resolution (control and simple)
- Archive skeleton JCL and resolved execution JCL
- DD statements (concatenated or multiple)
- GENJCL.USER example for batch backout
- GENJCL summary
XI. Batch Backout
- Control statements
- Log verification
- Backing out abended DLI / DBB job step
- Online dynamic backout failure
- Unit of Recovery (UOR) definition
- BACKOUT record: example, usage, indicators, indoubt
- Batch backout for online: case 1 and case 2
- Batch backout termination for online
- Batch backout DBRC commands
- RECON BACKOUT record summary & key
XII. RECON Maintenance
- Tracking RECON status
- Cleaning up the RECONs
- Repairing the RECONs
- Reorganizing the RECONs
- Reconfiguration of the RECONs
- Recovering the RECONs
- RECON out of sync process
- HANDS ON LAB
XIII. APPENDIX A: DBRC System Programming issues
- Installation
- Data set allocation
- Data set authority
- Avoiding RECON contention
- Dynamic Allocation
- Physical Open
- Logical Open
- Upgrading to new version
- Loss notification
- Command authorization
- PRILOG family of records control
- Application Programming Interface (API)
- Parallel RECON access for IMSplex
XIV. APPENDIX B: RECON record keys
XV. APPENDIX C: RECON records recap