Optional: Specify which partition you want to reorganize Specify a partition ID. 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.