Curso IMS Database Recovery Control (DBRC)

  • Mainframe | Cobol

Curso IMS Database Recovery Control (DBRC)

40h
Visão Geral


Objetivo

Após a conclusão deste curso, você será capaz de:

  • Alocar, inicializar, manter e recuperar conjuntos de dados RECON
  • Use a função GENJCL para construir JCL para banco de dados IMS e utilitários de recuperação de log
  • Use e mantenha as informações do conjunto de dados de log DBRC
  • Registre os bancos de dados de função completa, Fast Path DEDB e HALDB para gerenciar a recuperação e proteger contra o uso inválido deles
  • Descrever o processo de autorização e sua função na proteção da integridade do banco de dados
  • Descrever a interação entre utilitários de banco de dados IMS e DBRC
  • Use e mantenha as informações do DBRC sobre reorganizações de banco de dados, cópias de imagens, acúmulos de alterações, recuperações e backouts de lote
  • Entenda, use e mantenha as informações no RECON da sua instalação
Publico Alvo
  • Profissionais de IMS (programadores de sistemas, administradores de banco de dados, programadores de aplicativos sênior, equipe de suporte técnico) que desejam uma compreensão detalhada do DBRC e seu uso no gerenciamento e recuperação de logs, bancos de dados e sistemas do IMS
Pre-Requisitos
  • Um conhecimento prático de TSO/ISPF, z/OS JCL, VSAM AMS e uma compreensão dos utilitários de banco de dados IMS e log on-line do IMS.
Informações Gerais

Carga Horária: 40h

  • Se noturno este curso é ministrado de Segunda-feira à sexta-feira, das 19h às 23h
  • Se aos sábados este curso é ministrado das 9h às 18h
  • Se in-company por favor fazer contato para mais detalhes.

Formato de entrega: 

  • 100% on-line ao vivo, via Microsoft Teams na presença de um instrutor/consultor ativo no mercado.
  • Nota: não é curso gravado. 

Lab:

  • Laboratório + Exercícios práticos
Materiais
Português | Inglês
Conteúdo Programatico

DBRC Overview

  1. Environments that require
  2. Functions
  3. Subsystem definition
  4. System Log control
  5. Database recovery support
  6. Database open/update check
  7. Data sharing support
  8. Tracking subsystems
  9. Supporting IMSplex
  10. Database registration required for
  11. Fast Path DEDB registration required for
  12. HALDB registration required
  13. Components

RECON Data Sets

  1. Purpose, records, and rules
  2. Planning considerations
  3. Initializing
  4. Recovery Control Utility
  5. Executing DSPURX00
  6. Time stamps
  7. RECON status information
  8. Online DBRC commands
  9. RECON records formats and keys
  10. HANDS ON LAB

Subsystem Interaction

  1. Overview
  2. Sign-on Normal
  3. Authorization
  4. Sign-off Normal
  5. Sign-off Abnormal
  6. Sign-on Recovery Start
  7. Sign-on Recovery End
  8. Sign-on Failures
  9. Abends with and without ESTAE
  10. Subsystem commands: CHANGE, DELETE, LIST, NOTIFY
  11. HANDS ON LAB

Logging

  1. Overview
  2. Implementation
  3. Batch Log Control: PRILOG family of records, archiving
  4. DBRC commands for Batch job step logs
  5. IMS Online Logging: description of OLDS, SLDS, RLDS
  6. PRIOLD / SECOLD records
  7. Archiving
  8. PRISLD / SECSLD records
  9. PRILOG / SECLOG records for online
  10. PRILOG family inactive log data set compression
  11. DBRC Commands for OLD, SLDS, RLDS: CHANGE, DELETE, LIST
  12. DBRC log records: keys and layout
  13. HANDS ON LAB

Database Registration

  1. Registration required for
  2. Registration overvies
  3. Full function registration: command and parameters
  4. Share level descriptions
  5. Non-recoverable databases
  6. Full function database records (DB, DBDS): information and usage
  7. Fast Path DEDB Registration: commands and parameters
  8. Fast Path DEDB records (DB, AREA, ADS): information and usage
  9. HALDB Registration: commands and parameters
  10. HALDB records (MASTER, PARTITION, DBDS): information and usage
  11. Commands to:
  12. Change information for DB, DBDS, AREA, PARTITION
  13. Remove subsystem authorization
  14. GROUPS: definition of types, commands to create, change, and list
  15. RECON DATABASE RECORDS summary and record keys
  16. HANDS ON LAB

Subsystem Interaction & Authorization

  1. Overview
  2. Requested by / Released by
  3. Subsystem access inter
  4. 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
  5. Authorization failures
  6. IRLM compatibility checks
  7. OPEN for update processing checks
  8. Data set first update: DSSN, USID
  9. I/O errors
  10. Un-authorization
  11. LIST.HISTORY command
  12. NOTIFY.ALLOC command
  13. Authorization records summary
  14. HANDS ON LAB – authorization
  15. HANDS ON LAB- Reorganization and Image Copy

Reorganization & Image Copy

  1. Database utilities overview
  2. Utility interfaces
  3. Utility interaction with DBRC
  4. Unload, Scan Reload, Prefix update
  5. HALDB Online Reorg
  6. DBRC Commands for Reorg records
  7. Image Copy (batch, concurrent, image copy 2,)
  8. Image copy completion: DBRC RECON record cleanup
  9. GENMAX and RECOVPD
  10. DBRC Commands for IMAGE records
  11. RECON REORG & IMAGE record summary and keys

Change Accumulation

  1. Why run
  2. Groups
  3. Commands for CAGRP
  4. RECON records for CAGRP and CA executions
  5. CA & CAGRP Commands: LIST, CHANGE, DELETE
  6. CA log selection
  7. RECON records, keys & summary
  8. HANDS ON LAB

Database Recovery

  1. Overview
  2. DBRC recovery interactions
  3. GENJCL recovery
  4. Selecting full recovery input
  5. Selecting time stamp recovery input
  6. Sample recovery skeletal JCL
  7. HALDB Index / ILDS rebuild
  8. RECON database recovery records, keys & summary
  9. HANDS ON LAB

Generating JCL

  1. GENJCL overview
  2. DSPURX00 JCL
  3. Skeletal JCL
  4. Command and parameters
  5. Keywords and keyword resolution (control and simple)
  6. Archive skeleton JCL and resolved execution JCL
  7. DD statements (concatenated or multiple)
  8. GENJCL.USER example for batch backout
  9. GENJCL summary

Batch Backout

  1. Control statements
  2. Log verification
  3. Backing out abended DLI / DBB job step
  4. Online dynamic backout failure
  5. Unit of Recovery (UOR) definition
  6. BACKOUT record: example, usage, indicators, indoubt
  7. Batch backout for online: case 1 and case 2
  8. Batch backout termination for online
  9. Batch backout DBRC commands
  10. RECON BACKOUT record summary & key

RECON Maintenance

  1. Tracking RECON status
  2. Cleaning up the RECONs
  3. Repairing the RECONs
  4. Reorganizing the RECONs
  5. Reconfiguration of the RECONs
  6. Recovering the RECONs
  7. RECON out of sync process
  8. HANDS ON LAB

APPENDIX A: DBRC System Programming issues

  1. Installation
  2. Data set allocation
  3. Data set authority
  4. Avoiding RECON contention
  5. Dynamic Allocation
  6. Physical Open
  7. Logical Open
  8. Upgrading to new version
  9. Loss notification
  10. Command authorization
  11. PRILOG family of records control
  12. Application Programming Interface (API)
  13. Parallel RECON access for IMSplex

XIV. APPENDIX B: RECON record keys

XV. APPENDIX C: RECON records recap

TENHO INTERESSE

Cursos Relacionados

Curso COBOL Dumps & Debugging

16 horas

Curso COBOL Developer Foundation

32 horas

Curso IBM z/OS Management Facility Implementation

24 Horas

Curso IBM Cognos 8 BI Administration

24 Horas

Curso IBM Integration Bus Foundation

24 Horas

Curso IBM z/OS System Services Structure

32 horas