REBUILD utility (indexes)

To include a WORKDDN clause in the generated REBUILD statement, specify the required template name in WORKDDN template name on the second TEMPLATE Options panel.

  • If you did not specify the name of a LISTDEF on the Db2® Utilities panel:
    • If you entered information in the Database name, Table/index owner, or Table/index 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 from those displayed, type S in the Sel column. An asterisk (*) in the PRC column indicates selected indexes.
    • Sample JCL generated for REBUILD Utility (indexes) shows an example of generated JCL for rebuilding indexes.

      In this example, FM/Db2 has generated two JCL steps, one for each index selected from the displayed rows on the previous panel.

      Figure 1. Sample JCL generated for REBUILD Utility (indexes)
         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 SETPARM: OVERRIDE ANY GLOBAL DATASET SIZING VALUES HERE
       000010 //**********************************************************************
       000011 //SETPARM SET ALLOC='TRK',PRI='1',SEC='1'
       000012 //*
       000013 //**********************************************************************
       000014 //* STEP RBIX1: REBUILD INDEX
       000015 //* "FMNUSER"."XACT2"
       000016 //**********************************************************************
       000017 //RBIX1    EXEC DSNUPROC,SYSTEM=DFA2,UID='FMNUSER'
       000018 //DSNUPROC.STEPLIB  DD DSN=DB2V810.DFA2.SDSNEXIT,DISP=SHR
       000019 //         DD DSN=DB2.V810.SDSNLOAD,DISP=SHR
       000020 //DSNUPROC.SYSUT1   DD UNIT=SYSALLDA,
       000021 //         SPACE=(&ALLOC,(&PRI,&SEC),RLSE)
       000022 //DSNUPROC.SYSIN    DD *
       000023 REBUILD INDEX (
       000024 "FMNUSER"."XACT2"
       000025 )
       000026    WORKDDN(SYSUT1) SORTDEVT SYSALLDA SORTNUM 4 SORTKEYS
       000027 /*
       ****** **************************** 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 REBUILD statement.

Related tasks

Related references