Displays the selected indexes. This table displays the index name, the index space, partition information, the associated table name, the index type, and the indexes buffer pool.

DB2 uses the information that you type in these fields to identify the temporary work files used during CHECK INDEX. SYSUT1 is the data definition (DD) name associated with this data set name.

Specify a direct-access storage device type in which you are authorized to allocate space. Assign frequently accessed objects to fast devices and seldom-used objects to slower devices. You can also specify a tape device.

Allocate space compatible for your device. If your device is DASD the space allocation is in cylinders. If your device type is tape, you can leave this blank.

Optional: Specify a device type for temporary data sets to be dynamically allocated by DFSORT. It can be any device type acceptable to the DYNALLOC parameter of the SORT or OPTION control statement for DFSORT. For example, if you do not specify a device type in this field and a sort is required, you must provide the data definition (DD) statements that the sort program requires for the temporary data sets.

Type a number between 1 and 255. To optimize resource allocation, avoid specifying a large number unnecessarily.

Select to specify the maximum number of data sets. If you do not select this check box, DFSORT uses a default maximum number of data sets.

Submits the data in the window and closes the window.

Displays the SQL statements that are generated by your choices in this notebook.

Cancels any unsaved changes and closes the notebook or window.