RECOVER (table spaces)

This option corresponds to the RECOVER TABLE SPACE form of the RECOVER utility control statement.

  • If you did not specify the name of a LISTDEF on the Db2® Utilities panel:
    • The information displayed in the RECOVER Utility (Table Spaces) panel includes one row for every matching entry found in the SYSCOPY catalog table. The match is performed on database name and table space name, and the type (Typ) of the entry must be either F (Full image copy) or I (Partial image copy). Only cataloged image copy data sets are supported. This means that there can be 0, 1, or many entries for any table space name.
    • If you entered information in the Database name or Table/index space name filter fields on the Db2® Utilities panel, the displayed rows are limited to the Db2® objects that match the information you specified.
    • To select a table space from those displayed, type S in the Sel column. An asterisk (*) in the PRC column indicates selected table spaces.
    • Sample JCL generated for RECOVER Utility (table spaces) shows an example of generated JCL for recovering table spaces.
      Figure 1. Sample JCL generated for RECOVER Utility (table spaces)
         File  Edit  Edit_Settings  Menu  Utilities  Compilers  Test  Help
────────────────────────────────────────────────────────────────────────────────
 EDIT       FMNUSER.SPFTEMP1.CNTL                           Columns 00001 00072
 ****** ***************************** Top of Data ******************************
 000001 //FMNUSERB JOB (IBMGSA),
 000002 //             FMNUSER,MSGCLASS=A,
 000003 //             NOTIFY=FMNUSER,CLASS=A,
 000004 //             MSGLEVEL=(1,1)
 000005 //*
 000006 //         JCLLIB ORDER=(DB2V810.DFA2.PROCLIB)
 000007 //*
 000008 //**********************************************************************
 000009 //* STEP RECV1: RECOVER TABLESPACE DSNDB01.SCT02
 000010 //**********************************************************************
 000011 //RECV1    EXEC DSNUPROC,SYSTEM=DFA2,UID='FMNUSER'
 000012 //DSNUPROC.STEPLIB  DD DSN=DB2V810.DFA2.SDSNEXIT,DISP=SHR
 000013 //         DD DSN=DB2.V810.SDSNLOAD,DISP=SHR
 000014 //DSNUPROC.SYSIN    DD *
 000015 RECOVER TABLESPACE DSNDB01.SCT02    TOCOPY
 000016   DFA2.IMAGCOPY.SCT02 TOVOLUME CATALOG
 000017 REBUILD INDEX (ALL) TABLESPACE DSNDB01.SCT02
 000018   SORTNUM 4 SORTDEVT SYSALLDA
 000019 /*
 ****** **************************** Bottom of Data ****************************

 Command ===>                                                  Scroll ===> PAGE
  F1=Help      F2=Split     F3=Exit      F5=Rfind     F6=Rchange   F7=Up
  F8=Down      F9=Swap     F10=Left     F11=Right    F12=Cancel
  • If you did specify the name of a LISTDEF on the Db2® Utilities panel:
    • FM/Db2 displays an alternative form of the REBUILD Utility (Indexes) panel showing the specified LISTDEF and a number of editable fields that correspond to keywords in the RECOVER statement.
    • Sample JCL generated for RECOVER Utility (table spaces) with LISTDEF specified shows an example of generated JCL for recovering table spaces where a LISTDEF has been specified.
      Figure 2. Sample JCL generated for RECOVER Utility (table spaces) with LISTDEF specified
         File  Edit  Edit_Settings  Menu  Utilities  Compilers  Test  Help
────────────────────────────────────────────────────────────────────────────────
 EDIT       FMNUSER.SPFTEMP1.CNTL                           Columns 00001 00072
 ****** ***************************** Top of Data ******************************
 000001 //FMNUSERB JOB (IBMGSA),
 000002 //             FMNUSER,MSGCLASS=A,
 000003 //             NOTIFY=FMNUSER,CLASS=A,
 000004 //             MSGLEVEL=(1,1)
 000005 //*
 000006 //         JCLLIB ORDER=(DB2V810.DFA2.PROCLIB)
 000007 //*
 000008 //**********************************************************************
 000009 //* STEP RECV1: RECOVER TABLESPACE LIST LDEFNAME1
 000010 //**********************************************************************
 000011 //RECV1    EXEC DSNUPROC,SYSTEM=DFA2,UID='FMNUSER'
 000012 //DSNUPROC.STEPLIB  DD DSN=DB2V810.DFA2.SDSNEXIT,DISP=SHR
 000013 //         DD DSN=DB2.V810.SDSNLOAD,DISP=SHR
 000014 //DSNUPROC.SYSIN    DD *
 000015 RECOVER LIST LDEFNAME1
 000016 /*
 ****** **************************** Bottom of Data ****************************

 Command ===>                                                  Scroll ===> PAGE
  F1=Help      F2=Split     F3=Exit      F5=Rfind     F6=Rchange   F7=Up
  F8=Down      F9=Swap     F10=Left     F11=Right    F12=Cancel

Related tasks

Related references