IBM 000-8697 -pe Option, -pk and -pK, -pl and -pL Options, -pp and -pP options

Utilities 7-43
Option Descriptions
-pe Option
The -pe option performs the same checks as the-ce option. In addition, -pe
displaysthe chunk and tblspace extent information as it checks it. Refer to the
-ce discussion onpage 7-40.
tbcheck -pe
-pk and -pK, -pl and -pL Options
The -pk option performs the same checks as the-ci option. In addition, -pk
displaysthe 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
displaysthe key values and rowids as it checks them. (Refer to the -ci and -cI
discussions onpage 7-40.)
The -ploption performs the same checks as the -ci option and displays the
keyvalues, but only leaf-node index pages are checked. The root and branch-
node pages are ignored. (Refer topage 2-133 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
-pp and -pP options
The -pp option requires as input either of the followingvalues:
■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.