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 HFMUSER.SPFTEMP1.CNTL Columns 00001 00072 ****** ***************************** Top of Data ****************************** 000001 //HFMUSERB JOB (IBMGSA), 000002 // HFMUSER,MSGCLASS=A, 000003 // NOTIFY=HFMUSER,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='HFMUSER' 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:
- ZDT/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 HFMUSER.SPFTEMP1.CNTL Columns 00001 00072 ****** ***************************** Top of Data ****************************** 000001 //HFMUSERB JOB (IBMGSA), 000002 // HFMUSER,MSGCLASS=A, 000003 // NOTIFY=HFMUSER,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='HFMUSER' 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