IBM 000-8697 User Manual

IBM Informix OnLine Database Server Administrator’s Guide

The -pB option displays statistics that describe the average fullness of
blobspace blobpages in a specified table. These statistics provide a measure
of storage efficiency for individual blobs in a database or table. If a table is not
specified, statistics are displayed for the database. Refer to

for more

details about interpreting tbcheck -pB output.

tbcheck -pB stores5:catalog

The -pc option performs the same checks as the -cc option. In addition, -pc
displays the system catalog information as it checks it, including extent use
for each table. Refer to the -cc discussion on

.

tbcheck -pc

The -pd option can take a database, a table, and a specific rowid or logical
page number as input. In every case, -pd prints page header information and
displays the specified rows in hexadecimal and

ASCII

 format. No checks for

consistency are performed. If you specify a rowid (expressed as a
hexadecimal value), the page number contained in the rowid is printed.
(Refer to

for more details about the rowid.) If you specify a logical

page number (expressed as a decimal), the contents of that page are printed
if the page is a home page. If you specify a table, all the rows in the table are
printed, with their rowids. If you specify a database, all the rows in the
database are printed. Blob descriptors stored in the data row are printed but
blob data itself is not.

The -pD option prints the same information as -pd. In addition, -pD prints
blob values stored in the tblspace or blob header information for blobs stored
in a blobspace blobpage. For more details about how to use this output to
monitor disk pages, refer to

tbcheck -pd stores5:systables
tbcheck -pd stores5:systables 5
tbcheck -pD stores5:customer 0x101