Processes the CHECK DATA utility for the selected table spaces.

Opens a window showing the actual SQL statements that get generated.

Closes the window without checking the data in the table space.

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

Select to limit the scope of the checking. If not selected, the entire table space is checked for violations of referential and table check constraints.

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.

Required field: Type the DD name, or data definition name of the input data set used during CHECK DATA. If you do not specify a temporary work file, at least specify the default, SYSUT1

Type 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.

Required field. The DD name, or data definition name of the output data set used during CHECK DATA. If you do not specify a temporary work file, at least type the default, 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.

Optional: Type the DD name (data definition name) for an error processing data set. The default is ERRDDN SYSERR.

Type 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 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.

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.

Type the maximum number of exceptions, reported by messages only. CHECK DATA terminates 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. Available only if a table is selected.

Deletes the selected table space from the exception table list.