db2 for z/os - recovery/restart · 2015. 10. 12. · overview: learn how data and indexrecovery is...

CV891G www.globalknowledge.ie [email protected] 353-1-814 8200

DB2 for z/OS - Recovery/Restart

Duration: 4 Days Course Code: CV891G

Overview:

Learn how data and index recovery is supported by DB2 for z/OS in order to develop the knowledge and skills you need to design andimplement backup and recovery procedures for your installations. Practice using the utility functions and techniques included in the lecture material during extensive interactive machine lab exercises on a z/OSsystem. Course Materials The course materials cover DB2 for z/OS V9. The content is also appropriate for those who are working on DB2 10 for z/OS. Hands-On Labs Six labs are included to address functionality of DB2 for z/OS application recovery.

Target Audience:

This intermediate course is for individuals who support and implement application data backup and recovery procedures for DB2 9 or DB2 10for z/OS.

Objectives:

design and implement application data backup and recoveryprocedures for their installations.

Prerequisites:

You should complete:

DB2 9 for z/OS Database Administration Workshop - Part 1(CV830GB) orDB2 9 for z/OS Database Administration Workshop - Part 1 -Instructor Led Online (3V830GB) orpossess equivalent knowledge.


Content:

Backup and recovery basics Day 1 line line line

Describe the major situations requiring the Explain the basic DB2 logging concept Backup and recovery basicsrecovery of data Explain the basic DB2 backup and

recovery conceptDescribe the restrictive and advisory line

line states relevant for backup and recovery Explain the basic DB2 logging conceptExplain the basic DB2 logging concept Explain the purpose of the Logical Page Explain the basic DB2 backup andExplain the basic DB2 backup and recovery List and of Write Error Page Ranges recovery conceptconcept Create conditional image copies for table Describe the restrictive and advisory statesDescribe the restrictive and advisory states spaces relevant for backup and recoveryrelevant for backup and recovery Create image copies for indexes Explain the purpose of the Logical PageExplain the purpose of the Logical Page List Establish additional copies of image List and of Write Error Page Ranges and of Write Error Page Ranges copies Create conditional image copies for tableCreate conditional image copies for table Merge full and incremental image copies spacesspaces to obtain new full or incremental image Create image copies for indexesCreate image copies for indexes copies Establish additional copies of imageEstablish additional copies of image copies Delete image copies no longer needed copiesMerge full and incremental image copies to Recover a table space or COPY enabled Merge full and incremental image copies toobtain new full or incremental image copies index space to current obtain new full or incremental imageDelete image copies no longer needed An entire table space or index space copiesRecover a table space or COPY enabled A partition or data set Delete image copies no longer needed index space to current An error range Recover a table space or COPY enabledAn entire table space or index space Replace defective volumes during index space to currentA partition or data set recovery An entire table space or index spaceAn error range Relate the fallback recovery concept A partition or data setReplace defective volumes during recovery Rebuild indexes An error range Relate the fallback recovery concept Prepare point-in-time recoveries Replace defective volumes during recoveryRebuild indexes Perform point-in-time recoveries involving Relate the fallback recovery conceptPrepare point-in-time recoveries table spaces other than LOB table Rebuild indexes Perform point-in-time recoveries involving spaces Prepare point-in-time recoveriestable spaces other than LOB table spaces Use list definitions in utility control Perform point-in-time recoveries involvingUse list definitions in utility control statements and understand how they table spaces other than LOB table spaces statements and understand how they expand Use list definitions in utility controlexpand Describe the concept and working of statements and understand how theyDescribe the concept and working of templates replacing utility Dataset expandtemplates replacing utility Dataset Definition Definition (DD) statements Describe the concept and working of(DD) statements Use templates in utility jobs to simplify templates replacing utility DatasetUse templates in utility jobs to simplify Job Job Control Language (JCL) Definition (DD) statementsControl Language (JCL) Use templates together with list Use templates in utility jobs to simplify JobUse templates together with list definitions definitions Control Language (JCL)Use the OPTIONS utility control statement Use the OPTIONS utility control Use templates together with list definitionsto control execution parameters for utility statement to control execution Use the OPTIONS utility control statementjobs parameters for utility jobs to control execution parameters for utilityRestore DB2 DFSMS concurrent copies Restore DB2 DFSMS concurrent copies jobs established using the CONCURRENT option established using the CONCURRENT Restore DB2 DFSMS concurrent copiesUnderstand the prerequisites for establishing option established using the CONCURRENTnonstandard copies Understand the prerequisites for optionEstablish and restore nonstandard copies establishing nonstandard copies Understand the prerequisites forusing the DSN1COPY stand-alone utility Establish and restore nonstandard copies establishing nonstandard copiesEstablish and restore nonstandard copies using the DSN1COPY stand-alone utility Establish and restore nonstandard copiesusing native DFSMS Data Set Services Establish and restore nonstandard copies using the DSN1COPY stand-alone utility(DFSMSdss) using native DFSMS Data Set Services Establish and restore nonstandard copiesApply log changes to restored copies (DFSMSdss) using native DFSMS Data Set ServicesPrevent the accidental dropping of tables, Apply log changes to restored copies (DFSMSdss)table spaces, or databases Prevent the accidental dropping of tables, Apply log changes to restored copies Recover accidentally dropped table spaces table spaces, or databases Prevent the accidental dropping of tables,Recover accidentally dropped tables Recover accidentally dropped table table spaces, or databasesPrint and analyze pages of table spaces or spaces Recover accidentally dropped table spacespartitions Recover accidentally dropped tables Recover accidentally dropped tablesRepair pages of table spaces if necessary Print and analyze pages of table spaces Print and analyze pages of table spaces orTeach application programmers how to or partitions partitionsmake programs restartable Repair pages of table spaces if Repair pages of table spaces if necessary Advise system programmers in canceling necessary Teach application programmers how to


threads without backout being performed Teach application programmers how to make programs restartableInstruct system programmers how to make programs restartable Advise system programmers in cancelingpostpone backout work during DB2 restarts Advise system programmers in canceling threads without backout being performedCancel the postponed backout for objects threads without backout being performed Instruct system programmers how tobeing recovered or replaced Instruct system programmers how to postpone backout work during DB2Normal backup of table and index spaces postpone backout work during DB2 restartsExercises: normal backup of table and index restarts Cancel the postponed backout for objectsspaces Cancel the postponed backout for objects being recovered or replaced Review exercises: normal backup of table being recovered or replaced Normal backup of table and index spacesand index spaces Normal backup of table and index spaces Exercises: normal backup of table andNormal recovery of table and index spaces Exercises: normal backup of table and index spacesExercises: normal recovery of table and index spaces Review exercises: normal backup of tableindex spaces Review exercises: normal backup of table and index spacesReview exercises: normal recovery of table and index spaces Normal recovery of table and index spacesand index spaces Normal recovery of table and index Exercises: normal recovery of table andExercises: point-in-time recovery spaces index spacesReview exercises: point-in-time recovery Exercises: normal recovery of table and Review exercises: normal recovery of tableGeneric utility jobs index spaces and index spaces Exercises: generic utility jobs Review exercises: normal recovery of Exercises: point-in-time recoveryReview exercises: generic utility jobs table and index spaces Review exercises: point-in-time recoveryExercises: using nonstandard copies Exercises: point-in-time recovery Generic utility jobsReview exercises: using nonstandard copies Review exercises: point-in-time recovery Exercises: generic utility jobsSpecial recovery situations Generic utility jobs Review exercises: generic utility jobs Exercises: special recovery situations Exercises: generic utility jobs Exercises: using nonstandard copiesReview exercises: special recovery Review exercises: generic utility jobs Review exercises: using nonstandardsituations Exercises: using nonstandard copies copiesApplication recovery Review exercises: using nonstandard Special recovery situations

copies Exercises: special recovery situationsSpecial recovery situations Review exercises: special recovery

line Exercises: special recovery situations situationsExplain the basic DB2 logging concept Review exercises: special recovery Application recoveryExplain the basic DB2 backup and recovery situationsconcept Application recoveryDescribe the restrictive and advisory states linerelevant for backup and recovery Explain the basic DB2 logging conceptExplain the purpose of the Logical Page List line Explain the basic DB2 backup andand of Write Error Page Ranges Explain the basic DB2 logging concept recovery conceptCreate conditional image copies for table Explain the basic DB2 backup and Describe the restrictive and advisory statesspaces recovery concept relevant for backup and recoveryCreate image copies for indexes Describe the restrictive and advisory Explain the purpose of the Logical PageEstablish additional copies of image copies states relevant for backup and recovery List and of Write Error Page Ranges Merge full and incremental image copies to Explain the purpose of the Logical Page Create conditional image copies for tableobtain new full or incremental image copies List and of Write Error Page Ranges spacesDelete image copies no longer needed Create conditional image copies for table Create image copies for indexesRecover a table space or COPY enabled spaces Establish additional copies of imageindex space to current Create image copies for indexes copiesAn entire table space or index space Establish additional copies of image Merge full and incremental image copies toA partition or data set copies obtain new full or incremental imageAn error range Merge full and incremental image copies copiesReplace defective volumes during recovery to obtain new full or incremental image Delete image copies no longer needed Relate the fallback recovery concept copies Recover a table space or COPY enabledRebuild indexes Delete image copies no longer needed index space to currentPrepare point-in-time recoveries Recover a table space or COPY enabled An entire table space or index spacePerform point-in-time recoveries involving index space to current A partition or data settable spaces other than LOB table spaces An entire table space or index space An error range Use list definitions in utility control A partition or data set Replace defective volumes during recoverystatements and understand how they An error range Relate the fallback recovery conceptexpand Replace defective volumes during Rebuild indexes Describe the concept and working of recovery Prepare point-in-time recoveriestemplates replacing utility Dataset Definition Relate the fallback recovery concept Perform point-in-time recoveries involving(DD) statements Rebuild indexes table spaces other than LOB table spaces Use templates in utility jobs to simplify Job Prepare point-in-time recoveries Use list definitions in utility controlControl Language (JCL) Perform point-in-time recoveries involving statements and understand how theyUse templates together with list definitions table spaces other than LOB table expandUse the OPTIONS utility control statement spaces Describe the concept and working ofto control execution parameters for utility Use list definitions in utility control templates replacing utility Dataset


jobs statements and understand how they Definition (DD) statementsRestore DB2 DFSMS concurrent copies expand Use templates in utility jobs to simplify Jobestablished using the CONCURRENT option Describe the concept and working of Control Language (JCL)Understand the prerequisites for establishing templates replacing utility Dataset Use templates together with list definitionsnonstandard copies Definition (DD) statements Use the OPTIONS utility control statementEstablish and restore nonstandard copies Use templates in utility jobs to simplify to control execution parameters for utilityusing the DSN1COPY stand-alone utility Job Control Language (JCL) jobs Establish and restore nonstandard copies Use templates together with list Restore DB2 DFSMS concurrent copiesusing native DFSMS Data Set Services definitions established using the CONCURRENT(DFSMSdss) Use the OPTIONS utility control optionApply log changes to restored copies statement to control execution Understand the prerequisites forPrevent the accidental dropping of tables, parameters for utility jobs establishing nonstandard copiestable spaces, or databases Restore DB2 DFSMS concurrent copies Establish and restore nonstandard copiesRecover accidentally dropped table spaces established using the CONCURRENT using the DSN1COPY stand-alone utilityRecover accidentally dropped tables option Establish and restore nonstandard copiesPrint and analyze pages of table spaces or Understand the prerequisites for using native DFSMS Data Set Servicespartitions establishing nonstandard copies (DFSMSdss)Repair pages of table spaces if necessary Establish and restore nonstandard copies Apply log changes to restored copies Teach application programmers how to using the DSN1COPY stand-alone utility Prevent the accidental dropping of tables,make programs restartable Establish and restore nonstandard copies table spaces, or databasesAdvise system programmers in canceling using native DFSMS Data Set Services Recover accidentally dropped table spacesthreads without backout being performed (DFSMSdss) Recover accidentally dropped tablesInstruct system programmers how to Apply log changes to restored copies Print and analyze pages of table spaces orpostpone backout work during DB2 restarts Prevent the accidental dropping of tables, partitionsCancel the postponed backout for objects table spaces, or databases Repair pages of table spaces if necessary being recovered or replaced Recover accidentally dropped table Teach application programmers how toNormal backup of table and index spaces spaces make programs restartableExercises: normal backup of table and index Recover accidentally dropped tables Advise system programmers in cancelingspaces Print and analyze pages of table spaces threads without backout being performedReview exercises: normal backup of table or partitions Instruct system programmers how toand index spaces Repair pages of table spaces if postpone backout work during DB2Normal recovery of table and index spaces necessary restartsExercises: normal recovery of table and Teach application programmers how to Cancel the postponed backout for objectsindex spaces make programs restartable being recovered or replaced Review exercises: normal recovery of table Advise system programmers in canceling Normal backup of table and index spacesand index spaces threads without backout being performed Exercises: normal backup of table andExercises: point-in-time recovery Instruct system programmers how to index spacesReview exercises: point-in-time recovery postpone backout work during DB2 Review exercises: normal backup of tableGeneric utility jobs restarts and index spacesExercises: generic utility jobs Cancel the postponed backout for objects Normal recovery of table and index spacesReview exercises: generic utility jobs being recovered or replaced Exercises: normal recovery of table andExercises: using nonstandard copies Normal backup of table and index spaces index spacesReview exercises: using nonstandard copies Exercises: normal backup of table and Review exercises: normal recovery of tableSpecial recovery situations index spaces and index spaces Exercises: special recovery situations Review exercises: normal backup of table Exercises: point-in-time recoveryReview exercises: special recovery and index spaces Review exercises: point-in-time recoverysituations Normal recovery of table and index Generic utility jobsApplication recovery spaces Exercises: generic utility jobs

Exercises: normal recovery of table and Review exercises: generic utility jobs index spaces Exercises: using nonstandard copies

line Review exercises: normal recovery of Review exercises: using nonstandardExplain the basic DB2 logging concept table and index spaces copiesExplain the basic DB2 backup and recovery Exercises: point-in-time recovery Special recovery situationsconcept Review exercises: point-in-time recovery Exercises: special recovery situationsDescribe the restrictive and advisory states Generic utility jobs Review exercises: special recoveryrelevant for backup and recovery Exercises: generic utility jobs situationsExplain the purpose of the Logical Page List Review exercises: generic utility jobs Application recoveryand of Write Error Page Ranges Exercises: using nonstandard copiesCreate conditional image copies for table Review exercises: using nonstandardspaces copies lineCreate image copies for indexes Special recovery situations Explain the basic DB2 logging conceptEstablish additional copies of image copies Exercises: special recovery situations Explain the basic DB2 backup andMerge full and incremental image copies to Review exercises: special recovery recovery conceptobtain new full or incremental image copies situations Describe the restrictive and advisory statesDelete image copies no longer needed Application recovery relevant for backup and recoveryRecover a table space or COPY enabled Explain the purpose of the Logical Page


index space to current List and of Write Error Page Ranges An entire table space or index space line Create conditional image copies for tableA partition or data set Explain the basic DB2 logging concept spacesAn error range Explain the basic DB2 backup and Create image copies for indexesReplace defective volumes during recovery recovery concept Establish additional copies of imageRelate the fallback recovery concept Describe the restrictive and advisory copiesRebuild indexes states relevant for backup and recovery Merge full and incremental image copies toPrepare point-in-time recoveries Explain the purpose of the Logical Page obtain new full or incremental imagePerform point-in-time recoveries involving List and of Write Error Page Ranges copiestable spaces other than LOB table spaces Create conditional image copies for table Delete image copies no longer needed Use list definitions in utility control spaces Recover a table space or COPY enabledstatements and understand how they Create image copies for indexes index space to currentexpand Establish additional copies of image An entire table space or index spaceDescribe the concept and working of copies A partition or data settemplates replacing utility Dataset Definition Merge full and incremental image copies An error range (DD) statements to obtain new full or incremental image Replace defective volumes during recoveryUse templates in utility jobs to simplify Job copies Relate the fallback recovery conceptControl Language (JCL) Delete image copies no longer needed Rebuild indexes Use templates together with list definitions Recover a table space or COPY enabled Prepare point-in-time recoveriesUse the OPTIONS utility control statement index space to current Perform point-in-time recoveries involvingto control execution parameters for utility An entire table space or index space table spaces other than LOB table spaces jobs A partition or data set Use list definitions in utility controlRestore DB2 DFSMS concurrent copies An error range statements and understand how theyestablished using the CONCURRENT option Replace defective volumes during expandUnderstand the prerequisites for establishing recovery Describe the concept and working ofnonstandard copies Relate the fallback recovery concept templates replacing utility DatasetEstablish and restore nonstandard copies Rebuild indexes Definition (DD) statementsusing the DSN1COPY stand-alone utility Prepare point-in-time recoveries Use templates in utility jobs to simplify JobEstablish and restore nonstandard copies Perform point-in-time recoveries involving Control Language (JCL)using native DFSMS Data Set Services table spaces other than LOB table Use templates together with list definitions(DFSMSdss) spaces Use the OPTIONS utility control statementApply log changes to restored copies Use list definitions in utility control to control execution parameters for utilityPrevent the accidental dropping of tables, statements and understand how they jobs table spaces, or databases expand Restore DB2 DFSMS concurrent copiesRecover accidentally dropped table spaces Describe the concept and working of established using the CONCURRENTRecover accidentally dropped tables templates replacing utility Dataset optionPrint and analyze pages of table spaces or Definition (DD) statements Understand the prerequisites forpartitions Use templates in utility jobs to simplify establishing nonstandard copiesRepair pages of table spaces if necessary Job Control Language (JCL) Establish and restore nonstandard copiesTeach application programmers how to Use templates together with list using the DSN1COPY stand-alone utilitymake programs restartable definitions Establish and restore nonstandard copiesAdvise system programmers in canceling Use the OPTIONS utility control using native DFSMS Data Set Servicesthreads without backout being performed statement to control execution (DFSMSdss)Instruct system programmers how to parameters for utility jobs Apply log changes to restored copies postpone backout work during DB2 restarts Restore DB2 DFSMS concurrent copies Prevent the accidental dropping of tables,Cancel the postponed backout for objects established using the CONCURRENT table spaces, or databasesbeing recovered or replaced option Recover accidentally dropped table spacesNormal backup of table and index spaces Understand the prerequisites for Recover accidentally dropped tablesExercises: normal backup of table and index establishing nonstandard copies Print and analyze pages of table spaces orspaces Establish and restore nonstandard copies partitionsReview exercises: normal backup of table using the DSN1COPY stand-alone utility Repair pages of table spaces if necessary and index spaces Establish and restore nonstandard copies Teach application programmers how toNormal recovery of table and index spaces using native DFSMS Data Set Services make programs restartableExercises: normal recovery of table and (DFSMSdss) Advise system programmers in cancelingindex spaces Apply log changes to restored copies threads without backout being performedReview exercises: normal recovery of table Prevent the accidental dropping of tables, Instruct system programmers how toand index spaces table spaces, or databases postpone backout work during DB2Exercises: point-in-time recovery Recover accidentally dropped table restartsReview exercises: point-in-time recovery spaces Cancel the postponed backout for objectsGeneric utility jobs Recover accidentally dropped tables being recovered or replaced Exercises: generic utility jobs Print and analyze pages of table spaces Normal backup of table and index spacesReview exercises: generic utility jobs or partitions Exercises: normal backup of table andExercises: using nonstandard copies Repair pages of table spaces if index spacesReview exercises: using nonstandard copies necessary Review exercises: normal backup of tableSpecial recovery situations Teach application programmers how to and index spacesExercises: special recovery situations make programs restartable Normal recovery of table and index spaces


Review exercises: special recovery Advise system programmers in canceling Exercises: normal recovery of table andsituations threads without backout being performed index spacesApplication recovery Instruct system programmers how to Review exercises: normal recovery of table

postpone backout work during DB2 and index spaces restarts Exercises: point-in-time recovery

line Cancel the postponed backout for objects Review exercises: point-in-time recoveryExplain the basic DB2 logging concept being recovered or replaced Generic utility jobsExplain the basic DB2 backup and recovery Normal backup of table and index spaces Exercises: generic utility jobsconcept Exercises: normal backup of table and Review exercises: generic utility jobs Describe the restrictive and advisory states index spaces Exercises: using nonstandard copiesrelevant for backup and recovery Review exercises: normal backup of table Review exercises: using nonstandardExplain the purpose of the Logical Page List and index spaces copiesand of Write Error Page Ranges Normal recovery of table and index Special recovery situationsCreate conditional image copies for table spaces Exercises: special recovery situationsspaces Exercises: normal recovery of table and Review exercises: special recoveryCreate image copies for indexes index spaces situationsEstablish additional copies of image copies Review exercises: normal recovery of Application recoveryMerge full and incremental image copies to table and index spaces obtain new full or incremental image copies Exercises: point-in-time recoveryDelete image copies no longer needed Review exercises: point-in-time recovery lineRecover a table space or COPY enabled Generic utility jobs Explain the basic DB2 logging conceptindex space to current Exercises: generic utility jobs Explain the basic DB2 backup andAn entire table space or index space Review exercises: generic utility jobs recovery conceptA partition or data set Exercises: using nonstandard copies Describe the restrictive and advisory statesAn error range Review exercises: using nonstandard relevant for backup and recoveryReplace defective volumes during recovery copies Explain the purpose of the Logical PageRelate the fallback recovery concept Special recovery situations List and of Write Error Page Ranges Rebuild indexes Exercises: special recovery situations Create conditional image copies for tablePrepare point-in-time recoveries Review exercises: special recovery spacesPerform point-in-time recoveries involving situations Create image copies for indexestable spaces other than LOB table spaces Application recovery Establish additional copies of imageUse list definitions in utility control copiesstatements and understand how they Merge full and incremental image copies toexpand line obtain new full or incremental imageDescribe the concept and working of Explain the basic DB2 logging concept copiestemplates replacing utility Dataset Definition Explain the basic DB2 backup and Delete image copies no longer needed (DD) statements recovery concept Recover a table space or COPY enabledUse templates in utility jobs to simplify Job Describe the restrictive and advisory index space to currentControl Language (JCL) states relevant for backup and recovery An entire table space or index spaceUse templates together with list definitions Explain the purpose of the Logical Page A partition or data setUse the OPTIONS utility control statement List and of Write Error Page Ranges An error range to control execution parameters for utility Create conditional image copies for table Replace defective volumes during recoveryjobs spaces Relate the fallback recovery conceptRestore DB2 DFSMS concurrent copies Create image copies for indexes Rebuild indexes established using the CONCURRENT option Establish additional copies of image Prepare point-in-time recoveriesUnderstand the prerequisites for establishing copies Perform point-in-time recoveries involvingnonstandard copies Merge full and incremental image copies table spaces other than LOB table spaces Establish and restore nonstandard copies to obtain new full or incremental image Use list definitions in utility controlusing the DSN1COPY stand-alone utility copies statements and understand how theyEstablish and restore nonstandard copies Delete image copies no longer needed expandusing native DFSMS Data Set Services Recover a table space or COPY enabled Describe the concept and working of(DFSMSdss) index space to current templates replacing utility DatasetApply log changes to restored copies An entire table space or index space Definition (DD) statementsPrevent the accidental dropping of tables, A partition or data set Use templates in utility jobs to simplify Jobtable spaces, or databases An error range Control Language (JCL)Recover accidentally dropped table spaces Replace defective volumes during Use templates together with list definitionsRecover accidentally dropped tables recovery Use the OPTIONS utility control statementPrint and analyze pages of table spaces or Relate the fallback recovery concept to control execution parameters for utilitypartitions Rebuild indexes jobs Repair pages of table spaces if necessary Prepare point-in-time recoveries Restore DB2 DFSMS concurrent copiesTeach application programmers how to Perform point-in-time recoveries involving established using the CONCURRENTmake programs restartable table spaces other than LOB table optionAdvise system programmers in canceling spaces Understand the prerequisites forthreads without backout being performed Use list definitions in utility control establishing nonstandard copiesInstruct system programmers how to statements and understand how they Establish and restore nonstandard copiespostpone backout work during DB2 restarts expand using the DSN1COPY stand-alone utility


Cancel the postponed backout for objects Describe the concept and working of Establish and restore nonstandard copiesbeing recovered or replaced templates replacing utility Dataset using native DFSMS Data Set ServicesNormal backup of table and index spaces Definition (DD) statements (DFSMSdss)Exercises: normal backup of table and index Use templates in utility jobs to simplify Apply log changes to restored copies spaces Job Control Language (JCL) Prevent the accidental dropping of tables,Review exercises: normal backup of table Use templates together with list table spaces, or databasesand index spaces definitions Recover accidentally dropped table spacesNormal recovery of table and index spaces Use the OPTIONS utility control Recover accidentally dropped tablesExercises: normal recovery of table and statement to control execution Print and analyze pages of table spaces orindex spaces parameters for utility jobs partitionsReview exercises: normal recovery of table Restore DB2 DFSMS concurrent copies Repair pages of table spaces if necessary and index spaces established using the CONCURRENT Teach application programmers how toExercises: point-in-time recovery option make programs restartableReview exercises: point-in-time recovery Understand the prerequisites for Advise system programmers in cancelingGeneric utility jobs establishing nonstandard copies threads without backout being performedExercises: generic utility jobs Establish and restore nonstandard copies Instruct system programmers how toReview exercises: generic utility jobs using the DSN1COPY stand-alone utility postpone backout work during DB2Exercises: using nonstandard copies Establish and restore nonstandard copies restartsReview exercises: using nonstandard copies using native DFSMS Data Set Services Cancel the postponed backout for objectsSpecial recovery situations (DFSMSdss) being recovered or replaced Exercises: special recovery situations Apply log changes to restored copies Normal backup of table and index spacesReview exercises: special recovery Prevent the accidental dropping of tables, Exercises: normal backup of table andsituations table spaces, or databases index spacesApplication recovery Recover accidentally dropped table Review exercises: normal backup of table

spaces and index spacesNormal backup of table and index spaces Recover accidentally dropped tables Normal recovery of table and index spaces(normal backup in this context means the Print and analyze pages of table spaces Exercises: normal recovery of table andcreation of DB2 image copies using the COPY or partitions index spacesutility) Repair pages of table spaces if Review exercises: normal recovery of tableline necessary and index spaces

Create full and incremental image copies or Teach application programmers how to Exercises: point-in-time recoveryinline copies for table spaces make programs restartable Review exercises: point-in-time recovery

Advise system programmers in canceling Generic utility jobsthreads without backout being performed Exercises: generic utility jobs

line Instruct system programmers how to Review exercises: generic utility jobs Explain the basic DB2 logging concept postpone backout work during DB2 Exercises: using nonstandard copiesExplain the basic DB2 backup and recovery restarts Review exercises: using nonstandardconcept Cancel the postponed backout for objects copiesDescribe the restrictive and advisory states being recovered or replaced Special recovery situationsrelevant for backup and recovery Normal backup of table and index spaces Exercises: special recovery situationsExplain the purpose of the Logical Page List Exercises: normal backup of table and Review exercises: special recoveryand of Write Error Page Ranges index spaces situationsCreate conditional image copies for table Review exercises: normal backup of table Application recoveryspaces and index spacesCreate image copies for indexes Normal recovery of table and indexEstablish additional copies of image copies spaces lineMerge full and incremental image copies to Exercises: normal recovery of table and Explain the basic DB2 logging conceptobtain new full or incremental image copies index spaces Explain the basic DB2 backup andDelete image copies no longer needed Review exercises: normal recovery of recovery conceptRecover a table space or COPY enabled table and index spaces Describe the restrictive and advisory statesindex space to current Exercises: point-in-time recovery relevant for backup and recoveryAn entire table space or index space Review exercises: point-in-time recovery Explain the purpose of the Logical PageA partition or data set Generic utility jobs List and of Write Error Page Ranges An error range Exercises: generic utility jobs Create conditional image copies for tableReplace defective volumes during recovery Review exercises: generic utility jobs spacesRelate the fallback recovery concept Exercises: using nonstandard copies Create image copies for indexesRebuild indexes Review exercises: using nonstandard Establish additional copies of imagePrepare point-in-time recoveries copies copiesPerform point-in-time recoveries involving Special recovery situations Merge full and incremental image copies totable spaces other than LOB table spaces Exercises: special recovery situations obtain new full or incremental imageUse list definitions in utility control Review exercises: special recovery copiesstatements and understand how they situations Delete image copies no longer needed expand Application recovery Recover a table space or COPY enabledDescribe the concept and working of index space to currenttemplates replacing utility Dataset Definition Using nonstandard copies (for the backup and An entire table space or index space(DD) statements recovery of table spaces or index spaces) A partition or data set


Use templates in utility jobs to simplify Job line An error range Control Language (JCL) Establish DB2 Data Facility Storage Replace defective volumes during recoveryUse templates together with list definitions Management Subsystem (DFSMS) Relate the fallback recovery conceptUse the OPTIONS utility control statement concurrent copies using the Rebuild indexes to control execution parameters for utility CONCURRENT option of the COPY Prepare point-in-time recoveriesjobs utility Perform point-in-time recoveries involvingRestore DB2 DFSMS concurrent copies table spaces other than LOB table spaces established using the CONCURRENT option Use list definitions in utility controlUnderstand the prerequisites for establishing line statements and understand how theynonstandard copies Explain the basic DB2 logging concept expandEstablish and restore nonstandard copies Explain the basic DB2 backup and Describe the concept and working ofusing the DSN1COPY stand-alone utility recovery concept templates replacing utility DatasetEstablish and restore nonstandard copies Describe the restrictive and advisory Definition (DD) statementsusing native DFSMS Data Set Services states relevant for backup and recovery Use templates in utility jobs to simplify Job(DFSMSdss) Explain the purpose of the Logical Page Control Language (JCL)Apply log changes to restored copies List and of Write Error Page Ranges Use templates together with list definitionsPrevent the accidental dropping of tables, Create conditional image copies for table Use the OPTIONS utility control statementtable spaces, or databases spaces to control execution parameters for utilityRecover accidentally dropped table spaces Create image copies for indexes jobs Recover accidentally dropped tables Establish additional copies of image Restore DB2 DFSMS concurrent copiesPrint and analyze pages of table spaces or copies established using the CONCURRENTpartitions Merge full and incremental image copies optionRepair pages of table spaces if necessary to obtain new full or incremental image Understand the prerequisites forTeach application programmers how to copies establishing nonstandard copiesmake programs restartable Delete image copies no longer needed Establish and restore nonstandard copiesAdvise system programmers in canceling Recover a table space or COPY enabled using the DSN1COPY stand-alone utilitythreads without backout being performed index space to current Establish and restore nonstandard copiesInstruct system programmers how to An entire table space or index space using native DFSMS Data Set Servicespostpone backout work during DB2 restarts A partition or data set (DFSMSdss)Cancel the postponed backout for objects An error range Apply log changes to restored copies being recovered or replaced Replace defective volumes during Prevent the accidental dropping of tables,Normal backup of table and index spaces recovery table spaces, or databasesExercises: normal backup of table and index Relate the fallback recovery concept Recover accidentally dropped table spacesspaces Rebuild indexes Recover accidentally dropped tablesReview exercises: normal backup of table Prepare point-in-time recoveries Print and analyze pages of table spaces orand index spaces Perform point-in-time recoveries involving partitionsNormal recovery of table and index spaces table spaces other than LOB table Repair pages of table spaces if necessary Exercises: normal recovery of table and spaces Teach application programmers how toindex spaces Use list definitions in utility control make programs restartableReview exercises: normal recovery of table statements and understand how they Advise system programmers in cancelingand index spaces expand threads without backout being performedExercises: point-in-time recovery Describe the concept and working of Instruct system programmers how toReview exercises: point-in-time recovery templates replacing utility Dataset postpone backout work during DB2Generic utility jobs Definition (DD) statements restartsExercises: generic utility jobs Use templates in utility jobs to simplify Cancel the postponed backout for objectsReview exercises: generic utility jobs Job Control Language (JCL) being recovered or replaced Exercises: using nonstandard copies Use templates together with list Normal backup of table and index spacesReview exercises: using nonstandard copies definitions Exercises: normal backup of table andSpecial recovery situations Use the OPTIONS utility control index spacesExercises: special recovery situations statement to control execution Review exercises: normal backup of tableReview exercises: special recovery parameters for utility jobs and index spacessituations Restore DB2 DFSMS concurrent copies Normal recovery of table and index spacesApplication recovery established using the CONCURRENT Exercises: normal recovery of table and

option index spacesUnderstand the prerequisites for Review exercises: normal recovery of table

line establishing nonstandard copies and index spaces Explain the basic DB2 logging concept Establish and restore nonstandard copies Exercises: point-in-time recoveryExplain the basic DB2 backup and recovery using the DSN1COPY stand-alone utility Review exercises: point-in-time recoveryconcept Establish and restore nonstandard copies Generic utility jobsDescribe the restrictive and advisory states using native DFSMS Data Set Services Exercises: generic utility jobsrelevant for backup and recovery (DFSMSdss) Review exercises: generic utility jobs Explain the purpose of the Logical Page List Apply log changes to restored copies Exercises: using nonstandard copiesand of Write Error Page Ranges Prevent the accidental dropping of tables, Review exercises: using nonstandardCreate conditional image copies for table table spaces, or databases copiesspaces Recover accidentally dropped table Special recovery situationsCreate image copies for indexes spaces Exercises: special recovery situations


Establish additional copies of image copies Recover accidentally dropped tables Review exercises: special recoveryMerge full and incremental image copies to Print and analyze pages of table spaces situationsobtain new full or incremental image copies or partitions Application recoveryDelete image copies no longer needed Repair pages of table spaces ifRecover a table space or COPY enabled necessary index space to current Teach application programmers how to lineAn entire table space or index space make programs restartable Explain the basic DB2 logging conceptA partition or data set Advise system programmers in canceling Explain the basic DB2 backup andAn error range threads without backout being performed recovery conceptReplace defective volumes during recovery Instruct system programmers how to Describe the restrictive and advisory statesRelate the fallback recovery concept postpone backout work during DB2 relevant for backup and recoveryRebuild indexes restarts Explain the purpose of the Logical PagePrepare point-in-time recoveries Cancel the postponed backout for objects List and of Write Error Page Ranges Perform point-in-time recoveries involving being recovered or replaced Create conditional image copies for tabletable spaces other than LOB table spaces Normal backup of table and index spaces spacesUse list definitions in utility control Exercises: normal backup of table and Create image copies for indexesstatements and understand how they index spaces Establish additional copies of imageexpand Review exercises: normal backup of table copiesDescribe the concept and working of and index spaces Merge full and incremental image copies totemplates replacing utility Dataset Definition Normal recovery of table and index obtain new full or incremental image(DD) statements spaces copiesUse templates in utility jobs to simplify Job Exercises: normal recovery of table and Delete image copies no longer needed Control Language (JCL) index spaces Recover a table space or COPY enabledUse templates together with list definitions Review exercises: normal recovery of index space to currentUse the OPTIONS utility control statement table and index spaces An entire table space or index spaceto control execution parameters for utility Exercises: point-in-time recovery A partition or data setjobs Review exercises: point-in-time recovery An error range Restore DB2 DFSMS concurrent copies Generic utility jobs Replace defective volumes during recoveryestablished using the CONCURRENT option Exercises: generic utility jobs Relate the fallback recovery conceptUnderstand the prerequisites for establishing Review exercises: generic utility jobs Rebuild indexes nonstandard copies Exercises: using nonstandard copies Prepare point-in-time recoveriesEstablish and restore nonstandard copies Review exercises: using nonstandard Perform point-in-time recoveries involvingusing the DSN1COPY stand-alone utility copies table spaces other than LOB table spaces Establish and restore nonstandard copies Special recovery situations Use list definitions in utility controlusing native DFSMS Data Set Services Exercises: special recovery situations statements and understand how they(DFSMSdss) Review exercises: special recovery expandApply log changes to restored copies situations Describe the concept and working ofPrevent the accidental dropping of tables, Application recovery templates replacing utility Datasettable spaces, or databases Definition (DD) statementsRecover accidentally dropped table spaces Use templates in utility jobs to simplify JobRecover accidentally dropped tables line Control Language (JCL)Print and analyze pages of table spaces or Explain the basic DB2 logging concept Use templates together with list definitionspartitions Explain the basic DB2 backup and Use the OPTIONS utility control statementRepair pages of table spaces if necessary recovery concept to control execution parameters for utilityTeach application programmers how to Describe the restrictive and advisory jobs make programs restartable states relevant for backup and recovery Restore DB2 DFSMS concurrent copiesAdvise system programmers in canceling Explain the purpose of the Logical Page established using the CONCURRENTthreads without backout being performed List and of Write Error Page Ranges optionInstruct system programmers how to Create conditional image copies for table Understand the prerequisites forpostpone backout work during DB2 restarts spaces establishing nonstandard copiesCancel the postponed backout for objects Create image copies for indexes Establish and restore nonstandard copiesbeing recovered or replaced Establish additional copies of image using the DSN1COPY stand-alone utilityNormal backup of table and index spaces copies Establish and restore nonstandard copiesExercises: normal backup of table and index Merge full and incremental image copies using native DFSMS Data Set Servicesspaces to obtain new full or incremental image (DFSMSdss)Review exercises: normal backup of table copies Apply log changes to restored copies and index spaces Delete image copies no longer needed Prevent the accidental dropping of tables,Normal recovery of table and index spaces Recover a table space or COPY enabled table spaces, or databasesExercises: normal recovery of table and index space to current Recover accidentally dropped table spacesindex spaces An entire table space or index space Recover accidentally dropped tablesReview exercises: normal recovery of table A partition or data set Print and analyze pages of table spaces orand index spaces An error range partitionsExercises: point-in-time recovery Replace defective volumes during Repair pages of table spaces if necessary Review exercises: point-in-time recovery recovery Teach application programmers how toGeneric utility jobs Relate the fallback recovery concept make programs restartableExercises: generic utility jobs Rebuild indexes Advise system programmers in canceling


Review exercises: generic utility jobs Prepare point-in-time recoveries threads without backout being performedExercises: using nonstandard copies Perform point-in-time recoveries involving Instruct system programmers how toReview exercises: using nonstandard copies table spaces other than LOB table postpone backout work during DB2Special recovery situations spaces restartsExercises: special recovery situations Use list definitions in utility control Cancel the postponed backout for objectsReview exercises: special recovery statements and understand how they being recovered or replaced situations expand Normal backup of table and index spacesApplication recovery Describe the concept and working of Exercises: normal backup of table and

templates replacing utility Dataset index spacesDefinition (DD) statements Review exercises: normal backup of table

line Use templates in utility jobs to simplify and index spacesExplain the basic DB2 logging concept Job Control Language (JCL) Normal recovery of table and index spacesExplain the basic DB2 backup and recovery Use templates together with list Exercises: normal recovery of table andconcept definitions index spacesDescribe the restrictive and advisory states Use the OPTIONS utility control Review exercises: normal recovery of tablerelevant for backup and recovery statement to control execution and index spaces Explain the purpose of the Logical Page List parameters for utility jobs Exercises: point-in-time recoveryand of Write Error Page Ranges Restore DB2 DFSMS concurrent copies Review exercises: point-in-time recoveryCreate conditional image copies for table established using the CONCURRENT Generic utility jobsspaces option Exercises: generic utility jobsCreate image copies for indexes Understand the prerequisites for Review exercises: generic utility jobs Establish additional copies of image copies establishing nonstandard copies Exercises: using nonstandard copiesMerge full and incremental image copies to Establish and restore nonstandard copies Review exercises: using nonstandardobtain new full or incremental image copies using the DSN1COPY stand-alone utility copiesDelete image copies no longer needed Establish and restore nonstandard copies Special recovery situationsRecover a table space or COPY enabled using native DFSMS Data Set Services Exercises: special recovery situationsindex space to current (DFSMSdss) Review exercises: special recoveryAn entire table space or index space Apply log changes to restored copies situationsA partition or data set Prevent the accidental dropping of tables, Application recoveryAn error range table spaces, or databasesReplace defective volumes during recovery Recover accidentally dropped table Day 2 Relate the fallback recovery concept spaces lineRebuild indexes Recover accidentally dropped tables Point-in-time recoveryPrepare point-in-time recoveries Print and analyze pages of table spacesPerform point-in-time recoveries involving or partitionstable spaces other than LOB table spaces Repair pages of table spaces if lineUse list definitions in utility control necessary Explain the basic DB2 logging conceptstatements and understand how they Teach application programmers how to Explain the basic DB2 backup andexpand make programs restartable recovery conceptDescribe the concept and working of Advise system programmers in canceling Describe the restrictive and advisory statestemplates replacing utility Dataset Definition threads without backout being performed relevant for backup and recovery(DD) statements Instruct system programmers how to Explain the purpose of the Logical PageUse templates in utility jobs to simplify Job postpone backout work during DB2 List and of Write Error Page Ranges Control Language (JCL) restarts Create conditional image copies for tableUse templates together with list definitions Cancel the postponed backout for objects spacesUse the OPTIONS utility control statement being recovered or replaced Create image copies for indexesto control execution parameters for utility Normal backup of table and index spaces Establish additional copies of imagejobs Exercises: normal backup of table and copiesRestore DB2 DFSMS concurrent copies index spaces Merge full and incremental image copies toestablished using the CONCURRENT option Review exercises: normal backup of table obtain new full or incremental imageUnderstand the prerequisites for establishing and index spaces copiesnonstandard copies Normal recovery of table and index Delete image copies no longer needed Establish and restore nonstandard copies spaces Recover a table space or COPY enabledusing the DSN1COPY stand-alone utility Exercises: normal recovery of table and index space to currentEstablish and restore nonstandard copies index spaces An entire table space or index spaceusing native DFSMS Data Set Services Review exercises: normal recovery of A partition or data set(DFSMSdss) table and index spaces An error range Apply log changes to restored copies Exercises: point-in-time recovery Replace defective volumes during recoveryPrevent the accidental dropping of tables, Review exercises: point-in-time recovery Relate the fallback recovery concepttable spaces, or databases Generic utility jobs Rebuild indexes Recover accidentally dropped table spaces Exercises: generic utility jobs Prepare point-in-time recoveriesRecover accidentally dropped tables Review exercises: generic utility jobs Perform point-in-time recoveries involvingPrint and analyze pages of table spaces or Exercises: using nonstandard copies table spaces other than LOB table spaces partitions Review exercises: using nonstandard Use list definitions in utility controlRepair pages of table spaces if necessary copies statements and understand how theyTeach application programmers how to Special recovery situations expand


make programs restartable Exercises: special recovery situations Describe the concept and working ofAdvise system programmers in canceling Review exercises: special recovery templates replacing utility Datasetthreads without backout being performed situations Definition (DD) statementsInstruct system programmers how to Application recovery Use templates in utility jobs to simplify Jobpostpone backout work during DB2 restarts Control Language (JCL)Cancel the postponed backout for objects Use templates together with list definitionsbeing recovered or replaced line Use the OPTIONS utility control statementNormal backup of table and index spaces Explain the basic DB2 logging concept to control execution parameters for utilityExercises: normal backup of table and index Explain the basic DB2 backup and jobs spaces recovery concept Restore DB2 DFSMS concurrent copiesReview exercises: normal backup of table Describe the restrictive and advisory established using the CONCURRENTand index spaces states relevant for backup and recovery optionNormal recovery of table and index spaces Explain the purpose of the Logical Page Understand the prerequisites forExercises: normal recovery of table and List and of Write Error Page Ranges establishing nonstandard copiesindex spaces Create conditional image copies for table Establish and restore nonstandard copiesReview exercises: normal recovery of table spaces using the DSN1COPY stand-alone utilityand index spaces Create image copies for indexes Establish and restore nonstandard copiesExercises: point-in-time recovery Establish additional copies of image using native DFSMS Data Set ServicesReview exercises: point-in-time recovery copies (DFSMSdss)Generic utility jobs Merge full and incremental image copies Apply log changes to restored copies Exercises: generic utility jobs to obtain new full or incremental image Prevent the accidental dropping of tables,Review exercises: generic utility jobs copies table spaces, or databasesExercises: using nonstandard copies Delete image copies no longer needed Recover accidentally dropped table spacesReview exercises: using nonstandard copies Recover a table space or COPY enabled Recover accidentally dropped tablesSpecial recovery situations index space to current Print and analyze pages of table spaces orExercises: special recovery situations An entire table space or index space partitionsReview exercises: special recovery A partition or data set Repair pages of table spaces if necessary situations An error range Teach application programmers how toApplication recovery Replace defective volumes during make programs restartable

recovery Advise system programmers in cancelingRelate the fallback recovery concept threads without backout being performed

line Rebuild indexes Instruct system programmers how toExplain the basic DB2 logging concept Prepare point-in-time recoveries postpone backout work during DB2Explain the basic DB2 backup and recovery Perform point-in-time recoveries involving restartsconcept table spaces other than LOB table Cancel the postponed backout for objectsDescribe the restrictive and advisory states spaces being recovered or replaced relevant for backup and recovery Use list definitions in utility control Normal backup of table and index spacesExplain the purpose of the Logical Page List statements and understand how they Exercises: normal backup of table andand of Write Error Page Ranges expand index spacesCreate conditional image copies for table Describe the concept and working of Review exercises: normal backup of tablespaces templates replacing utility Dataset and index spacesCreate image copies for indexes Definition (DD) statements Normal recovery of table and index spacesEstablish additional copies of image copies Use templates in utility jobs to simplify Exercises: normal recovery of table andMerge full and incremental image copies to Job Control Language (JCL) index spacesobtain new full or incremental image copies Use templates together with list Review exercises: normal recovery of tableDelete image copies no longer needed definitions and index spaces Recover a table space or COPY enabled Use the OPTIONS utility control Exercises: point-in-time recoveryindex space to current statement to control execution Review exercises: point-in-time recoveryAn entire table space or index space parameters for utility jobs Generic utility jobsA partition or data set Restore DB2 DFSMS concurrent copies Exercises: generic utility jobsAn error range established using the CONCURRENT Review exercises: generic utility jobs Replace defective volumes during recovery option Exercises: using nonstandard copiesRelate the fallback recovery concept Understand the prerequisites for Review exercises: using nonstandardRebuild indexes establishing nonstandard copies copiesPrepare point-in-time recoveries Establish and restore nonstandard copies Special recovery situationsPerform point-in-time recoveries involving using the DSN1COPY stand-alone utility Exercises: special recovery situationstable spaces other than LOB table spaces Establish and restore nonstandard copies Review exercises: special recoveryUse list definitions in utility control using native DFSMS Data Set Services situationsstatements and understand how they (DFSMSdss) Application recoveryexpand Apply log changes to restored copies Describe the concept and working of Prevent the accidental dropping of tables,templates replacing utility Dataset Definition table spaces, or databases line(DD) statements Recover accidentally dropped table Explain the basic DB2 logging conceptUse templates in utility jobs to simplify Job spaces Explain the basic DB2 backup andControl Language (JCL) Recover accidentally dropped tables recovery conceptUse templates together with list definitions Print and analyze pages of table spaces Describe the restrictive and advisory states


Use the OPTIONS utility control statement or partitions relevant for backup and recoveryto control execution parameters for utility Repair pages of table spaces if Explain the purpose of the Logical Pagejobs necessary List and of Write Error Page Ranges Restore DB2 DFSMS concurrent copies Teach application programmers how to Create conditional image copies for tableestablished using the CONCURRENT option make programs restartable spacesUnderstand the prerequisites for establishing Advise system programmers in canceling Create image copies for indexesnonstandard copies threads without backout being performed Establish additional copies of imageEstablish and restore nonstandard copies Instruct system programmers how to copiesusing the DSN1COPY stand-alone utility postpone backout work during DB2 Merge full and incremental image copies toEstablish and restore nonstandard copies restarts obtain new full or incremental imageusing native DFSMS Data Set Services Cancel the postponed backout for objects copies(DFSMSdss) being recovered or replaced Delete image copies no longer needed Apply log changes to restored copies Normal backup of table and index spaces Recover a table space or COPY enabledPrevent the accidental dropping of tables, Exercises: normal backup of table and index space to currenttable spaces, or databases index spaces An entire table space or index spaceRecover accidentally dropped table spaces Review exercises: normal backup of table A partition or data setRecover accidentally dropped tables and index spaces An error range Print and analyze pages of table spaces or Normal recovery of table and index Replace defective volumes during recoverypartitions spaces Relate the fallback recovery conceptRepair pages of table spaces if necessary Exercises: normal recovery of table and Rebuild indexes Teach application programmers how to index spaces Prepare point-in-time recoveriesmake programs restartable Review exercises: normal recovery of Perform point-in-time recoveries involvingAdvise system programmers in canceling table and index spaces table spaces other than LOB table spaces threads without backout being performed Exercises: point-in-time recovery Use list definitions in utility controlInstruct system programmers how to Review exercises: point-in-time recovery statements and understand how theypostpone backout work during DB2 restarts Generic utility jobs expandCancel the postponed backout for objects Exercises: generic utility jobs Describe the concept and working ofbeing recovered or replaced Review exercises: generic utility jobs templates replacing utility DatasetNormal backup of table and index spaces Exercises: using nonstandard copies Definition (DD) statementsExercises: normal backup of table and index Review exercises: using nonstandard Use templates in utility jobs to simplify Jobspaces copies Control Language (JCL)Review exercises: normal backup of table Special recovery situations Use templates together with list definitionsand index spaces Exercises: special recovery situations Use the OPTIONS utility control statementNormal recovery of table and index spaces Review exercises: special recovery to control execution parameters for utilityExercises: normal recovery of table and situations jobs index spaces Application recovery Restore DB2 DFSMS concurrent copiesReview exercises: normal recovery of table established using the CONCURRENTand index spaces optionExercises: point-in-time recovery line Understand the prerequisites forReview exercises: point-in-time recovery Explain the basic DB2 logging concept establishing nonstandard copiesGeneric utility jobs Explain the basic DB2 backup and Establish and restore nonstandard copiesExercises: generic utility jobs recovery concept using the DSN1COPY stand-alone utilityReview exercises: generic utility jobs Describe the restrictive and advisory Establish and restore nonstandard copiesExercises: using nonstandard copies states relevant for backup and recovery using native DFSMS Data Set ServicesReview exercises: using nonstandard copies Explain the purpose of the Logical Page (DFSMSdss)Special recovery situations List and of Write Error Page Ranges Apply log changes to restored copies Exercises: special recovery situations Create conditional image copies for table Prevent the accidental dropping of tables,Review exercises: special recovery spaces table spaces, or databasessituations Create image copies for indexes Recover accidentally dropped table spacesApplication recovery Establish additional copies of image Recover accidentally dropped tables

copies Print and analyze pages of table spaces orMerge full and incremental image copies partitions

line to obtain new full or incremental image Repair pages of table spaces if necessary Explain the basic DB2 logging concept copies Teach application programmers how toExplain the basic DB2 backup and recovery Delete image copies no longer needed make programs restartableconcept Recover a table space or COPY enabled Advise system programmers in cancelingDescribe the restrictive and advisory states index space to current threads without backout being performedrelevant for backup and recovery An entire table space or index space Instruct system programmers how toExplain the purpose of the Logical Page List A partition or data set postpone backout work during DB2and of Write Error Page Ranges An error range restartsCreate conditional image copies for table Replace defective volumes during Cancel the postponed backout for objectsspaces recovery being recovered or replaced Create image copies for indexes Relate the fallback recovery concept Normal backup of table and index spacesEstablish additional copies of image copies Rebuild indexes Exercises: normal backup of table andMerge full and incremental image copies to Prepare point-in-time recoveries index spacesobtain new full or incremental image copies Perform point-in-time recoveries involving Review exercises: normal backup of table


Delete image copies no longer needed table spaces other than LOB table and index spacesRecover a table space or COPY enabled spaces Normal recovery of table and index spacesindex space to current Use list definitions in utility control Exercises: normal recovery of table andAn entire table space or index space statements and understand how they index spacesA partition or data set expand Review exercises: normal recovery of tableAn error range Describe the concept and working of and index spaces Replace defective volumes during recovery templates replacing utility Dataset Exercises: point-in-time recoveryRelate the fallback recovery concept Definition (DD) statements Review exercises: point-in-time recoveryRebuild indexes Use templates in utility jobs to simplify Generic utility jobsPrepare point-in-time recoveries Job Control Language (JCL) Exercises: generic utility jobsPerform point-in-time recoveries involving Use templates together with list Review exercises: generic utility jobs table spaces other than LOB table spaces definitions Exercises: using nonstandard copiesUse list definitions in utility control Use the OPTIONS utility control Review exercises: using nonstandardstatements and understand how they statement to control execution copiesexpand parameters for utility jobs Special recovery situationsDescribe the concept and working of Restore DB2 DFSMS concurrent copies Exercises: special recovery situationstemplates replacing utility Dataset Definition established using the CONCURRENT Review exercises: special recovery(DD) statements option situationsUse templates in utility jobs to simplify Job Understand the prerequisites for Application recoveryControl Language (JCL) establishing nonstandard copiesUse templates together with list definitions Establish and restore nonstandard copiesUse the OPTIONS utility control statement using the DSN1COPY stand-alone utility lineto control execution parameters for utility Establish and restore nonstandard copies Explain the basic DB2 logging conceptjobs using native DFSMS Data Set Services Explain the basic DB2 backup andRestore DB2 DFSMS concurrent copies (DFSMSdss) recovery conceptestablished using the CONCURRENT option Apply log changes to restored copies Describe the restrictive and advisory statesUnderstand the prerequisites for establishing Prevent the accidental dropping of tables, relevant for backup and recoverynonstandard copies table spaces, or databases Explain the purpose of the Logical PageEstablish and restore nonstandard copies Recover accidentally dropped table List and of Write Error Page Ranges using the DSN1COPY stand-alone utility spaces Create conditional image copies for tableEstablish and restore nonstandard copies Recover accidentally dropped tables spacesusing native DFSMS Data Set Services Print and analyze pages of table spaces Create image copies for indexes(DFSMSdss) or partitions Establish additional copies of imageApply log changes to restored copies Repair pages of table spaces if copiesPrevent the accidental dropping of tables, necessary Merge full and incremental image copies totable spaces, or databases Teach application programmers how to obtain new full or incremental imageRecover accidentally dropped table spaces make programs restartable copiesRecover accidentally dropped tables Advise system programmers in canceling Delete image copies no longer needed Print and analyze pages of table spaces or threads without backout being performed Recover a table space or COPY enabledpartitions Instruct system programmers how to index space to currentRepair pages of table spaces if necessary postpone backout work during DB2 An entire table space or index spaceTeach application programmers how to restarts A partition or data setmake programs restartable Cancel the postponed backout for objects An error range Advise system programmers in canceling being recovered or replaced Replace defective volumes during recoverythreads without backout being performed Normal backup of table and index spaces Relate the fallback recovery conceptInstruct system programmers how to Exercises: normal backup of table and Rebuild indexes postpone backout work during DB2 restarts index spaces Prepare point-in-time recoveriesCancel the postponed backout for objects Review exercises: normal backup of table Perform point-in-time recoveries involvingbeing recovered or replaced and index spaces table spaces other than LOB table spaces Normal backup of table and index spaces Normal recovery of table and index Use list definitions in utility controlExercises: normal backup of table and index spaces statements and understand how theyspaces Exercises: normal recovery of table and expandReview exercises: normal backup of table index spaces Describe the concept and working ofand index spaces Review exercises: normal recovery of templates replacing utility DatasetNormal recovery of table and index spaces table and index spaces Definition (DD) statementsExercises: normal recovery of table and Exercises: point-in-time recovery Use templates in utility jobs to simplify Jobindex spaces Review exercises: point-in-time recovery Control Language (JCL)Review exercises: normal recovery of table Generic utility jobs Use templates together with list definitionsand index spaces Exercises: generic utility jobs Use the OPTIONS utility control statementExercises: point-in-time recovery Review exercises: generic utility jobs to control execution parameters for utilityReview exercises: point-in-time recovery Exercises: using nonstandard copies jobs Generic utility jobs Review exercises: using nonstandard Restore DB2 DFSMS concurrent copiesExercises: generic utility jobs copies established using the CONCURRENTReview exercises: generic utility jobs Special recovery situations optionExercises: using nonstandard copies Exercises: special recovery situations Understand the prerequisites forReview exercises: using nonstandard copies Review exercises: special recovery establishing nonstandard copies


Special recovery situations situations Establish and restore nonstandard copiesExercises: special recovery situations Application recovery using the DSN1COPY stand-alone utilityReview exercises: special recovery Establish and restore nonstandard copiessituations using native DFSMS Data Set ServicesApplication recovery line (DFSMSdss)

Explain the basic DB2 logging concept Apply log changes to restored copies Normal recovery of table and index spaces Explain the basic DB2 backup and Prevent the accidental dropping of tables,(normal recovery in this context means the recovery concept table spaces, or databasesrecovery using DB2 image copies and the Describe the restrictive and advisory Recover accidentally dropped table spacesRECOVER utility) states relevant for backup and recovery Recover accidentally dropped tablesline Explain the purpose of the Logical Page Print and analyze pages of table spaces or

Prepare the recovery of a table space or List and of Write Error Page Ranges partitionsindex space Create conditional image copies for table Repair pages of table spaces if necessary

spaces Teach application programmers how toCreate image copies for indexes make programs restartable

line Establish additional copies of image Advise system programmers in cancelingExplain the basic DB2 logging concept copies threads without backout being performedExplain the basic DB2 backup and recovery Merge full and incremental image copies Instruct system programmers how toconcept to obtain new full or incremental image postpone backout work during DB2Describe the restrictive and advisory states copies restartsrelevant for backup and recovery Delete image copies no longer needed Cancel the postponed backout for objectsExplain the purpose of the Logical Page List Recover a table space or COPY enabled being recovered or replaced and of Write Error Page Ranges index space to current Normal backup of table and index spacesCreate conditional image copies for table An entire table space or index space Exercises: normal backup of table andspaces A partition or data set index spacesCreate image copies for indexes An error range Review exercises: normal backup of tableEstablish additional copies of image copies Replace defective volumes during and index spacesMerge full and incremental image copies to recovery Normal recovery of table and index spacesobtain new full or incremental image copies Relate the fallback recovery concept Exercises: normal recovery of table andDelete image copies no longer needed Rebuild indexes index spacesRecover a table space or COPY enabled Prepare point-in-time recoveries Review exercises: normal recovery of tableindex space to current Perform point-in-time recoveries involving and index spaces An entire table space or index space table spaces other than LOB table Exercises: point-in-time recoveryA partition or data set spaces Review exercises: point-in-time recoveryAn error range Use list definitions in utility control Generic utility jobsReplace defective volumes during recovery statements and understand how they Exercises: generic utility jobsRelate the fallback recovery concept expand Review exercises: generic utility jobs Rebuild indexes Describe the concept and working of Exercises: using nonstandard copiesPrepare point-in-time recoveries templates replacing utility Dataset Review exercises: using nonstandardPerform point-in-time recoveries involving Definition (DD) statements copiestable spaces other than LOB table spaces Use templates in utility jobs to simplify Special recovery situationsUse list definitions in utility control Job Control Language (JCL) Exercises: special recovery situationsstatements and understand how they Use templates together with list Review exercises: special recoveryexpand definitions situationsDescribe the concept and working of Use the OPTIONS utility control Application recoverytemplates replacing utility Dataset Definition statement to control execution(DD) statements parameters for utility jobs Use templates in utility jobs to simplify Job Restore DB2 DFSMS concurrent copies lineControl Language (JCL) established using the CONCURRENT Explain the basic DB2 logging conceptUse templates together with list definitions option Explain the basic DB2 backup andUse the OPTIONS utility control statement Understand the prerequisites for recovery conceptto control execution parameters for utility establishing nonstandard copies Describe the restrictive and advisory statesjobs Establish and restore nonstandard copies relevant for backup and recoveryRestore DB2 DFSMS concurrent copies using the DSN1COPY stand-alone utility Explain the purpose of the Logical Pageestablished using the CONCURRENT option Establish and restore nonstandard copies List and of Write Error Page Ranges Understand the prerequisites for establishing using native DFSMS Data Set Services Create conditional image copies for tablenonstandard copies (DFSMSdss) spacesEstablish and restore nonstandard copies Apply log changes to restored copies Create image copies for indexesusing the DSN1COPY stand-alone utility Prevent the accidental dropping of tables, Establish additional copies of imageEstablish and restore nonstandard copies table spaces, or databases copiesusing native DFSMS Data Set Services Recover accidentally dropped table Merge full and incremental image copies to(DFSMSdss) spaces obtain new full or incremental imageApply log changes to restored copies Recover accidentally dropped tables copiesPrevent the accidental dropping of tables, Print and analyze pages of table spaces Delete image copies no longer needed table spaces, or databases or partitions Recover a table space or COPY enabledRecover accidentally dropped table spaces Repair pages of table spaces if index space to current


Recover accidentally dropped tables necessary An entire table space or index spacePrint and analyze pages of table spaces or Teach application programmers how to A partition or data setpartitions make programs restartable An error range Repair pages of table spaces if necessary Advise system programmers in canceling Replace defective volumes during recoveryTeach application programmers how to threads without backout being performed Relate the fallback recovery conceptmake programs restartable Instruct system programmers how to Rebuild indexes Advise system programmers in canceling postpone backout work during DB2 Prepare point-in-time recoveriesthreads without backout being performed restarts Perform point-in-time recoveries involvingInstruct system programmers how to Cancel the postponed backout for objects table spaces other than LOB table spaces postpone backout work during DB2 restarts being recovered or replaced Use list definitions in utility controlCancel the postponed backout for objects Normal backup of table and index spaces statements and understand how theybeing recovered or replaced Exercises: normal backup of table and expandNormal backup of table and index spaces index spaces Describe the concept and working ofExercises: normal backup of table and index Review exercises: normal backup of table templates replacing utility Datasetspaces and index spaces Definition (DD) statementsReview exercises: normal backup of table Normal recovery of table and index Use templates in utility jobs to simplify Joband index spaces spaces Control Language (JCL)Normal recovery of table and index spaces Exercises: normal recovery of table and Use templates together with list definitionsExercises: normal recovery of table and index spaces Use the OPTIONS utility control statementindex spaces Review exercises: normal recovery of to control execution parameters for utilityReview exercises: normal recovery of table table and index spaces jobs and index spaces Exercises: point-in-time recovery Restore DB2 DFSMS concurrent copiesExercises: point-in-time recovery Review exercises: point-in-time recovery established using the CONCURRENTReview exercises: point-in-time recovery Generic utility jobs optionGeneric utility jobs Exercises: generic utility jobs Understand the prerequisites forExercises: generic utility jobs Review exercises: generic utility jobs establishing nonstandard copiesReview exercises: generic utility jobs Exercises: using nonstandard copies Establish and restore nonstandard copiesExercises: using nonstandard copies Review exercises: using nonstandard using the DSN1COPY stand-alone utilityReview exercises: using nonstandard copies copies Establish and restore nonstandard copiesSpecial recovery situations Special recovery situations using native DFSMS Data Set ServicesExercises: special recovery situations Exercises: special recovery situations (DFSMSdss)Review exercises: special recovery Review exercises: special recovery Apply log changes to restored copies situations situations Prevent the accidental dropping of tables,Application recovery Application recovery table spaces, or databases

Recover accidentally dropped table spacesSpecial recovery situations (including Recover accidentally dropped tables

line down-level data, the recovery of dropped Print and analyze pages of table spaces orExplain the basic DB2 logging concept objects, and the repair of pages) partitionsExplain the basic DB2 backup and recovery line Repair pages of table spaces if necessary concept Handle down-level data Teach application programmers how toDescribe the restrictive and advisory states make programs restartablerelevant for backup and recovery Advise system programmers in cancelingExplain the purpose of the Logical Page List line threads without backout being performedand of Write Error Page Ranges Explain the basic DB2 logging concept Instruct system programmers how toCreate conditional image copies for table Explain the basic DB2 backup and postpone backout work during DB2spaces recovery concept restartsCreate image copies for indexes Describe the restrictive and advisory Cancel the postponed backout for objectsEstablish additional copies of image copies states relevant for backup and recovery being recovered or replaced Merge full and incremental image copies to Explain the purpose of the Logical Page Normal backup of table and index spacesobtain new full or incremental image copies List and of Write Error Page Ranges Exercises: normal backup of table andDelete image copies no longer needed Create conditional image copies for table index spacesRecover a table space or COPY enabled spaces Review exercises: normal backup of tableindex space to current Create image copies for indexes and index spacesAn entire table space or index space Establish additional copies of image Normal recovery of table and index spacesA partition or data set copies Exercises: normal recovery of table andAn error range Merge full and incremental image copies index spacesReplace defective volumes during recovery to obtain new full or incremental image Review exercises: normal recovery of tableRelate the fallback recovery concept copies and index spaces Rebuild indexes Delete image copies no longer needed Exercises: point-in-time recoveryPrepare point-in-time recoveries Recover a table space or COPY enabled Review exercises: point-in-time recoveryPerform point-in-time recoveries involving index space to current Generic utility jobstable spaces other than LOB table spaces An entire table space or index space Exercises: generic utility jobsUse list definitions in utility control A partition or data set Review exercises: generic utility jobs statements and understand how they An error range Exercises: using nonstandard copiesexpand Replace defective volumes during Review exercises: using nonstandardDescribe the concept and working of recovery copies


templates replacing utility Dataset Definition Relate the fallback recovery concept Special recovery situations(DD) statements Rebuild indexes Exercises: special recovery situationsUse templates in utility jobs to simplify Job Prepare point-in-time recoveries Review exercises: special recoveryControl Language (JCL) Perform point-in-time recoveries involving situationsUse templates together with list definitions table spaces other than LOB table Application recoveryUse the OPTIONS utility control statement spaces to control execution parameters for utility Use list definitions in utility controljobs statements and understand how they lineRestore DB2 DFSMS concurrent copies expand Explain the basic DB2 logging conceptestablished using the CONCURRENT option Describe the concept and working of Explain the basic DB2 backup andUnderstand the prerequisites for establishing templates replacing utility Dataset recovery conceptnonstandard copies Definition (DD) statements Describe the restrictive and advisory statesEstablish and restore nonstandard copies Use templates in utility jobs to simplify relevant for backup and recoveryusing the DSN1COPY stand-alone utility Job Control Language (JCL) Explain the purpose of the Logical PageEstablish and restore nonstandard copies Use templates together with list List and of Write Error Page Ranges using native DFSMS Data Set Services definitions Create conditional image copies for table(DFSMSdss) Use the OPTIONS utility control spacesApply log changes to restored copies statement to control execution Create image copies for indexesPrevent the accidental dropping of tables, parameters for utility jobs Establish additional copies of imagetable spaces, or databases Restore DB2 DFSMS concurrent copies copiesRecover accidentally dropped table spaces established using the CONCURRENT Merge full and incremental image copies toRecover accidentally dropped tables option obtain new full or incremental imagePrint and analyze pages of table spaces or Understand the prerequisites for copiespartitions establishing nonstandard copies Delete image copies no longer needed Repair pages of table spaces if necessary Establish and restore nonstandard copies Recover a table space or COPY enabledTeach application programmers how to using the DSN1COPY stand-alone utility index space to currentmake programs restartable Establish and restore nonstandard copies An entire table space or index spaceAdvise system programmers in canceling using native DFSMS Data Set Services A partition or data setthreads without backout being performed (DFSMSdss) An error range Instruct system programmers how to Apply log changes to restored copies Replace defective volumes during recoverypostpone backout work during DB2 restarts Prevent the accidental dropping of tables, Relate the fallback recovery conceptCancel the postponed backout for objects table spaces, or databases Rebuild indexes being recovered or replaced Recover accidentally dropped table Prepare point-in-time recoveriesNormal backup of table and index spaces spaces Perform point-in-time recoveries involvingExercises: normal backup of table and index Recover accidentally dropped tables table spaces other than LOB table spaces spaces Print and analyze pages of table spaces Use list definitions in utility controlReview exercises: normal backup of table or partitions statements and understand how theyand index spaces Repair pages of table spaces if expandNormal recovery of table and index spaces necessary Describe the concept and working ofExercises: normal recovery of table and Teach application programmers how to templates replacing utility Datasetindex spaces make programs restartable Definition (DD) statementsReview exercises: normal recovery of table Advise system programmers in canceling Use templates in utility jobs to simplify Joband index spaces threads without backout being performed Control Language (JCL)Exercises: point-in-time recovery Instruct system programmers how to Use templates together with list definitionsReview exercises: point-in-time recovery postpone backout work during DB2 Use the OPTIONS utility control statementGeneric utility jobs restarts to control execution parameters for utilityExercises: generic utility jobs Cancel the postponed backout for objects jobs Review exercises: generic utility jobs being recovered or replaced Restore DB2 DFSMS concurrent copiesExercises: using nonstandard copies Normal backup of table and index spaces established using the CONCURRENTReview exercises: using nonstandard copies Exercises: normal backup of table and optionSpecial recovery situations index spaces Understand the prerequisites forExercises: special recovery situations Review exercises: normal backup of table establishing nonstandard copiesReview exercises: special recovery and index spaces Establish and restore nonstandard copiessituations Normal recovery of table and index using the DSN1COPY stand-alone utilityApplication recovery spaces Establish and restore nonstandard copies

Exercises: normal recovery of table and using native DFSMS Data Set Servicesindex spaces (DFSMSdss)

line Review exercises: normal recovery of Apply log changes to restored copies Explain the basic DB2 logging concept table and index spaces Prevent the accidental dropping of tables,Explain the basic DB2 backup and recovery Exercises: point-in-time recovery table spaces, or databasesconcept Review exercises: point-in-time recovery Recover accidentally dropped table spacesDescribe the restrictive and advisory states Generic utility jobs Recover accidentally dropped tablesrelevant for backup and recovery Exercises: generic utility jobs Print and analyze pages of table spaces orExplain the purpose of the Logical Page List Review exercises: generic utility jobs partitionsand of Write Error Page Ranges Exercises: using nonstandard copies Repair pages of table spaces if necessary Create conditional image copies for table Review exercises: using nonstandard Teach application programmers how to


spaces copies make programs restartableCreate image copies for indexes Special recovery situations Advise system programmers in cancelingEstablish additional copies of image copies Exercises: special recovery situations threads without backout being performedMerge full and incremental image copies to Review exercises: special recovery Instruct system programmers how toobtain new full or incremental image copies situations postpone backout work during DB2Delete image copies no longer needed Application recovery restartsRecover a table space or COPY enabled Cancel the postponed backout for objectsindex space to current being recovered or replaced An entire table space or index space line Normal backup of table and index spacesA partition or data set Explain the basic DB2 logging concept Exercises: normal backup of table andAn error range Explain the basic DB2 backup and index spacesReplace defective volumes during recovery recovery concept Review exercises: normal backup of tableRelate the fallback recovery concept Describe the restrictive and advisory and index spacesRebuild indexes states relevant for backup and recovery Normal recovery of table and index spacesPrepare point-in-time recoveries Explain the purpose of the Logical Page Exercises: normal recovery of table andPerform point-in-time recoveries involving List and of Write Error Page Ranges index spacestable spaces other than LOB table spaces Create conditional image copies for table Review exercises: normal recovery of tableUse list definitions in utility control spaces and index spaces statements and understand how they Create image copies for indexes Exercises: point-in-time recoveryexpand Establish additional copies of image Review exercises: point-in-time recoveryDescribe the concept and working of copies Generic utility jobstemplates replacing utility Dataset Definition Merge full and incremental image copies Exercises: generic utility jobs(DD) statements to obtain new full or incremental image Review exercises: generic utility jobs Use templates in utility jobs to simplify Job copies Exercises: using nonstandard copiesControl Language (JCL) Delete image copies no longer needed Review exercises: using nonstandardUse templates together with list definitions Recover a table space or COPY enabled copiesUse the OPTIONS utility control statement index space to current Special recovery situationsto control execution parameters for utility An entire table space or index space Exercises: special recovery situationsjobs A partition or data set Review exercises: special recoveryRestore DB2 DFSMS concurrent copies An error range situationsestablished using the CONCURRENT option Replace defective volumes during Application recoveryUnderstand the prerequisites for establishing recoverynonstandard copies Relate the fallback recovery concept Day 3 Establish and restore nonstandard copies Rebuild indexes lineusing the DSN1COPY stand-alone utility Prepare point-in-time recoveries Using nonstandard copiesEstablish and restore nonstandard copies Perform point-in-time recoveries involvingusing native DFSMS Data Set Services table spaces other than LOB table(DFSMSdss) spaces lineApply log changes to restored copies Use list definitions in utility control Explain the basic DB2 logging conceptPrevent the accidental dropping of tables, statements and understand how they Explain the basic DB2 backup andtable spaces, or databases expand recovery conceptRecover accidentally dropped table spaces Describe the concept and working of Describe the restrictive and advisory statesRecover accidentally dropped tables templates replacing utility Dataset relevant for backup and recoveryPrint and analyze pages of table spaces or Definition (DD) statements Explain the purpose of the Logical Pagepartitions Use templates in utility jobs to simplify List and of Write Error Page Ranges Repair pages of table spaces if necessary Job Control Language (JCL) Create conditional image copies for tableTeach application programmers how to Use templates together with list spacesmake programs restartable definitions Create image copies for indexesAdvise system programmers in canceling Use the OPTIONS utility control Establish additional copies of imagethreads without backout being performed statement to control execution copiesInstruct system programmers how to parameters for utility jobs Merge full and incremental image copies topostpone backout work during DB2 restarts Restore DB2 DFSMS concurrent copies obtain new full or incremental imageCancel the postponed backout for objects established using the CONCURRENT copiesbeing recovered or replaced option Delete image copies no longer needed Normal backup of table and index spaces Understand the prerequisites for Recover a table space or COPY enabledExercises: normal backup of table and index establishing nonstandard copies index space to currentspaces Establish and restore nonstandard copies An entire table space or index spaceReview exercises: normal backup of table using the DSN1COPY stand-alone utility A partition or data setand index spaces Establish and restore nonstandard copies An error range Normal recovery of table and index spaces using native DFSMS Data Set Services Replace defective volumes during recoveryExercises: normal recovery of table and (DFSMSdss) Relate the fallback recovery conceptindex spaces Apply log changes to restored copies Rebuild indexes Review exercises: normal recovery of table Prevent the accidental dropping of tables, Prepare point-in-time recoveriesand index spaces table spaces, or databases Perform point-in-time recoveries involvingExercises: point-in-time recovery Recover accidentally dropped table table spaces other than LOB table spaces Review exercises: point-in-time recovery spaces Use list definitions in utility control


Generic utility jobs Recover accidentally dropped tables statements and understand how theyExercises: generic utility jobs Print and analyze pages of table spaces expandReview exercises: generic utility jobs or partitions Describe the concept and working ofExercises: using nonstandard copies Repair pages of table spaces if templates replacing utility DatasetReview exercises: using nonstandard copies necessary Definition (DD) statementsSpecial recovery situations Teach application programmers how to Use templates in utility jobs to simplify JobExercises: special recovery situations make programs restartable Control Language (JCL)Review exercises: special recovery Advise system programmers in canceling Use templates together with list definitionssituations threads without backout being performed Use the OPTIONS utility control statementApplication recovery Instruct system programmers how to to control execution parameters for utility

postpone backout work during DB2 jobs restarts Restore DB2 DFSMS concurrent copies

line Cancel the postponed backout for objects established using the CONCURRENTExplain the basic DB2 logging concept being recovered or replaced optionExplain the basic DB2 backup and recovery Normal backup of table and index spaces Understand the prerequisites forconcept Exercises: normal backup of table and establishing nonstandard copiesDescribe the restrictive and advisory states index spaces Establish and restore nonstandard copiesrelevant for backup and recovery Review exercises: normal backup of table using the DSN1COPY stand-alone utilityExplain the purpose of the Logical Page List and index spaces Establish and restore nonstandard copiesand of Write Error Page Ranges Normal recovery of table and index using native DFSMS Data Set ServicesCreate conditional image copies for table spaces (DFSMSdss)spaces Exercises: normal recovery of table and Apply log changes to restored copies Create image copies for indexes index spaces Prevent the accidental dropping of tables,Establish additional copies of image copies Review exercises: normal recovery of table spaces, or databasesMerge full and incremental image copies to table and index spaces Recover accidentally dropped table spacesobtain new full or incremental image copies Exercises: point-in-time recovery Recover accidentally dropped tablesDelete image copies no longer needed Review exercises: point-in-time recovery Print and analyze pages of table spaces orRecover a table space or COPY enabled Generic utility jobs partitionsindex space to current Exercises: generic utility jobs Repair pages of table spaces if necessary An entire table space or index space Review exercises: generic utility jobs Teach application programmers how toA partition or data set Exercises: using nonstandard copies make programs restartableAn error range Review exercises: using nonstandard Advise system programmers in cancelingReplace defective volumes during recovery copies threads without backout being performedRelate the fallback recovery concept Special recovery situations Instruct system programmers how toRebuild indexes Exercises: special recovery situations postpone backout work during DB2Prepare point-in-time recoveries Review exercises: special recovery restartsPerform point-in-time recoveries involving situations Cancel the postponed backout for objectstable spaces other than LOB table spaces Application recovery being recovered or replaced Use list definitions in utility control Normal backup of table and index spacesstatements and understand how they Exercises: normal backup of table andexpand line index spacesDescribe the concept and working of Explain the basic DB2 logging concept Review exercises: normal backup of tabletemplates replacing utility Dataset Definition Explain the basic DB2 backup and and index spaces(DD) statements recovery concept Normal recovery of table and index spacesUse templates in utility jobs to simplify Job Describe the restrictive and advisory Exercises: normal recovery of table andControl Language (JCL) states relevant for backup and recovery index spacesUse templates together with list definitions Explain the purpose of the Logical Page Review exercises: normal recovery of tableUse the OPTIONS utility control statement List and of Write Error Page Ranges and index spaces to control execution parameters for utility Create conditional image copies for table Exercises: point-in-time recoveryjobs spaces Review exercises: point-in-time recoveryRestore DB2 DFSMS concurrent copies Create image copies for indexes Generic utility jobsestablished using the CONCURRENT option Establish additional copies of image Exercises: generic utility jobsUnderstand the prerequisites for establishing copies Review exercises: generic utility jobs nonstandard copies Merge full and incremental image copies Exercises: using nonstandard copiesEstablish and restore nonstandard copies to obtain new full or incremental image Review exercises: using nonstandardusing the DSN1COPY stand-alone utility copies copiesEstablish and restore nonstandard copies Delete image copies no longer needed Special recovery situationsusing native DFSMS Data Set Services Recover a table space or COPY enabled Exercises: special recovery situations(DFSMSdss) index space to current Review exercises: special recoveryApply log changes to restored copies An entire table space or index space situationsPrevent the accidental dropping of tables, A partition or data set Application recoverytable spaces, or databases An error range Recover accidentally dropped table spaces Replace defective volumes duringRecover accidentally dropped tables recovery linePrint and analyze pages of table spaces or Relate the fallback recovery concept Explain the basic DB2 logging conceptpartitions Rebuild indexes Explain the basic DB2 backup and


Repair pages of table spaces if necessary Prepare point-in-time recoveries recovery conceptTeach application programmers how to Perform point-in-time recoveries involving Describe the restrictive and advisory statesmake programs restartable table spaces other than LOB table relevant for backup and recoveryAdvise system programmers in canceling spaces Explain the purpose of the Logical Pagethreads without backout being performed Use list definitions in utility control List and of Write Error Page Ranges Instruct system programmers how to statements and understand how they Create conditional image copies for tablepostpone backout work during DB2 restarts expand spacesCancel the postponed backout for objects Describe the concept and working of Create image copies for indexesbeing recovered or replaced templates replacing utility Dataset Establish additional copies of imageNormal backup of table and index spaces Definition (DD) statements copiesExercises: normal backup of table and index Use templates in utility jobs to simplify Merge full and incremental image copies tospaces Job Control Language (JCL) obtain new full or incremental imageReview exercises: normal backup of table Use templates together with list copiesand index spaces definitions Delete image copies no longer needed Normal recovery of table and index spaces Use the OPTIONS utility control Recover a table space or COPY enabledExercises: normal recovery of table and statement to control execution index space to currentindex spaces parameters for utility jobs An entire table space or index spaceReview exercises: normal recovery of table Restore DB2 DFSMS concurrent copies A partition or data setand index spaces established using the CONCURRENT An error range Exercises: point-in-time recovery option Replace defective volumes during recoveryReview exercises: point-in-time recovery Understand the prerequisites for Relate the fallback recovery conceptGeneric utility jobs establishing nonstandard copies Rebuild indexes Exercises: generic utility jobs Establish and restore nonstandard copies Prepare point-in-time recoveriesReview exercises: generic utility jobs using the DSN1COPY stand-alone utility Perform point-in-time recoveries involvingExercises: using nonstandard copies Establish and restore nonstandard copies table spaces other than LOB table spaces Review exercises: using nonstandard copies using native DFSMS Data Set Services Use list definitions in utility controlSpecial recovery situations (DFSMSdss) statements and understand how theyExercises: special recovery situations Apply log changes to restored copies expandReview exercises: special recovery Prevent the accidental dropping of tables, Describe the concept and working ofsituations table spaces, or databases templates replacing utility DatasetApplication recovery Recover accidentally dropped table Definition (DD) statements

spaces Use templates in utility jobs to simplify JobRecover accidentally dropped tables Control Language (JCL)

line Print and analyze pages of table spaces Use templates together with list definitionsExplain the basic DB2 logging concept or partitions Use the OPTIONS utility control statementExplain the basic DB2 backup and recovery Repair pages of table spaces if to control execution parameters for utilityconcept necessary jobs Describe the restrictive and advisory states Teach application programmers how to Restore DB2 DFSMS concurrent copiesrelevant for backup and recovery make programs restartable established using the CONCURRENTExplain the purpose of the Logical Page List Advise system programmers in canceling optionand of Write Error Page Ranges threads without backout being performed Understand the prerequisites forCreate conditional image copies for table Instruct system programmers how to establishing nonstandard copiesspaces postpone backout work during DB2 Establish and restore nonstandard copiesCreate image copies for indexes restarts using the DSN1COPY stand-alone utilityEstablish additional copies of image copies Cancel the postponed backout for objects Establish and restore nonstandard copiesMerge full and incremental image copies to being recovered or replaced using native DFSMS Data Set Servicesobtain new full or incremental image copies Normal backup of table and index spaces (DFSMSdss)Delete image copies no longer needed Exercises: normal backup of table and Apply log changes to restored copies Recover a table space or COPY enabled index spaces Prevent the accidental dropping of tables,index space to current Review exercises: normal backup of table table spaces, or databasesAn entire table space or index space and index spaces Recover accidentally dropped table spacesA partition or data set Normal recovery of table and index Recover accidentally dropped tablesAn error range spaces Print and analyze pages of table spaces orReplace defective volumes during recovery Exercises: normal recovery of table and partitionsRelate the fallback recovery concept index spaces Repair pages of table spaces if necessary Rebuild indexes Review exercises: normal recovery of Teach application programmers how toPrepare point-in-time recoveries table and index spaces make programs restartablePerform point-in-time recoveries involving Exercises: point-in-time recovery Advise system programmers in cancelingtable spaces other than LOB table spaces Review exercises: point-in-time recovery threads without backout being performedUse list definitions in utility control Generic utility jobs Instruct system programmers how tostatements and understand how they Exercises: generic utility jobs postpone backout work during DB2expand Review exercises: generic utility jobs restartsDescribe the concept and working of Exercises: using nonstandard copies Cancel the postponed backout for objectstemplates replacing utility Dataset Definition Review exercises: using nonstandard being recovered or replaced (DD) statements copies Normal backup of table and index spacesUse templates in utility jobs to simplify Job Special recovery situations Exercises: normal backup of table and


Control Language (JCL) Exercises: special recovery situations index spacesUse templates together with list definitions Review exercises: special recovery Review exercises: normal backup of tableUse the OPTIONS utility control statement situations and index spacesto control execution parameters for utility Application recovery Normal recovery of table and index spacesjobs Exercises: normal recovery of table andRestore DB2 DFSMS concurrent copies index spacesestablished using the CONCURRENT option line Review exercises: normal recovery of tableUnderstand the prerequisites for establishing Explain the basic DB2 logging concept and index spaces nonstandard copies Explain the basic DB2 backup and Exercises: point-in-time recoveryEstablish and restore nonstandard copies recovery concept Review exercises: point-in-time recoveryusing the DSN1COPY stand-alone utility Describe the restrictive and advisory Generic utility jobsEstablish and restore nonstandard copies states relevant for backup and recovery Exercises: generic utility jobsusing native DFSMS Data Set Services Explain the purpose of the Logical Page Review exercises: generic utility jobs (DFSMSdss) List and of Write Error Page Ranges Exercises: using nonstandard copiesApply log changes to restored copies Create conditional image copies for table Review exercises: using nonstandardPrevent the accidental dropping of tables, spaces copiestable spaces, or databases Create image copies for indexes Special recovery situationsRecover accidentally dropped table spaces Establish additional copies of image Exercises: special recovery situationsRecover accidentally dropped tables copies Review exercises: special recoveryPrint and analyze pages of table spaces or Merge full and incremental image copies situationspartitions to obtain new full or incremental image Application recoveryRepair pages of table spaces if necessary copiesTeach application programmers how to Delete image copies no longer needed make programs restartable Recover a table space or COPY enabled lineAdvise system programmers in canceling index space to current Explain the basic DB2 logging conceptthreads without backout being performed An entire table space or index space Explain the basic DB2 backup andInstruct system programmers how to A partition or data set recovery conceptpostpone backout work during DB2 restarts An error range Describe the restrictive and advisory statesCancel the postponed backout for objects Replace defective volumes during relevant for backup and recoverybeing recovered or replaced recovery Explain the purpose of the Logical PageNormal backup of table and index spaces Relate the fallback recovery concept List and of Write Error Page Ranges Exercises: normal backup of table and index Rebuild indexes Create conditional image copies for tablespaces Prepare point-in-time recoveries spacesReview exercises: normal backup of table Perform point-in-time recoveries involving Create image copies for indexesand index spaces table spaces other than LOB table Establish additional copies of imageNormal recovery of table and index spaces spaces copiesExercises: normal recovery of table and Use list definitions in utility control Merge full and incremental image copies toindex spaces statements and understand how they obtain new full or incremental imageReview exercises: normal recovery of table expand copiesand index spaces Describe the concept and working of Delete image copies no longer needed Exercises: point-in-time recovery templates replacing utility Dataset Recover a table space or COPY enabledReview exercises: point-in-time recovery Definition (DD) statements index space to currentGeneric utility jobs Use templates in utility jobs to simplify An entire table space or index spaceExercises: generic utility jobs Job Control Language (JCL) A partition or data setReview exercises: generic utility jobs Use templates together with list An error range Exercises: using nonstandard copies definitions Replace defective volumes during recoveryReview exercises: using nonstandard copies Use the OPTIONS utility control Relate the fallback recovery conceptSpecial recovery situations statement to control execution Rebuild indexes Exercises: special recovery situations parameters for utility jobs Prepare point-in-time recoveriesReview exercises: special recovery Restore DB2 DFSMS concurrent copies Perform point-in-time recoveries involvingsituations established using the CONCURRENT table spaces other than LOB table spaces Application recovery option Use list definitions in utility control

Understand the prerequisites for statements and understand how theyPoint-in-time recovery (normal recovery to an establishing nonstandard copies expandearlier point in time for table spaces and index Establish and restore nonstandard copies Describe the concept and working ofspaces) using the DSN1COPY stand-alone utility templates replacing utility Datasetline Establish and restore nonstandard copies Definition (DD) statements

Plan for point-in-time recoveries using native DFSMS Data Set Services Use templates in utility jobs to simplify Job(DFSMSdss) Control Language (JCL)Apply log changes to restored copies Use templates together with list definitions

line Prevent the accidental dropping of tables, Use the OPTIONS utility control statementExplain the basic DB2 logging concept table spaces, or databases to control execution parameters for utilityExplain the basic DB2 backup and recovery Recover accidentally dropped table jobs concept spaces Restore DB2 DFSMS concurrent copiesDescribe the restrictive and advisory states Recover accidentally dropped tables established using the CONCURRENTrelevant for backup and recovery Print and analyze pages of table spaces option


Explain the purpose of the Logical Page List or partitions Understand the prerequisites forand of Write Error Page Ranges Repair pages of table spaces if establishing nonstandard copiesCreate conditional image copies for table necessary Establish and restore nonstandard copiesspaces Teach application programmers how to using the DSN1COPY stand-alone utilityCreate image copies for indexes make programs restartable Establish and restore nonstandard copiesEstablish additional copies of image copies Advise system programmers in canceling using native DFSMS Data Set ServicesMerge full and incremental image copies to threads without backout being performed (DFSMSdss)obtain new full or incremental image copies Instruct system programmers how to Apply log changes to restored copies Delete image copies no longer needed postpone backout work during DB2 Prevent the accidental dropping of tables,Recover a table space or COPY enabled restarts table spaces, or databasesindex space to current Cancel the postponed backout for objects Recover accidentally dropped table spacesAn entire table space or index space being recovered or replaced Recover accidentally dropped tablesA partition or data set Normal backup of table and index spaces Print and analyze pages of table spaces orAn error range Exercises: normal backup of table and partitionsReplace defective volumes during recovery index spaces Repair pages of table spaces if necessary Relate the fallback recovery concept Review exercises: normal backup of table Teach application programmers how toRebuild indexes and index spaces make programs restartablePrepare point-in-time recoveries Normal recovery of table and index Advise system programmers in cancelingPerform point-in-time recoveries involving spaces threads without backout being performedtable spaces other than LOB table spaces Exercises: normal recovery of table and Instruct system programmers how toUse list definitions in utility control index spaces postpone backout work during DB2statements and understand how they Review exercises: normal recovery of restartsexpand table and index spaces Cancel the postponed backout for objectsDescribe the concept and working of Exercises: point-in-time recovery being recovered or replaced templates replacing utility Dataset Definition Review exercises: point-in-time recovery Normal backup of table and index spaces(DD) statements Generic utility jobs Exercises: normal backup of table andUse templates in utility jobs to simplify Job Exercises: generic utility jobs index spacesControl Language (JCL) Review exercises: generic utility jobs Review exercises: normal backup of tableUse templates together with list definitions Exercises: using nonstandard copies and index spacesUse the OPTIONS utility control statement Review exercises: using nonstandard Normal recovery of table and index spacesto control execution parameters for utility copies Exercises: normal recovery of table andjobs Special recovery situations index spacesRestore DB2 DFSMS concurrent copies Exercises: special recovery situations Review exercises: normal recovery of tableestablished using the CONCURRENT option Review exercises: special recovery and index spaces Understand the prerequisites for establishing situations Exercises: point-in-time recoverynonstandard copies Application recovery Review exercises: point-in-time recoveryEstablish and restore nonstandard copies Generic utility jobsusing the DSN1COPY stand-alone utility Exercises: generic utility jobsEstablish and restore nonstandard copies line Review exercises: generic utility jobs using native DFSMS Data Set Services Explain the basic DB2 logging concept Exercises: using nonstandard copies(DFSMSdss) Explain the basic DB2 backup and Review exercises: using nonstandardApply log changes to restored copies recovery concept copiesPrevent the accidental dropping of tables, Describe the restrictive and advisory Special recovery situationstable spaces, or databases states relevant for backup and recovery Exercises: special recovery situationsRecover accidentally dropped table spaces Explain the purpose of the Logical Page Review exercises: special recoveryRecover accidentally dropped tables List and of Write Error Page Ranges situationsPrint and analyze pages of table spaces or Create conditional image copies for table Application recoverypartitions spacesRepair pages of table spaces if necessary Create image copies for indexesTeach application programmers how to Establish additional copies of image linemake programs restartable copies Explain the basic DB2 logging conceptAdvise system programmers in canceling Merge full and incremental image copies Explain the basic DB2 backup andthreads without backout being performed to obtain new full or incremental image recovery conceptInstruct system programmers how to copies Describe the restrictive and advisory statespostpone backout work during DB2 restarts Delete image copies no longer needed relevant for backup and recoveryCancel the postponed backout for objects Recover a table space or COPY enabled Explain the purpose of the Logical Pagebeing recovered or replaced index space to current List and of Write Error Page Ranges Normal backup of table and index spaces An entire table space or index space Create conditional image copies for tableExercises: normal backup of table and index A partition or data set spacesspaces An error range Create image copies for indexesReview exercises: normal backup of table Replace defective volumes during Establish additional copies of imageand index spaces recovery copiesNormal recovery of table and index spaces Relate the fallback recovery concept Merge full and incremental image copies toExercises: normal recovery of table and Rebuild indexes obtain new full or incremental imageindex spaces Prepare point-in-time recoveries copiesReview exercises: normal recovery of table Perform point-in-time recoveries involving Delete image copies no longer needed


and index spaces table spaces other than LOB table Recover a table space or COPY enabledExercises: point-in-time recovery spaces index space to currentReview exercises: point-in-time recovery Use list definitions in utility control An entire table space or index spaceGeneric utility jobs statements and understand how they A partition or data setExercises: generic utility jobs expand An error range Review exercises: generic utility jobs Describe the concept and working of Replace defective volumes during recoveryExercises: using nonstandard copies templates replacing utility Dataset Relate the fallback recovery conceptReview exercises: using nonstandard copies Definition (DD) statements Rebuild indexes Special recovery situations Use templates in utility jobs to simplify Prepare point-in-time recoveriesExercises: special recovery situations Job Control Language (JCL) Perform point-in-time recoveries involvingReview exercises: special recovery Use templates together with list table spaces other than LOB table spaces situations definitions Use list definitions in utility controlApplication recovery Use the OPTIONS utility control statements and understand how they

statement to control execution expandparameters for utility jobs Describe the concept and working of

line Restore DB2 DFSMS concurrent copies templates replacing utility DatasetExplain the basic DB2 logging concept established using the CONCURRENT Definition (DD) statementsExplain the basic DB2 backup and recovery option Use templates in utility jobs to simplify Jobconcept Understand the prerequisites for Control Language (JCL)Describe the restrictive and advisory states establishing nonstandard copies Use templates together with list definitionsrelevant for backup and recovery Establish and restore nonstandard copies Use the OPTIONS utility control statementExplain the purpose of the Logical Page List using the DSN1COPY stand-alone utility to control execution parameters for utilityand of Write Error Page Ranges Establish and restore nonstandard copies jobs Create conditional image copies for table using native DFSMS Data Set Services Restore DB2 DFSMS concurrent copiesspaces (DFSMSdss) established using the CONCURRENTCreate image copies for indexes Apply log changes to restored copies optionEstablish additional copies of image copies Prevent the accidental dropping of tables, Understand the prerequisites forMerge full and incremental image copies to table spaces, or databases establishing nonstandard copiesobtain new full or incremental image copies Recover accidentally dropped table Establish and restore nonstandard copiesDelete image copies no longer needed spaces using the DSN1COPY stand-alone utilityRecover a table space or COPY enabled Recover accidentally dropped tables Establish and restore nonstandard copiesindex space to current Print and analyze pages of table spaces using native DFSMS Data Set ServicesAn entire table space or index space or partitions (DFSMSdss)A partition or data set Repair pages of table spaces if Apply log changes to restored copies An error range necessary Prevent the accidental dropping of tables,Replace defective volumes during recovery Teach application programmers how to table spaces, or databasesRelate the fallback recovery concept make programs restartable Recover accidentally dropped table spacesRebuild indexes Advise system programmers in canceling Recover accidentally dropped tablesPrepare point-in-time recoveries threads without backout being performed Print and analyze pages of table spaces orPerform point-in-time recoveries involving Instruct system programmers how to partitionstable spaces other than LOB table spaces postpone backout work during DB2 Repair pages of table spaces if necessary Use list definitions in utility control restarts Teach application programmers how tostatements and understand how they Cancel the postponed backout for objects make programs restartableexpand being recovered or replaced Advise system programmers in cancelingDescribe the concept and working of Normal backup of table and index spaces threads without backout being performedtemplates replacing utility Dataset Definition Exercises: normal backup of table and Instruct system programmers how to(DD) statements index spaces postpone backout work during DB2Use templates in utility jobs to simplify Job Review exercises: normal backup of table restartsControl Language (JCL) and index spaces Cancel the postponed backout for objectsUse templates together with list definitions Normal recovery of table and index being recovered or replaced Use the OPTIONS utility control statement spaces Normal backup of table and index spacesto control execution parameters for utility Exercises: normal recovery of table and Exercises: normal backup of table andjobs index spaces index spacesRestore DB2 DFSMS concurrent copies Review exercises: normal recovery of Review exercises: normal backup of tableestablished using the CONCURRENT option table and index spaces and index spacesUnderstand the prerequisites for establishing Exercises: point-in-time recovery Normal recovery of table and index spacesnonstandard copies Review exercises: point-in-time recovery Exercises: normal recovery of table andEstablish and restore nonstandard copies Generic utility jobs index spacesusing the DSN1COPY stand-alone utility Exercises: generic utility jobs Review exercises: normal recovery of tableEstablish and restore nonstandard copies Review exercises: generic utility jobs and index spaces using native DFSMS Data Set Services Exercises: using nonstandard copies Exercises: point-in-time recovery(DFSMSdss) Review exercises: using nonstandard Review exercises: point-in-time recoveryApply log changes to restored copies copies Generic utility jobsPrevent the accidental dropping of tables, Special recovery situations Exercises: generic utility jobstable spaces, or databases Exercises: special recovery situations Review exercises: generic utility jobs Recover accidentally dropped table spaces Review exercises: special recovery Exercises: using nonstandard copies


Recover accidentally dropped tables situations Review exercises: using nonstandardPrint and analyze pages of table spaces or Application recovery copiespartitions Special recovery situationsRepair pages of table spaces if necessary Application recovery (how application Exercises: special recovery situationsTeach application programmers how to programs should be structured to preclude Review exercises: special recoverymake programs restartable recovery problems and what can be done if situationsAdvise system programmers in canceling they do not follow these recommendations) Application recoverythreads without backout being performed lineInstruct system programmers how to Convince application programmers topostpone backout work during DB2 restarts structure programs into committable units lineCancel the postponed backout for objects Explain the basic DB2 logging conceptbeing recovered or replaced Explain the basic DB2 backup andNormal backup of table and index spaces line recovery conceptExercises: normal backup of table and index Explain the basic DB2 logging concept Describe the restrictive and advisory statesspaces Explain the basic DB2 backup and relevant for backup and recoveryReview exercises: normal backup of table recovery concept Explain the purpose of the Logical Pageand index spaces Describe the restrictive and advisory List and of Write Error Page Ranges Normal recovery of table and index spaces states relevant for backup and recovery Create conditional image copies for tableExercises: normal recovery of table and Explain the purpose of the Logical Page spacesindex spaces List and of Write Error Page Ranges Create image copies for indexesReview exercises: normal recovery of table Create conditional image copies for table Establish additional copies of imageand index spaces spaces copiesExercises: point-in-time recovery Create image copies for indexes Merge full and incremental image copies toReview exercises: point-in-time recovery Establish additional copies of image obtain new full or incremental imageGeneric utility jobs copies copiesExercises: generic utility jobs Merge full and incremental image copies Delete image copies no longer needed Review exercises: generic utility jobs to obtain new full or incremental image Recover a table space or COPY enabledExercises: using nonstandard copies copies index space to currentReview exercises: using nonstandard copies Delete image copies no longer needed An entire table space or index spaceSpecial recovery situations Recover a table space or COPY enabled A partition or data setExercises: special recovery situations index space to current An error range Review exercises: special recovery An entire table space or index space Replace defective volumes during recoverysituations A partition or data set Relate the fallback recovery conceptApplication recovery An error range Rebuild indexes

Replace defective volumes during Prepare point-in-time recoveriesGeneric utility jobs (LISTDEF, TEMPLATE, and recovery Perform point-in-time recoveries involvingOPTIONS as far as they are relevant for Relate the fallback recovery concept table spaces other than LOB table spaces backup and recovery) Rebuild indexes Use list definitions in utility controlline Prepare point-in-time recoveries statements and understand how they

Provide reusable list definitions for use by Perform point-in-time recoveries involving expandthe DB2 utilities table spaces other than LOB table Describe the concept and working of

spaces templates replacing utility DatasetUse list definitions in utility control Definition (DD) statements

line statements and understand how they Use templates in utility jobs to simplify JobExplain the basic DB2 logging concept expand Control Language (JCL)Explain the basic DB2 backup and recovery Describe the concept and working of Use templates together with list definitionsconcept templates replacing utility Dataset Use the OPTIONS utility control statementDescribe the restrictive and advisory states Definition (DD) statements to control execution parameters for utilityrelevant for backup and recovery Use templates in utility jobs to simplify jobs Explain the purpose of the Logical Page List Job Control Language (JCL) Restore DB2 DFSMS concurrent copiesand of Write Error Page Ranges Use templates together with list established using the CONCURRENTCreate conditional image copies for table definitions optionspaces Use the OPTIONS utility control Understand the prerequisites forCreate image copies for indexes statement to control execution establishing nonstandard copiesEstablish additional copies of image copies parameters for utility jobs Establish and restore nonstandard copiesMerge full and incremental image copies to Restore DB2 DFSMS concurrent copies using the DSN1COPY stand-alone utilityobtain new full or incremental image copies established using the CONCURRENT Establish and restore nonstandard copiesDelete image copies no longer needed option using native DFSMS Data Set ServicesRecover a table space or COPY enabled Understand the prerequisites for (DFSMSdss)index space to current establishing nonstandard copies Apply log changes to restored copies An entire table space or index space Establish and restore nonstandard copies Prevent the accidental dropping of tables,A partition or data set using the DSN1COPY stand-alone utility table spaces, or databasesAn error range Establish and restore nonstandard copies Recover accidentally dropped table spacesReplace defective volumes during recovery using native DFSMS Data Set Services Recover accidentally dropped tablesRelate the fallback recovery concept (DFSMSdss) Print and analyze pages of table spaces orRebuild indexes Apply log changes to restored copies partitions


Prepare point-in-time recoveries Prevent the accidental dropping of tables, Repair pages of table spaces if necessary Perform point-in-time recoveries involving table spaces, or databases Teach application programmers how totable spaces other than LOB table spaces Recover accidentally dropped table make programs restartableUse list definitions in utility control spaces Advise system programmers in cancelingstatements and understand how they Recover accidentally dropped tables threads without backout being performedexpand Print and analyze pages of table spaces Instruct system programmers how toDescribe the concept and working of or partitions postpone backout work during DB2templates replacing utility Dataset Definition Repair pages of table spaces if restarts(DD) statements necessary Cancel the postponed backout for objectsUse templates in utility jobs to simplify Job Teach application programmers how to being recovered or replaced Control Language (JCL) make programs restartable Normal backup of table and index spacesUse templates together with list definitions Advise system programmers in canceling Exercises: normal backup of table andUse the OPTIONS utility control statement threads without backout being performed index spacesto control execution parameters for utility Instruct system programmers how to Review exercises: normal backup of tablejobs postpone backout work during DB2 and index spacesRestore DB2 DFSMS concurrent copies restarts Normal recovery of table and index spacesestablished using the CONCURRENT option Cancel the postponed backout for objects Exercises: normal recovery of table andUnderstand the prerequisites for establishing being recovered or replaced index spacesnonstandard copies Normal backup of table and index spaces Review exercises: normal recovery of tableEstablish and restore nonstandard copies Exercises: normal backup of table and and index spaces using the DSN1COPY stand-alone utility index spaces Exercises: point-in-time recoveryEstablish and restore nonstandard copies Review exercises: normal backup of table Review exercises: point-in-time recoveryusing native DFSMS Data Set Services and index spaces Generic utility jobs(DFSMSdss) Normal recovery of table and index Exercises: generic utility jobsApply log changes to restored copies spaces Review exercises: generic utility jobs Prevent the accidental dropping of tables, Exercises: normal recovery of table and Exercises: using nonstandard copiestable spaces, or databases index spaces Review exercises: using nonstandardRecover accidentally dropped table spaces Review exercises: normal recovery of copiesRecover accidentally dropped tables table and index spaces Special recovery situationsPrint and analyze pages of table spaces or Exercises: point-in-time recovery Exercises: special recovery situationspartitions Review exercises: point-in-time recovery Review exercises: special recoveryRepair pages of table spaces if necessary Generic utility jobs situationsTeach application programmers how to Exercises: generic utility jobs Application recoverymake programs restartable Review exercises: generic utility jobs Advise system programmers in canceling Exercises: using nonstandard copiesthreads without backout being performed Review exercises: using nonstandard lineInstruct system programmers how to copies Explain the basic DB2 logging conceptpostpone backout work during DB2 restarts Special recovery situations Explain the basic DB2 backup andCancel the postponed backout for objects Exercises: special recovery situations recovery conceptbeing recovered or replaced Review exercises: special recovery Describe the restrictive and advisory statesNormal backup of table and index spaces situations relevant for backup and recoveryExercises: normal backup of table and index Application recovery Explain the purpose of the Logical Pagespaces List and of Write Error Page Ranges Review exercises: normal backup of table Create conditional image copies for tableand index spaces line spacesNormal recovery of table and index spaces Explain the basic DB2 logging concept Create image copies for indexesExercises: normal recovery of table and Explain the basic DB2 backup and Establish additional copies of imageindex spaces recovery concept copiesReview exercises: normal recovery of table Describe the restrictive and advisory Merge full and incremental image copies toand index spaces states relevant for backup and recovery obtain new full or incremental imageExercises: point-in-time recovery Explain the purpose of the Logical Page copiesReview exercises: point-in-time recovery List and of Write Error Page Ranges Delete image copies no longer needed Generic utility jobs Create conditional image copies for table Recover a table space or COPY enabledExercises: generic utility jobs spaces index space to currentReview exercises: generic utility jobs Create image copies for indexes An entire table space or index spaceExercises: using nonstandard copies Establish additional copies of image A partition or data setReview exercises: using nonstandard copies copies An error range Special recovery situations Merge full and incremental image copies Replace defective volumes during recoveryExercises: special recovery situations to obtain new full or incremental image Relate the fallback recovery conceptReview exercises: special recovery copies Rebuild indexes situations Delete image copies no longer needed Prepare point-in-time recoveriesApplication recovery Recover a table space or COPY enabled Perform point-in-time recoveries involving

index space to current table spaces other than LOB table spaces An entire table space or index space Use list definitions in utility controlA partition or data set statements and understand how theyAn error range expand


Replace defective volumes during Describe the concept and working ofrecovery templates replacing utility DatasetRelate the fallback recovery concept Definition (DD) statementsRebuild indexes Use templates in utility jobs to simplify JobPrepare point-in-time recoveries Control Language (JCL)Perform point-in-time recoveries involving Use templates together with list definitionstable spaces other than LOB table Use the OPTIONS utility control statementspaces to control execution parameters for utilityUse list definitions in utility control jobs statements and understand how they Restore DB2 DFSMS concurrent copiesexpand established using the CONCURRENTDescribe the concept and working of optiontemplates replacing utility Dataset Understand the prerequisites forDefinition (DD) statements establishing nonstandard copiesUse templates in utility jobs to simplify Establish and restore nonstandard copiesJob Control Language (JCL) using the DSN1COPY stand-alone utilityUse templates together with list Establish and restore nonstandard copiesdefinitions using native DFSMS Data Set ServicesUse the OPTIONS utility control (DFSMSdss)statement to control execution Apply log changes to restored copies parameters for utility jobs Prevent the accidental dropping of tables,Restore DB2 DFSMS concurrent copies table spaces, or databasesestablished using the CONCURRENT Recover accidentally dropped table spacesoption Recover accidentally dropped tablesUnderstand the prerequisites for Print and analyze pages of table spaces orestablishing nonstandard copies partitionsEstablish and restore nonstandard copies Repair pages of table spaces if necessary using the DSN1COPY stand-alone utility Teach application programmers how toEstablish and restore nonstandard copies make programs restartableusing native DFSMS Data Set Services Advise system programmers in canceling(DFSMSdss) threads without backout being performedApply log changes to restored copies Instruct system programmers how toPrevent the accidental dropping of tables, postpone backout work during DB2table spaces, or databases restartsRecover accidentally dropped table Cancel the postponed backout for objectsspaces being recovered or replaced Recover accidentally dropped tables Normal backup of table and index spacesPrint and analyze pages of table spaces Exercises: normal backup of table andor partitions index spacesRepair pages of table spaces if Review exercises: normal backup of tablenecessary and index spacesTeach application programmers how to Normal recovery of table and index spacesmake programs restartable Exercises: normal recovery of table andAdvise system programmers in canceling index spacesthreads without backout being performed Review exercises: normal recovery of tableInstruct system programmers how to and index spaces postpone backout work during DB2 Exercises: point-in-time recoveryrestarts Review exercises: point-in-time recoveryCancel the postponed backout for objects Generic utility jobsbeing recovered or replaced Exercises: generic utility jobsNormal backup of table and index spaces Review exercises: generic utility jobs Exercises: normal backup of table and Exercises: using nonstandard copiesindex spaces Review exercises: using nonstandardReview exercises: normal backup of table copiesand index spaces Special recovery situationsNormal recovery of table and index Exercises: special recovery situationsspaces Review exercises: special recoveryExercises: normal recovery of table and situationsindex spaces Application recoveryReview exercises: normal recovery oftable and index spaces Exercises: point-in-time recoveryReview exercises: point-in-time recoveryGeneric utility jobsExercises: generic utility jobsReview exercises: generic utility jobs


Exercises: using nonstandard copiesReview exercises: using nonstandardcopiesSpecial recovery situationsExercises: special recovery situationsReview exercises: special recoverysituationsApplication recovery

lineExplain the basic DB2 logging conceptExplain the basic DB2 backup andrecovery conceptDescribe the restrictive and advisorystates relevant for backup and recoveryExplain the purpose of the Logical PageList and of Write Error Page Ranges Create conditional image copies for tablespacesCreate image copies for indexesEstablish additional copies of imagecopiesMerge full and incremental image copiesto obtain new full or incremental imagecopiesDelete image copies no longer needed Recover a table space or COPY enabledindex space to currentAn entire table space or index spaceA partition or data setAn error range Replace defective volumes duringrecoveryRelate the fallback recovery conceptRebuild indexes Prepare point-in-time recoveriesPerform point-in-time recoveries involvingtable spaces other than LOB tablespaces Use list definitions in utility controlstatements and understand how theyexpandDescribe the concept and working oftemplates replacing utility DatasetDefinition (DD) statementsUse templates in utility jobs to simplifyJob Control Language (JCL)Use templates together with listdefinitionsUse the OPTIONS utility controlstatement to control executionparameters for utility jobs Restore DB2 DFSMS concurrent copiesestablished using the CONCURRENToptionUnderstand the prerequisites forestablishing nonstandard copiesEstablish and restore nonstandard copiesusing the DSN1COPY stand-alone utilityEstablish and restore nonstandard copiesusing native DFSMS Data Set Services(DFSMSdss)Apply log changes to restored copies Prevent the accidental dropping of tables,table spaces, or databases


Recover accidentally dropped tablespacesRecover accidentally dropped tablesPrint and analyze pages of table spacesor partitionsRepair pages of table spaces ifnecessary Teach application programmers how tomake programs restartableAdvise system programmers in cancelingthreads without backout being performedInstruct system programmers how topostpone backout work during DB2restartsCancel the postponed backout for objectsbeing recovered or replaced Normal backup of table and index spacesExercises: normal backup of table andindex spacesReview exercises: normal backup of tableand index spacesNormal recovery of table and indexspacesExercises: normal recovery of table andindex spacesReview exercises: normal recovery oftable and index spaces Exercises: point-in-time recoveryReview exercises: point-in-time recoveryGeneric utility jobsExercises: generic utility jobsReview exercises: generic utility jobs Exercises: using nonstandard copiesReview exercises: using nonstandardcopiesSpecial recovery situationsExercises: special recovery situationsReview exercises: special recoverysituationsApplication recovery

lineExplain the basic DB2 logging conceptExplain the basic DB2 backup andrecovery conceptDescribe the restrictive and advisorystates relevant for backup and recoveryExplain the purpose of the Logical PageList and of Write Error Page Ranges Create conditional image copies for tablespacesCreate image copies for indexesEstablish additional copies of imagecopiesMerge full and incremental image copiesto obtain new full or incremental imagecopiesDelete image copies no longer needed Recover a table space or COPY enabledindex space to currentAn entire table space or index spaceA partition or data setAn error range Replace defective volumes duringrecovery


Relate the fallback recovery conceptRebuild indexes Prepare point-in-time recoveriesPerform point-in-time recoveries involvingtable spaces other than LOB tablespaces Use list definitions in utility controlstatements and understand how theyexpandDescribe the concept and working oftemplates replacing utility DatasetDefinition (DD) statementsUse templates in utility jobs to simplifyJob Control Language (JCL)Use templates together with listdefinitionsUse the OPTIONS utility controlstatement to control executionparameters for utility jobs Restore DB2 DFSMS concurrent copiesestablished using the CONCURRENToptionUnderstand the prerequisites forestablishing nonstandard copiesEstablish and restore nonstandard copiesusing the DSN1COPY stand-alone utilityEstablish and restore nonstandard copiesusing native DFSMS Data Set Services(DFSMSdss)Apply log changes to restored copies Prevent the accidental dropping of tables,table spaces, or databasesRecover accidentally dropped tablespacesRecover accidentally dropped tablesPrint and analyze pages of table spacesor partitionsRepair pages of table spaces ifnecessary Teach application programmers how tomake programs restartableAdvise system programmers in cancelingthreads without backout being performedInstruct system programmers how topostpone backout work during DB2restartsCancel the postponed backout for objectsbeing recovered or replaced Normal backup of table and index spacesExercises: normal backup of table andindex spacesReview exercises: normal backup of tableand index spacesNormal recovery of table and indexspacesExercises: normal recovery of table andindex spacesReview exercises: normal recovery oftable and index spaces Exercises: point-in-time recoveryReview exercises: point-in-time recoveryGeneric utility jobsExercises: generic utility jobsReview exercises: generic utility jobs Exercises: using nonstandard copiesReview exercises: using nonstandard


copiesSpecial recovery situationsExercises: special recovery situationsReview exercises: special recoverysituationsApplication recovery

Daily Agenda line

Further Information:

For More information, or to book your course, please call us on 353-1-814 8200

[email protected]

www.globalknowledge.ie

Global Knowledge, 3rd Floor Jervis House, Millennium Walkway, Dublin 1

http://www.globalknowledge.ie

db2 for z/os - recovery/restart · 2015. 10. 12. · overview: learn how data and indexrecovery is...

Documents