Start of Content Area

Procedure documentation Checking a Single Table for Data Consistency with SAPDBA  Locate the document in its SAP Library structure

Use

You can use SAPDBA to check the data consistency of a single table of your Informix database. If there is any doubt, check the entire database for consistency since other tables might also be affected. This procedure checks the table by reading it and does not require storage space.

To find out which kind of check to do and how often, see How to Run Data Consistency Checks with SAPDBA.

Prerequisites

Procedure

  1. Choose Data Consistency → Check Single Table.
  2. Enter the name of the table that you want to check. If you are not sure which name you require, you can use a partial entry (for example, d01* ).
  3. Choose Continue. You can cancel the action if you want.

SAPDBA checks the table for data consistency. As the processing runs, you see a message like the following:

A014:
Checking table ‘a014’ (1/1)

Unloading to ‘/dev/null’... (32 rows)

Note

You can stop the check before it has finished by twice simultaneously pressing the keys Ctrl C . This is useful if you have run out of time, for example, or the performance on your system is poor. You can then restart the action by choosing the same action again. However, you must use exactly the same parameters as the first time. Refer to Restart Uncompleted Consistency Requests

Result

The table is now checked for data consistency.

SAPDBA displays a message like the following when the check has successfully completed:

‘Consistency Check’ of selected tables detected no problems!!

SAPDBA displays an error message like the following when there are problems:

Unload to ‘/dev/null’ of one or more tables failed!!

Please check the log carefully.

For more information about how to find and check the log and output file from the check, see Log for Data Consistency.

Note

You need to periodically clear up the $INFORMIXDIR/sapreorg (UNIX) or %INFORMIXDIR%\sapreorg (NT) directory in which SAPDBA creates working directories and files. Refer to SAPDBA Housekeeping.

 

See also:

Informix documentation