Curso de Application Data Recovery for DB2 UDB for z/OS and OS/390 CF891MX

Comentarios sobre Curso de Application Data Recovery for DB2 UDB for z/OS and OS/390 CF891MX - Presencial - Álvaro Obregón - CDMX - Ciudad de México

• Objetivos del curso
  Design and implement application data backup and recovery procedures for your installations
• Prácticas
  This a Hands-On Capacitation
• Curso dirigido a
  Individuals who support and implement application data backup and recovery procedures for DB2 UDB for z/OS.
• Titulación
  Certicicación Técnica Profesional de IBM de Application Data Recovery for DB2 UDB for z/OS and OS/390
• Contenido
  KEY TOPICS
    - Backup and recovery basics
    - Describe the major situations requiring the recovery of data
    - Explain the basic DB2 logging concept
    - Explain the basic DB2 backup and recovery concept
    - Describe the restrictive and advisory states relevant for backup and recovery
    - Explain the purpose of the Logical Page List and of Write Error Page Ranges
    - Normal backup of table and index spaces (normal backup in this context means the creation of DB2 image copies using the COPY utility)
    - Create full and incremental image copies or inline copies for table spaces
    - Create conditional image copies for table spaces
    - Create image copies for indexes
    - Establish additional copies of image copies
    - Merge full and incremental image copies to obtain new full or incremental image copies
    - Delete image copies no longer needed
    - Following the lecture, you will practice these COPY functions by completing a series of machine lab exercises
    - Normal recovery of table and index spaces (normal recovery in this context means the recovery using DB2 image copies and the RECOVER utility)
    - Prepare the recovery of a table space or index space
    - Recover a table space or COPY enabled index space to current
    - An entire table space or index space
    - A partition or data set
    - An error range
    - Replace defective volumes during recovery
    - Understand the fallback recovery concept
    - Rebuild indexes
    - You will perform online machine exercises to acquire skills necessary to:
    - Recover a table space or a copy enabled index to current
    - Replace a defective volume during recovery
    - Recover a table space when local image copy data sets are not available
    - Understand additional recovery considerations when dealing with Large Object (LOB) data
    - Point-in-time recovery (normal recovery to an earlier point in time for table spaces and index spaces)
    - Plan for point-in-time recoveries
    - Prepare point-in-time recoveries
    - Perform point-in-time recoveries involving table spaces other than LOB table spaces
    - Perform point-in-time recoveries involving LOB table spaces
    - Understand the consequences for LOB table spaces with LOG NO
    - Resolve pending conditions resulting from point-in-time recoveries
    - Following this lecture, you will perform a set of exercises to acquire skills necessary to recover application data to an earlier point-in-time from image copies using the DB2 RECOVER utility
    - Generic utility jobs (LISTDEF, TEMPLATE, and OPTIONS as far as they are relevant for backup and recovery)
    - Provide reusable list definitions for use by the DB2 utilities
    - Use list definitions in utility control statements and understand how they expand
    - Describe the concept and working of templates replacing utility DD statements
    - Use templates in utility jobs to simplify Job Control Language (JCL)
    - Use templates together with list definitions
    - Use the OPTIONS utility control statement to control execution parameters for utility jobs
    - You will perform online exercises to gain skills in:
    - Creating reusable list definitions
    - Using list definitions in utility control statements
    - Creating templates for dynamic allocation of utility data sets
    - Using templates in utility jobs to simplify JCL
    - Using the OPTIONS control statement
    - Using nonstandard copies (for the backup and recovery of table spaces or index spaces)
    - Establish DB2 Data Facility Storage Management Subsystem (DFSMS) concurrent copies using the CONCURRENT option of the COPY utility
    - Restore DB2 DFSMS concurrent copies established using the CONCURRENT option
    - Understand the prerequisites for establishing nonstandard copies
    - Establish and restore nonstandard copies using the DSN1COPY stand-alone utility
    - Establish and restore nonstandard copies using native DFSMS Data Set Services (DFSMSdss)
    - During the hands-on exercises for this topic you will:
    - Create nonstandard copies using the DSN1COPY stand-alone utility
    - Restore nonstandard copies using the DSN1COPY stand-alone utility
    - Apply log changes to restored copies
    - Special recovery situations (including down-level data, the recovery of dropped objects, and the repair of pages)
    - Handle down-level data
    - Prevent the accidental dropping of tables, table spaces, or databases
    - Recover accidentally dropped table spaces
    - Recover accidentally dropped tables
    - Print and analyze pages of table spaces or partitions
    - Repair pages of table spaces if necessary
    - The interactive exercises for this topic include practicing the techniques to:
    - Recover an accidentally dropped table
    - Recover an accidentally dropped table space
    - Print and analyze pages of a table space
    - Repair a pages of table space
    - Application recovery (how application programs should be structured to preclude recovery problems and what can be done if they do not follow these recommendations)
    - Convince application programmers to structure programs into committable units
    - Teach application programmers how to make programs restartable
    - Advise system programmers in canceling threads without backout being performed
    - Instruct system programmers how to postpone backout work during DB2 restarts
    - Cancel the postponed backout for objects being recovered or replaced
  
  *Precio no incluye IVA