Filter
Top Products
Utilities 7-43
Option Descriptions
-pe Option
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 page 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
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 page 7-40.)
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 page 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 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.