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