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, ZDT/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 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 RBIX1: REBUILD INDEX 000015 //* "HFMUSER"."XACT2" 000016 //********************************************************************** 000017 //RBIX1 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.SYSUT1 DD UNIT=SYSALLDA, 000021 // SPACE=(&ALLOC,(&PRI,&SEC),RLSE) 000022 //DSNUPROC.SYSIN DD * 000023 REBUILD INDEX ( 000024 "HFMUSER"."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:
- ZDT/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