REBUILD utility (indexes for table spaces)

  • 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 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 REBUILD Utility (indexes for table spaces) shows an example of generated JCL for rebuilding indexes for table spaces.
      Figure 1. Sample JCL generated for REBUILD Utility (indexes for 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 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 ALL FOR DSN8D81A.DSN8S81D
 000015 //**********************************************************************
 000016 //RBIX1    EXEC DSNUPROC,SYSTEM=DFA2,UID='FMNUSER'
 000017 //DSNUPROC.STEPLIB  DD DSN=DB2V810.DFA2.SDSNEXIT,DISP=SHR
 000018 //         DD DSN=DB2.V810.SDSNLOAD,DISP=SHR
 000019 //DSNUPROC.SYSUT1   DD UNIT=SYSALLDA,
 000020 //         SPACE=(&ALLOC,(&PRI,&SEC),RLSE)
 000021 //DSNUPROC.SYSIN    DD *
 000022 REBUILD INDEX (ALL) TABLESPACE DSN8D81A.DSN8S81D
 000023    WORKDDN(SYSUT1) SORTDEVT SYSALLDA SORTNUM 4 SORTKEYS
 000024 /*
 ****** **************************** 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 (Indexes for Table Spaces) panel showing the specified LISTDEF and a number of editable fields that correspond to keywords in the REBUILD statement.

Related tasks

Related references