Start of Content Area

Procedure documentation Checking Tables with Blob Fields for Data Consistency with SAPDBA  Locate the document in its SAP Library structure

Use

You can use SAPDBA to check the data consistency of all the tables with "blob" fields in your Informix database. If there is any doubt, check the entire database for consistency since other tables might also be affected. This procedure checks tables without changing them and it 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 Tables with 'Blob' Fields.
  2. Choose Continue. You can cancel the action if you want.

SAPDBA checks the tables with blob fields for data consistency. As the processing runs, you see a message like the following for each table checked:

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

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 Restarting Uncompleted Consistency Requests with SAPDBA.

Result

The tables with blob fields are 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 with SAPDBA.

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