Select to have records logged during the reload phase of reorganization. If the records are not logged, the table space is recoverable only after an image copy has been taken.
Select to choose a particular partition to reorganize.
Use the spin button to specify a partition number.
Specify to unload data using a sequential scan. If not specified, REORG uses the clustering index to unload the data.
The output of sorting (if there is a clustering index and SORTDATA is specified) is the input to reloading, without using an unload data set.
Pass index keys to sort in memory rather than to work files. Improved performance.
Unloads data from the area being reorganized and then allows read/write access again only after the reorganization is complete.
Allows applications to read data in a table space during reorganization, but does not allow changes.
Allows applications to read and write data in a table space during reorganization.
Opens the Reference options window.
Opens the Change options window.
Select to keep the current compression dictionary, assuming a compression dictionary already exists.
Select to keep the current compression dictionary, assuming a compression dictionary already exists.
Includes the reload phase of the reorganize utility. If an error occurs after unloading, you can recover the page starting from the point of failure in the recovery log.
After the data has been unloaded, processing ends and RELOAD status is stored in SYSIBM.SYSUTIL so that processing can be restarted with RELOAD RESTART(PHASE). Useful if you want to redefine data sets during reorganization
After the data has been unloaded, the reorganization ends.
After the data has been unloaded, the reorganization ends. Rows are decompressed, edit routines decoded, field procedures decoded, and SMALLINT, INTEGER, FLOAT, DECIMAL, DATE, TIME, and TIMESTAMP columns are converted to external format.
Type the DD name of the unload data set (UNLDDN). The default is SYSREC. The unload data set must be large enough to contain all the unloaded records from all the tables in the target table space.
Specify a device type. The device must be a direct-access storage device, and you must be authorized to allocate space on that device. Assign frequently accessed objects to fast devices and seldom-used objects to slower devices.
Allocate space compatible for your device.
Output data set (COPYDDN) to contain the image copies.
Specify a device type. The device must be a direct-access storage device, and you must be authorized to allocate space on that device. Assign frequently accessed objects to fast devices and seldom-used objects to slower devices.
Allocate space compatible for your device.
Output data set (COPYDDN) to contain the image copies.
Specify a device type. The device must be a direct-access storage device, and you must be authorized to allocate space on that device. Assign frequently accessed objects to fast devices and seldom-used objects to slower devices.
Allocate space compatible for your device.
Output data set (RECOVERYDDN) to contain the image copies.
Specify a device type. The device must be a direct-access storage device, and you must be authorized to allocate space on that device. Assign frequently accessed objects to fast devices and seldom-used objects to slower devices.
Allocate space compatible for your device.
Output data set (RECOVERYDDN) to contain the image copies.
Specify a device type. The device must be a direct-access storage device, and you must be authorized to allocate space on that device. Assign frequently accessed objects to fast devices and seldom-used objects to slower devices.
Allocate space compatible for your device.
Type the DD name for a temporary work file for sort input. Used for intermediate output (WORKDDN). DB2 requires a work data set for sort input for tables with indexes, unless you specify SORTKEYS. The default is SYSUT1.
Specify a device type. The device must be a direct-access storage device, and you must be authorized to allocate space on that device. Assign frequently accessed objects to fast devices and seldom-used objects to slower devices.
Allocate space compatible for your device.
Type the DD name of the temporary work file for sort output. DB2 requires a work data set for sort output, unless you specify SORTKEYS. The default is SORTOUT.
Specify a device type. The device must be a direct-access storage device, and you must be authorized to allocate space on that device. Assign frequently accessed objects to fast devices and seldom-used objects to slower devices.
Allocate space compatible for your device.
Specify the device type for temporary data sets to be dynamically allocated by DFSORT.
Select to specify the number of temporary data sets to be dynamically allocated by the sort program.
Type an integer to represent the number of temporary data sets.
Select to specify that the remaining pages are preformatted up to the high allocated RBA in the table space. The preformatting occurs after the data has been loaded and the indexes are built.
Displays a list of tables from which data is unloaded in a format that is acceptable to the LOAD utility of any DB2 subsystem.
Opens the window to define conditions for what rows to unload. The results appear in the WHEN clause column of this Reorganize Table space window.
Opens the window to modify conditions for what rows to unload. The results appear in the WHEN clause column of this Reorganize Table space window.
Deletes a row from the list of tables.
Select to confirm that you want to delete records from the tables in the list.
Displays a list of tables with rows that will be deleted that matched a WHEN clause.
Opens the window to define conditions for what rows to delete. The results appear in the WHEN clause column of this Reorganize Table space window.
Opens the window to modify conditions for what rows to delete. The results appear in the WHEN clause column of this Reorganize Table space window.
Deletes a row from the list of tables.
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 process and closes this window.