7-44 IBM Informix OnLine Database Server Administrator’s Guide
Option Descriptions
Usethe -pD option to obtain the rowid. Refer to page 2-104 for more details
about the tblspace number. Refer topage 2-124 for more details about the
logical page number. Refer topage 2-123 for more details about the rowid.
Refer topage 2-121 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 pagepage 3-77.
tbcheck -pp stores5:customer 0x211
tbcheck 100000a 25
tbcheck -pP 3 15
-pr Option
The -pr option performs the same checks as the-cr option. In addition, -pr
displaysthe reserved-page information as it checks the reserved pages. Refer
topage 2-95 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-Monitor 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.
-pt and -pT Options
The -pt option prints a tblspace report for the specified table. The report
containsgeneral 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).