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, 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.
Select to report LOB column check errors with a warning message.
Specifies that the base table space is set to the Auxiliary CHECK pending status if reporting LOB column check errors.
Specifies that the base table LOB column is set invalid. The base table space is set to the Aux Warning status if reporting LOB column check errors.
Required field. The DD name, or data definition name of the data set. Type information to identify the temporary input work files used during CHECK DATA. If you do not specify a temporary work file, DB2 uses 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 data set. Type information to identify the temporary input work files used during CHECK DATA. If you do not specify a temporary work file, DB2 uses the default, SORTOUT
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.
The DD name, or 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.
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.
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 (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.
Indicates whether or not rows in violation of referential or table check constraints are deleted from the table space. If not checked 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. 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.
Deletes the selected table space from the exception table list.