Shows a list of table spaces that you want to submit for checking.

Specifies that only rows of data in the table space that are in check-pending status are checked. The referential integrity, constraint, and LOB checks are all performed. This is the default.

Specifies that only the LOB column check is performed for table spaces that have tables with LOB columns. The referential integrity and constraint checks are not performed.

Specifies that the check is on all dependent tables in the table spaces. The referential integrity, constraint, and LOB checks are performed.

Specifies that the check is on all dependent tables in the table spaces. The referential integrity and constraint checks are performed. The LOB column check is not performed.

Specifies that the base table space is set to the Auxiliary CHECK pending status if LOB column check errors are reported.

Specifies that the base table LOB column is set invalid. The base table space is set to the Aux Warning status if LOB column check errors are reported.

Type the data set name of the data set. Type information to identify the temporary input work files used during CHECK DATA. SYSUT1 is the data definition (DD) name associated with this data set name.

Type the data set name of the data set. Type information to identify the temporary input work files used during CHECK DATA. SORTOUT is the data definition (DD) name associated with this data set name.

Optional: Type the data set name for an error processing data set. ERRDDN SYSERR 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.

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: Specifies the 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 DD statements that the sort program requires for the temporary data sets.

Select to define a number of DFSORT temporary data sets.

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

Shows a list of source tables (the tables from which rows are to be copied) and exception tables (the tables into which error rows are to be copied). Any row in violation of referential or table check constraints is copied to an exception table.

Select to specify that rows in violation of referential or table check constraints be deleted from the table space. If not selected error rows remain in the table space. This is the default.

Select to specify whether to also delete the log records.

Specifies that the log records are deleted along with the error rows.

Specifies that the log records are not deleted.

Type the maximum number of exceptions, reported by messages only. DB2 stops checking data when it reaches the number of exceptions specified, and the error rows are not written to the EXCEPTION table. There is no limit on the number of records containing secondary errors. The default is 0, which is no limit on the number of exceptions.

Opens a window so that you can add a source table from which rows are to be copied and a target table into which error rows are to be copied.

Opens a window so that you can modify a source table from which rows are to be copied and a target table into which error rows are to be copied.

Deletes the selected table space from the exception table list.

Processes the CHECK DATA utility for the selected table spaces.

Displays the SQL statements that are generated by your choices in this notebook.

Cancels any unsaved changes and closes the notebook or window.