REBUILD (Indexes for Table Spaces) panel

Panel and field definitions

  Process   Options   Utilities   Help
 ──────────────────────────────────────────────────────────────────────────────
 FM/Db2 (DFG2)         REBUILD (Indexes for Table Spaces)    Row 1 to 12 of 133


 S P                                                  Sort
 e R          Table    Part'n                WORKDDN  Device   Sort   Sort
 l C Database Space    Number Reuse WORKDDN  Template Type     Num    Keys
     DSN8D81A DSN8S81D      0   N   SYSUT1      N     SYSALLDA 4       Y
     DSN8D81A DSN8S81E      1   N   SYSUT1      N     SYSALLDA 4       Y
     DSN8D81A DSN8S81E      2   N   SYSUT1      N     SYSALLDA 4       Y
     DSN8D81A DSN8S81E      3   N   SYSUT1      N     SYSALLDA 4       Y
     DSN8D81A DSN8S81E      4   N   SYSUT1      N     SYSALLDA 4       Y
     DSN8D81A DSN8S81E      5   N   SYSUT1      N     SYSALLDA 4       Y
     DSN8D81A DSN8S81P      0   N   SYSUT1      N     SYSALLDA 4       Y
     DSN8D81A DSN8S81R      0   N   SYSUT1      N     SYSALLDA 4       Y
     DSN8D81A DSN8S81S      0   N   SYSUT1      N     SYSALLDA 4       Y
     DSN8D81E DSN8S81U      0   N   SYSUT1      N     SYSALLDA 4       Y
     DSN8D81P DSN8S81C      0   N   SYSUT1      N     SYSALLDA 4       Y
     DSN8D81P DSN8S81Q      0   N   SYSUT1      N     SYSALLDA 4       Y

 Command ===>                                                       Scroll PAGE
  F1=Help      F2=Split     F3=Exit      F7=Backward  F8=Forward   F9=Swap
 F12=Cancel

Sel

Selection column. To select a table space, type S in this column. Selected table spaces show an asterisk (*) in the PRC column.

PRC

Processing indicator. An asterisk (*) indicates the item is selected.

Database

The name of the database in which the table space is defined.

Table Space

The name of the table space.

Part'n Number

The partition number for the table space. This is 0 for a non-partitioned table space. For a partitioned table space, the number represents the partition of the table space. There is one row in the table for each partition of a partitioned table space. This is a display-only field.

Reuse

Controls whether Db2® deletes and redefines the index space data set as part of the rebuild operation:

YES

Keeps the existing data set.

NO

Deletes and redefines the index space 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.

WORKDDN 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 has 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 REBUILD utility rebuilds indexes in parallel:

YES

Builds the indexes in parallel.

NO

Does not build the indexes in parallel.

You can type a new value.