RECOVER (index spaces)

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

  • If you did not specify the name of a LISTDEF on the Db2® Utilities panel:
    • 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 an index space from those displayed, type S in the Sel column. An asterisk (*) in the PRC column indicates selected index spaces.
    • Sample JCL generated for RECOVER Utility (index spaces) shows an example of generated JCL for recovering index spaces.
      Figure 1. Sample JCL generated for RECOVER Utility (index 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 INDEXSPACE JLV3D81A.XDEPT2
       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 INDEXSPACE JLV3D81A.XDEPT2    TOCOPY
       000016   SHRIKES.JLV3D81A.XDEPT2.F00000.D2541023 TOVOLUME CATALOG
       000017 /*
       ****** **************************** 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 RECOVER Utility (Index Spaces) panel showing the specified LISTDEF and a number of editable fields that correspond to keywords in the RECOVER statement.

Related tasks

Related references