IBM 000-8697 User Manual

IBM Informix OnLine Database Server Administrator’s Guide

Execute tbcheck -cI for each database to validate indexes on each of the tables
in the database. This command locks each table as the table is checked,
denying access to all other database server processes. If this command detects
errors, drop and re-create the affected index.

Execute tbcheck -cD to validate the pages for each of the tables in the
database. This command locks each table as the table is checked, denying
access to all other database server processes. If this command detects errors,
try to unload the data from the specified table, drop the table, re-create the
table, and reload the data. If this does not succeed, perform a data restore
from archive.

After you perform the checks just described and you validate OnLine, create
a level-0 archive. Retain this archive and all subsequent logical log backup
tapes until you complete the next consistency check. Informix recommends
that you perform the consistency checks before every level-0 archive.
However, if you do not, at least keep all the tapes necessary to recover from
the archive that was created immediately after OnLine was verified to be
consistent.

If the consistency-checking code detects an inconsistency during OnLine
operation, messages are sent to the OnLine message log (specified as

MSGPATH

 in the configuration file; default value is $

).

Many of the messages sent to the OnLine message log take the following
form:

Fail Consistency Check -- problem text pid=process# user=user#
us=address