Displays the selected indexes in a table.
Specify a Data set name, a Device , and a Space in the
Temporary work data set fields.
DB2 uses the information that you type in this field to identify the
temporary work files used during REBUILD INDEX. If you do not specify a
temporary work file, the DB2 uses the default, SYSUT1.
Specify a Data set name, a Device , and a Space in the
Temporary work data set fields.
DB2 uses the information that you type in this field to identify the
temporary work files used during REBUILD INDEX. If you do not specify a
temporary work file, the DB2 uses the default, SYSUT1.
Specify a Data set name, a Device , and a Space in the
Temporary work data set fields.
DB2 uses the information that you type in this field to identify the
temporary work files used during REBUILD INDEX. If you do not specify a
temporary work file, the DB2 uses the default, SYSUT1.
Type a device type for the data facility sort (DFSORT).
DFSORT is a non-DB2 utility used to sort, merge, and copy information.
In the device type field, you can specify any IBM direct access storage
device or tape device supported by your operating system.
Type a number between 1 and 255.
Tip:To optimize resource allocation, avoid specifying
a large number of work data sets unnecessarily.
Select the Number of DFSORT temporary datasets check box if you
want to specify the maximum number of data sets. If you select the check
box, type a number in the associated text field.
If you do not select this check box, DFSORT uses a default maximum number of datasets.
Optional: Select sort the keys in parallel unless constrained by storage or memory
limitations. Sorting the keys in parallel will improve performance. The
greatest improvement in elapsed time occur when parallel sorting is applied
to:
Multiple indexes on a simple, segmented, or partitioned table space
The partitioning index on all partitions of a partitioned table space
The nonpartitioning index on a partitioned table space.
Optional: Select the Logically reuse and reset data sets check box.
This setting 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.
Indicates that the DB2 catalog will be updated (unless
you specify Do not update catalog).
Indicates that the statistics in the DB2 catalog will not be updated.
Unavailable if you select Do not update catalog
The utility updates all the 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.
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.