IBM 000-8697 ユーザーズマニュアル

IBM Informix OnLine Database Server Administrator’s Guide

OnLine 5 contains a page-level layer of checks that can detect data inconsis-
tencies that might be caused by hardware or operating system errors or by
unknown problems associated with OnLine operation. Associated with this
consistency checking are four environment variables that, if set, collect
diagnostic information that can be useful for

IBM I

nformix technical support

staff. (Descriptions of the four environment variables start on

To gain the maximum benefit from consistency checking and to ensure the
integrity of archives, periodically verify that all data and OnLine control
information is consistent. Because of the time needed for this check and the
possible contentions that the checks cause, schedule this check for times
when activity is at its lowest. Informix recommends that you perform this
check just prior to creating a level-0 archive.

The commands you should run as part of the check are listed here and
described in the paragraphs that follow:

■

■

■

■

■

You can run each of these commands while OnLine is in online mode. The
tbcheck

commands that include a database lock each table in the database for

the duration of the check. The tbcheck -cI and -cD commands lock each table
as the table is checked, denying access to all other database server processes.