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.
Specify a partition number.
Select to unload data using a sequential scan. If not specified, REORG uses the clustering index to unload the data.
Select the output of sorting (if there is a clustering index and SORTDATA is specified) as the input to reloading, without using an unload data set.
Select to pass index keys to sort in memory rather than to work files. Improves performance.
Specifies to unload data from the area being reorganized and then allows read/write access again only after the reorganization is complete.
Specifies to allow applications to read data in a table space during reorganization, but disallows changes.
Specifies to allow 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.
Specifies to include 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.
Specifies that 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.
Specifies that after the data has been unloaded, the reorganization ends.
Specifies that 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 data set name of the unload data set (UNLDDN). SYSREC is the data definition (DD) name that is associated with this data set name. The unload data set must be large enough to contain all the unloaded records from all the tables in the target table space.
Type the data set name of the output data set (COPYDDN) to contain the image copies.
Type the data set name of the output data set (COPYDDN) to contain the image copies.
Type the data set name of the output data set (RECOVERYDDN) to contain the image copies.
Type the data set name of the output data set (RECOVERYDDN) to contain the image copies.
Type the data set 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. 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.
Type the data set name for a dataset to receive the LOAD utility control statements generated by REORG TABLESPACE UNLOAD EXTERNAL or REORG TABLESPACE DISCARD FROM TABLE ... WHEN. SYSPUNCH is the data definition (DD) name that is associated with this data set name.
Type the data set name for a discard data set, to hold copies of records that meet the DISCARD FROM TABLE ... WHEN specification. SYSDISC 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.
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.
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.
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.
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.
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.
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.
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.
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 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.
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.
Select to specify no padding of the variable-length columns.
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 in the list of tables found on this page.
Opens the window to modify conditions for what rows to unload. The results appear in the WHEN clause column in the list of tables found on this page.
Deletes a row from the list of tables.
Select to confirm that you want to delete records from the tables in the list.
Select to specify no padding of the variable-length columns.
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 in the list of tables found on this page.
Opens the window to modify conditions for what rows to delete. The results appear in the WHEN clause column in the list of tables found on this page.
Deletes a row from the list of tables.
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.