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 load data into a non empty data set.

Select to gather statistics for the tables and indexes in the table space. This enables the Statistics Options, Table Statistics, and Index Statistics pages of the notebook.

Select to designate a specific partition number or a range of partition numbers to reorganize.

Use the spin button to specify a partition number, or the beginning number of a range of partitions.

Use the spin button to specify the end number of a range of partitions.

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.

Select to specify that index keys will be sorted in parallel during the SORTBLD phase to improve performance.

Select to set indicators for when to reorganize.

Type a value for OFFPOSLIMIT. If this value is exceeded, REORG will be performed or recommended. This option is not valid for LOB table spaces. The default value is 10.

Type a value for INDREFLIMIT. If this value is exceeded, REORG will be performed or recommended. This option is not valid for LOB table spaces. The default value is 10.

Select to only recommend table space reorganization when the indicators are met. REORG is not performed.

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 DD name for a dataset to receive the LOAD utility control statements generated by REORG TABLESPACE UNLOAD EXTERNAL or REORG TABLESPACE DISCARD FROM TABLE ... WHEN. The default is SYSPUNCH.

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 DD name for a discard data set, to hold copies of records that meet the DISCARD FROM TABLE ... WHEN specification. The default is SYSDISC.

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.

Specify to send a set of messages to SYSPRINT to report the collected statistics.

Specify to send NO messages reporting the collected statistics to SYSPRINT.

Specify to put all collected statistics information for this table space in the catalog.

Specify to update only the catalog table columns that provide statistics used for access path selection.

Specify to update only the catalog table columns that provide statistics to help the database administrator assess the status of a particular table space.

Specify if you do not want to update the catalog table columns. This is only valid when you have selected YES on the Report statistics radio button.

Select to specify a table or tables for which column information is to be gathered. All tables must belong to the selected table space.

Specify if you want to collect statistics on all tables in the table space.

Specify to gather statistics for all columns of particular tables in the table space

Lists the tables and the columns that will have statistics gathered.

Opens the window that adds column specifications to the table.

Opens the window that modifies column specifications in the table.

Deletes a table and column entry from the list.

Select to specify an index indexes for which column information is to be gathered.

Specify if you want to collect statistics on indexes in the table space.

Specify to gather statistics for all columns of particular indexes in the table space

Lists the indexes and the columns that will have statistics gathered.

Opens the window that adds column specifications on the index.

Opens the window that modifies column specifications in the index.

Deletes an index and column entry from the list.

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.