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 and constraint check are both performed. This is the default.

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

Type the data set name of the input data set used during CHECK DATA. If you do not specify a temporary work file, at least specify the data definition (DD) name. SYSUT1 is the data definition (DD) name that is associated with this data set name.

Type the data set name of the output data set used during CHECK DATA. If you do not specify a temporary work file, at least specify the data definition (DD) name. SORTOUT is the data definition (DD) name that is 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. Available only if the Number of DFSORT check box is selected.

Shows the list of source (the table from which rows are to be copied) and exception (the table into which error rows are to be copied) tables. 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 are deleted from the table space. If not selected error rows remain in the table space. This is the default.

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. Available only if a table is selected.

Deletes the selected table space from the exception table list.

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.

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.