Specify which partition you want to reorganize.

Specify a partition ID.

Applications can read but cannot write while the utility runs.

Applications can read but can not write to the original copy while the utility runs.

Opens the Reference Option window.

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. SYSUT1 is the data definition (DD) name that is associated with this data set name.

Type the data set name of the temporary work file for sort output. DB2 requires a work data set for sort output, unless you specify SORTKEYS. SORTOUT is the data definition (DD) name that is 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.

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.

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.

Specify the device type for temporary data sets to be dynamically allocated by DFSORT.

Type an integer to represent the number of temporary data sets.

Select to specify the number of temporary data sets to be dynamically allocated by the sort program.

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.

Submits the data in the window and closes the window.

Displays the SQL statements that would be generated by your choices in this window.

Cancels the rebuild and closes this window.