IBM 000-8697 Manual Do Utilizador

IBM Informix OnLine Database Server Administrator’s Guide

Depending on the options you choose, tbcheck can do the following things:

■

Check specified structures for inconsistencies

■

Repair index structures found to contain inconsistencies

■

Display information about the structures

The only structures that tbcheck can repair are indexes. If tbcheck detects
inconsistencies in other structures, messages alert you to these inconsis-
tencies but tbcheck cannot resolve the problem. For more details about
OnLine consistency checking and dealing with corruption, refer to

Any user can execute the check options. Only user informix or root can
display database data or initiate index repairs. OnLine must be in quiescent
mode to repair indexes.

The display options of the tbcheck utility can be compared to the tbstat
utility, which also displays information about OnLine structures. The tbstat
utility reads the shared-memory segment and reports statistics that are
accurate for the instant during which the command executes. That is, tbstat
describes information that changes dynamically during processing, such as
buffers, locks, and users. The tbcheck utility tends to display configuration
and disk-usage information that is read directly from the disk and that
changes less frequently.

The list below associates tbcheck options with their function. Syntax is
provided on

. Some display options also perform checking. Refer to

the descriptions that begin on

 for details.

Blobspace blobs

-pB

Chunks and extents

-ce

-pe

Data rows, no blobs

-cd

-pd

Data rows, blob pages

-cD

-pD

Index (key values)

-ci

-ci -y, -pk -y

-pk

 (1 of 2)