Checking data in table spaces

Use this notebook to check for violations of referential and table check constraints in one or more table spaces.   You should use Check Data after a conditional restart or a point-in-time recovery on all table spaces where parent and dependent tables might not be synchronized.

Authorities. Authorities and privileges

To check data in a table space:

  1. Open the Check Data on a Table Space notebook

  2. On the Options page of the notebook, if you want to limit the scope of rows table spaces to be checked, select the Limit the scope of table spaces check box and specify whether to check data only in rows that are in CHECK PENDING status, or to check all dependent tables in the specified table spaces.

  3. Optional: On the Data Sets page of the notebook specify data set names for input and output sort data sets and for an error data set.

  4. Optional: On the Exception page of the notebook:

    1. If you want to add an exception table, click Add and use the Add Exception Table window to add an exception table.

    2. If you want to change an exception table, click Change and use the Change Exception Table window to change an exception table.

    3. If you want to delete error rows in violation of referential or table constraints, select the Delete error rows in violation of referential or table constraints check box. This check box is only available if you have exception tables. If you select to delete the rows, the output consists of deleted rows from both dependent and descendent tables.  The default is to not delete the rows.  This means that the error rows will stay in the table space. Primary errors in dependent tables are copied to exception tables.  If you do not select the check box, and constraint violations are detected, the table space is placed in the CHECK pending status.

    4. Type the maximum number of exceptions that are reported by messages only.  The CHECK DATA utility terminates in the CHECK DATA phase when it reaches the maximum number specified here. If termination does occur, the error rows are not written to the exception table.  Only records that have primary referential integrity errors or table check constraint violations are applied toward the limit. There is no limit on the number of records containing secondary errors. The default is 0, which means there is no limit to the exceptions.

  5. Click OK to process the CHECK DATA utility.

Related information

Defining the data sets information:

  1. On the Data Sets page, type the appropriate data set names.  A temporary work file for sort input and sort output is required.   The default for the temporary work file for sort input in SYSUT1.  The default for the temporary work file for sort output is SORTOUT.
  2. Type a data set name for error processing.  The default is ERRDDN SYSERR.
  3. Type a device type for temporary data sets to be dynamically allocated by DFSORT.  This can be any device type acceptable to the DYNALLOC parameter of the SORT or OPTION control statement for DFSORT.
  4. If you want to specify the number of temporary data sets to be dynamically allocated by the sort program, select the check box and then type a number of temporary data sets to be dynamically allocated. This check box is available only if you did not type a sort device type.