7-40 IBM Informix OnLine Database Server Administrator’s Guide
Option Descriptions
To check the tables,tbcheck compares each system catalog table to it corre-
sponding entry in the tblspace tblspace. The data in the tables are also
checked for consistency. Refer topage 2-104 for more details about the
tblspace tblspace. (The-pc option performs the same checks and also
displays the system catalog information as it checks it, including extent use
for each table.)
tbcheck -cc
tbcheck -cc stores5
-cd and -cD Options
The -cd option reads all non-blob pages from the tblspace for the specified
table and checks each page for consistency. The bit-map page is checked to
verify mapping. If a table is not specified, all tables in the database are
checked. (The-pd option displays a hexadecimal dump of specified pages
but does not check for consistency.)
The -cD option performs the same checks as-cd but includes dbspace blob
pages if any exist. To monitor blobspace blobpages, refer totbcheck -pB.
tbcheck -cD stores5:catalog
-ce Option
The-ce option checks each chunk free list and corresponding free space and
each tblspace extent. The tbcheck process verifies that the extents on disk
correspond to the current control information describing them. Refer to
page 2-103 for moredetails about the chunk free-list page. Refer to page 2-114
for a definition of an extent, and topage 2-117 for more details about extent
allocation. (The-pe option performs the same checks and also displays the
chunk and tblspace extent information as it checks it.)
tbcheck -ce
-ci and -cI Options
The -ci option checks the key values for all indexes on the specified table.
(Referto page 2-133 for more details about index key values and the structure
of an index page.) If a table is not specified, all tables in the database are
checked.