REBUILD Utility (Indexes) panel

Panel and field definitions

  Process   Options   Utilities   Help
 ──────────────────────────────────────────────────────────────────────────────
 FM/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.