REBUILD Utility (Indexes) panel
You use the REBUILD Utility (Indexes) panel to generate utility control statements using the REBUILD INDEX (index_name) form of the REBUILD utility.
Panel and field definitions
Process Options Utilities Help
──────────────────────────────────────────────────────────────────────────────
ZDT/Db2 (DFG2) REBUILD Utility (Indexes) Row 1 to 1 of 1
P Sort
R LISTDEF WORKDDN Device Sort Sort
Cmd C Name Reuse WORKDDN Template Type Num Keys
LDEFNAME1 N SYSUT1 N SYSALLDA 4 Y
******************************* Bottom of data ********************************
Command ===> Scroll PAGE
F1=Help F2=Split F3=Exit F4=Expand F7=Backward F8=Forward
F9=Swap F10=Left F11=Right F12=Cancel
- Cmd
- Selection column. To select an index, type S in this column. Selected indexes show an asterisk (*) in the PRC column.
- PRC
- Processing indicator. An asterisk (*) indicates the item is selected.
- Index Owner
- The name of the owner of the index.
- Index Name
- The name of the index.
- Part'n Number
- The partition number for the index. This is 0 for a non-partitioned index. For a partitioned index, the number represents the partition of the index. There is one row in the table for each partition of a partitioned index. This is a display-only field.
- Reuse
- Controls whether Db2® deletes
and redefines the index data set as part of the rebuild operation:
- YES
- Keeps the existing data set.
- NO
- Deletes and redefines the index data set.
- WORKDDN
- The ddname for the optional temporary work file used by the utility job. The value displayed is either SYSUT1, or another value if you have changed the default ddname. You can type a new value.
- WORK DDN Template
- Indicates whether the value of the associated WORKDDN field is a template name.
- Sort Device Type
- The device type used by the utility to allocate sort data sets. The value displayed is either SYSALLDA, or another value if you have changed the default device type. You can type a new value.
- Sort Num
- The number of sort data sets used by the utility. The value displayed is either 4, or another value if you have changed the default setting. You can type a new value.
- Sort Keys
- Controls whether the utility rebuilds indexes in parallel:
- YES
- Builds the indexes in parallel.
- NO
- Does not build the indexes in parallel.
Parent panels
Child panels
None.