Curso de Application Data Recovery for DB2 UDB for z/OS and OS/390 CF891MX
Modalidad de imparticiónLa modalidad es presencial.
Número de horasPreguntar.
Titulación oficialCerticicación Técnica Profesional de IBM de Application Data Recovery for DB2 UDB for z/OS and OS/390.
Valoración del programaEste curso tiene como objetivo el diseño e implementación de los datos de aplicaciones de backup y recuperación de los procedimientos de sus instalaciones. Conceptos básicos de copia de seguridad y recuperación, describir las situaciones importantes que requieren la recuperación de datos, explicar el concepto básico de DB2 de registro, explicar la copia de seguridad básica de DB2 y el concepto de recuperación.
Precio del cursoConsultar.
Dirigido aEstá dirigido para aquellas personas que les interese la aplicación de datos de aplicaciones de backup y recuperación de los procedimientos para DB2 UDB para z / OS.
Curso de Application Data Recovery for DB2 UDB for z/OS and OS/390 CF891MX
Objetivos del cursoDesign and implement application data backup and recovery procedures for your installations
PrácticasThis a Hands-On Capacitation
Curso dirigido aIndividuals who support and implement application data backup and recovery procedures for DB2 UDB for z/OS.
TitulaciónCerticicación Técnica Profesional de IBM de Application Data Recovery for DB2 UDB for z/OS and OS/390
ContenidoKEY 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