DB2 Utilities › DB2 Utilities Supported by CA Gen › RECOVER Utility

RECOVER Utility

DB2 allows you to recover an entire table space, a data set, pages within an error range, or a single page. If a smaller data recovery unit (a page, for example) is required, you can use the generated JCL as an example from which to build the JCL you need.

Note: CA Gen generates JCL to recover an entire table space or an index.

The DB2 RECOVER utility recovers data to the current state or to a previous state. Data is recovered from image copies of a table space and database log change records. If the most recent full image copy data set is unusable, and previous image copy data sets exist in the system, RECOVER uses the previous image copy data sets.

You can recover multiple table spaces and indexes from the same database in a single execution of the RECOVER utility. DB2 locks the entire tablespace to allow an update of secondary indexes across partition boundaries. To recover an index, specifically request that the index be recovered. It is not recovered automatically when the table space is recovered.

To select the table spaces and indexes to recover, use the DB2 recover Utility panel.

                              DB2 RECOVER Utility            Row 1 to 13 of 23 
 COMMAND ===>                                                   SCROLL ===> PAGE
                                                                                
  Model name  . . . :  GEN SAMPLE MODEL                                    
  Business system . :  CORPORATE_MANAGEMENT                                     
  Data base . . . . :  GENDB                                                    
                                                                                
  Type S beside each table space and index you wish to recover                  
  then press enter or press F12 to cancel.                                      
                                                                                
 S Table Space Index                                                            
 _ T0000131                                                                     
 _                                                                              
 _              PROJID                                                          
 _              I0000078                                                        
 _              I0000080                                                        
 _ T0000135                                                                     
 _                                                                              
 _              TEAMID                                                          
 _              I0000084                                                        
 _ T0000140                                                                     
 _                                                                              
 _              DIVID                                                           
 _ T0000144                                              

The following example of the JCL generated for the RECOVER utility bthat is ased on the selections made using the DB2 Copy Utility.

EDIT ---- DAAAXXX.TICTEMP1.TIDUTJCL ------------ COLUMNS 001 072
COMMAND ===>                                    SCROLL ===> CSR
****** ***************************** TOP OF DATA *****************************
000001 //DAAAXXX JOB(ACCOUNT INFO)
000002 //*TEST JCL SAVED
000003 //*
000004 //*
000005 //*
000006 //*
000007 //*
000008 //*
000009 //*
000010 //STEPRECV EXEC PGM=DSNUTILB,REGION=1024K,
000011 // PARM='DB2T,RD000310',COND=EVEN
000012 //*
000013 //STEPLIB DD DSN=SYS1.DB2.LINKLIB,DISP=SHR
000014 //*
000015 //SYSPRINT DD SYSOUT=*
000016 //UTPRINT DD SYSOUT=*
000017 //SYSUDUMP DD SYSOUT=*
000018 //* *****************************************************
000019 //* * WORK DATA SETS FOR SORTING INDEXES *
000020 //* *****************************************************
000021 //SORTWK01 DD DSN=DAAAXXX.DB2T.RECV.SORTWK01,
000022 // DISP=(NEW,DELETE,CATLG),UNIT=SPACE,
000023 // SPACE=(TRK,(75,25))
000024 //SORTWK02 DD DSN=DAAAXXX.DB2T.RECV.SORTWK02,
000025 // DISP=(NEW,DELETE,CATLG),UNIT=SPACE,
000026 // SPACE=(TRK,(75,25))
000027 //SORTWK03 DD DSN=DAAAXXX.DB2T.RECV.SORTWK03,
000028 // DISP=(NEW,DELETE,CATLG),UNIT=SPACE,
000029 // SPACE=(TRK,(75,25))
000030 //SORTWK04 DD DSN=DAAAXXX.DB2T.RECV.SORTWK04,
000031 // DISP=(NEW,DELETE,CATLG),UNIT=SPACE,
000032 // SPACE=(TRK,(75,25))
000033 //* *****************************************************
000034 //* * MESSAGES FROM DFSORT *
000035 //* *****************************************************
000036 //UTPRINT DD SYSOUT=*
000037 //* *****************************************************
000038 //* * WORK DATA SETS FOR INTERMEDIATE OUTPUT *
000039 //* *****************************************************
000040 //SYSUT1 DD DSN=DAAAXXX.DB2T.RECV.SYSUT1,
000041 // DISP=(NEW,DELETE,CATLG),UNIT=SPACE,
000042 // SPACE=(CYL,(75,25))
000043 //SYSIN DD *
000044 RECOVER TABLESPACE GENEDB.T00001316
000045 RECOVER INDEX (PROJID)
000046 RECOVER INDEX (I0000078)
000047 000048 RECOVER INDEX (I0000080)
000049 /*
000050 //
****** **************************** BOTTOM OF DATA **************************