REBUILD (Indexes for Table Spaces) panel
You use the REBUILD (Indexes for Table Spaces) panel to generate utility control statements using the REBUILD INDEX (ALL) TABLESPACE form of REBUILD utility.
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.
Parent panels
Child panels
None.