Optional: Specify which partition you want
to reorganize
Specify a partition ID.
Optional: Specifies that DB2 can use non-empty data sets during the
REBUILD. If you have not defined VSAM data sets with the REUSE option or
do not specify this option the data sets used during REBUILD must be empty.
Specified value is compared against LEAFDIST for the specified
partitions. If any LEAFDIST exceeds the value REORG will be
performed or recommended. Not valid for LOB table
spaces.
If you specify YES, the REORG is only recommended, not
performed.
If you specify YES, the REORG is only recommended, not
performed.
Applications can read but cannot write while the utility runs.
Opens the Reference Option window.
Applications can read and usually write to the
area while the utility runs.
Opens the Change Option window.
Applications have no access while the utility runs.
After unloading the data, the utility continues processing.
After unloading the data, the utility ends and the RELOAD status is stored
in SYSIBM.SYSUTIL so that processing can be restored with the RELOAD RESTART
(PHASE) command.
After unloading the data, the utility ends and the status stored in SYSIBM.SYSUTIL
that corresponds to this utility ID is removed.
Type a name for the UNLOAD data set.
If you do not specify these values, the default, SYSREC, is used.
Type a name for the UNLOAD data set.
If you do not specify these values, the default, SYSREC, is used.
Type a name for the UNLOAD data set.
If you do not specify these values, the default, SYSREC, is used.
Type a name for the temporary work files for sort input.
If you do not specify these values, the default, SYSUT1, is used.
Type a name for the temporary work files for sort input.
If you do not specify these values, the default, SYSUT1, is used.
Type a name for the temporary work files for sort input.
If you do not specify these values, the default, SYSUT1, is used.
Type a name for the temporary work files for sort output.
If you do not specify these values, the default, SORTOUT, is used.
Type a name for the temporary work files for sort output.
If you do not specify these values, the default, SORTOUT, is used.
Type a name for the temporary work files for sort output.
If you do not specify these values, the default, SORTOUT, is used.
Type a device type for the data facility sort (DFSORT).
In the device type field, you can specify any IBM direct access storage
device or tape device supported by your operating system.
Limits the maximum number of data sets to the specified number
Type a number between 1 and 255. If you specify a value greater than
255, then 255 is used.
To optimize resource allocation, avoid specifying
a large number of work data sets unnecessarily.
Preformatting pages increases execution performance on spaces that
have high volume INSERTS by formatting the pages beforehand.
Preformatting is not recommended for indexes that have a high ratio
of reads to inserts if these reads will cause unnecessary reads of empty
pages.
Yes indicates that the DB2 catalog will be updated (unless
you specify Do not update catalog under Update options on catalog
table).
Yes indicates that the DB2 catalog will be updated (unless
you specify Do not update catalog under Update options on catalog
table).
The utility updates all the collected statistics.
The utility updates only the catalog tables used for access path selection.
The utility updates only the catalog that provide statistics to help database
administrators assess the status of a space or index.
The utility does not update the collected statistics.
Unavailable if you select the No radio button.
Specify the Collect key cardinalities check box to collect all of
the distinct values in all of the 1 to n key column combinations for the
specified indexes, where n is the number of columns in the index.
Adds a row to the Frequent values statistics options table
Removes the selected row from the Frequent values statistics options table
Number of Columns:
Indicates the number of key columns to concatenate when collecting
frequent values from the specified index. A value of '3' indicates that DB2 collect
frequent values on the concatenation of the first three key columns.
Number of frequent values:
Indicates the number of frequent values to be collected. A value of '15'
indicates that DB2 collect 15 frequent values.
Submits the data in the window and closes the window.
Displays the SQL statements that would be generated by your choices in this window.