IBM 000-8697 Manual Do Utilizador

Utilities

The -pe option performs the same checks as the -ce option. In addition, -pe
displays the chunk and tblspace extent information as it checks it. Refer to the
-ce

 discussion on

.

tbcheck -pe

The -pk option performs the same checks as the -ci option. In addition, -pk
displays the key values for all indexes on the specified table as it checks them.

The -pK option performs the same checks as the -cI option. The -pK option
displays the key values and rowids as it checks them. (Refer to the -ci and -cI
discussions on

.)

The -pl option performs the same checks as the -ci option and displays the
key values, but only leaf-node index pages are checked. The root and branch-
node pages are ignored. (Refer to

 for more details about index-

root, branch-node, and leaf-node pages.)

The -pL option performs the same checks as the -cI option and displays the
key values and rowids, but only for leaf-node index pages. The root and
branch-node pages are ignored.

Repair options are available with all four flags.

tbcheck -pK -n stores5.customer

The -pp option requires as input either of the following values:

■

A table name and a rowid (expressed as a hexadecimal value)

■

A tblspace number and logical page number

Use the -pp option to dump the contents of the logical page number
contained in the rowid. The page contents appear in ASCII format. The
display also includes the number of slot-table entries on the page.