REORG (indexes)

This option corresponds to the REORG INDEX 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, 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 REORG Utility (indexes) shows an example of generated JCL for reorganizing indexes.
      Figure 1. Sample JCL generated for REORG 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 RORG1: REORG INDEX
 000015 //* "BUDGER2"."PLAN_TABLE_HINT_IX"
 000016 //**********************************************************************
 000017 //RORG1    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.SYSREC   DD UNIT=SYSALLDA,
 000021 //         SPACE=(&ALLOC,(&PRI,&SEC),RLSE)
 000022 //DSNUPROC.SYSUT1   DD UNIT=SYSALLDA,
 000023 //         SPACE=(&ALLOC,(&PRI,&SEC),RLSE)
 000024 //DSNUPROC.SORTOUT  DD UNIT=SYSALLDA,
 000025 //         SPACE=(&ALLOC,(&PRI,&SEC),RLSE)
 000026 //DSNUPROC.SYSIN    DD *
 000027 REORG INDEX
 000028 "BUDGER2"."PLAN_TABLE_HINT_IX"
 000029 /*
 ****** **************************** 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 REORG (indexes) panel showing the specified LISTDEF and a number of editable fields that correspond to keywords in the REORG statement.
    • Sample JCL generated for REORG Utility (indexes) 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 REORG Utility (indexes) 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 SETPARM: OVERRIDE ANY GLOBAL DATASET SIZING VALUES HERE
 000010 //**********************************************************************
 000011 //SETPARM SET ALLOC='TRK',PRI='1',SEC='1'
 000012 //*
 000013 //**********************************************************************
 000014 //* STEP RORG1: REORG INDEX LIST LDEF1
 000015 //**********************************************************************
 000016 //RORG1    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.SYSREC   DD UNIT=SYSALLDA,
 000020 //         SPACE=(&ALLOC,(&PRI,&SEC),RLSE)
 000021 //DSNUPROC.SYSUT1   DD UNIT=SYSALLDA,
 000022 //         SPACE=(&ALLOC,(&PRI,&SEC),RLSE)
 000023 //DSNUPROC.SORTOUT  DD UNIT=SYSALLDA,
 000024 //         SPACE=(&ALLOC,(&PRI,&SEC),RLSE)
 000025 //DSNUPROC.SYSIN    DD *
 000026 REORG INDEX LIST LDEF1
 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

Related tasks

Related references