Home About Courses Schedule Services Webinars Contact Search

IMS Database Recovery Control (DBRC)

SEE SCHEDULE

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

  1. 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
  2. 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
  3. 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
  4. 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
  5. 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
  6. 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
  7. 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
  8. 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
  9. 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
  10. 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
  11. 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
  12. 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
  13. 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
  14. APPENDIX B: RECON record keys
  15. APPENDIX C: RECON records recap