IBM 000-8697 Benutzerhandbuch
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
displays the chunk and tblspace extent information as it checks it. Refer to the
-ce
discussion on
.
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.
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
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
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.
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.
contained in the rowid. The page contents appear in ASCII format. The
display also includes the number of slot-table entries on the page.