IBM 000-8697 User Manual

IBM Informix OnLine Database Server Administrator’s Guide

Use the -pD option to obtain the rowid. Refer to

for more details

about the tblspace number. Refer to

 for more details about the

logical page number. Refer to

 for more details about the rowid.

Refer to

 for more details about the slot table.

The -pP option provides the same information as the -pp option but requires
a chunk number and logical page number as input. For more details about
how to use this output to monitor disk pages, refer to page

.

tbcheck -pp stores5:customer 0x211
tbcheck 100000a 25
tbcheck -pP 3 15

The -pr option performs the same checks as the -cr option. In addition, -pr
displays the reserved-page information as it checks the reserved pages. Refer
to

 for a complete listing of the root dbspace reserved pages.

tbcheck -pr

If you have changed the value of a configuration parameter (either through

DB-M

onitor or by editing the configuration file) and you have not yet reini-

tialized shared memory, tbcheck -cr detects the inconsistency, prints both
values, and displays an error message.

The -pt option prints a tblspace report for the specified table. The report
contains general allocation information including the maximum row size, the
number of keys, the number of extents and their sizes, pages allocated and
used per extent, the current serial value, and the date the table was created.
If a table is not specified, this information is displayed for all tables in the
database.

The -pT option prints the same information as the -pt option. In addition, the
-pT

 option displays index-specific information and page-allocation infor-

mation by page type (for dbspaces).