IBM 000-8697 Manual de usuario descargar pdf (Pagina 521)

100

101

Utilities 7-43

Option Descriptions

-pe Option

The -pe option performs the same checks as the -ce option. In addition, -pe

displaysthechunkandtblspaceextentinformationasitchecksit.Refertothe

-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

displaysthekeyvaluesforallindexesonthespeciﬁedtableasitchecksthem.

The -pK option performs the same checks as the -cI option. The -pK option

displaysthe key values androwids as itchecksthem. (Refer tothe-ci and -cI

discussions on page 7-40.)

The -pl option performs the same checks as the -ci option and displays the

keyvalues, but onlyleaf-nodeindexpages arechecked. The rootandbranch-

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 ﬂags.

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.

1 2 ... 516 517 518 519 520 521 522 523 524 525 526 ... 701 702

Comentarios a estos manuales

Sin comentarios

IBM 000-8697 Manual de usuario Pagina 521

Comentarios a estos manuales

Relacionado con productos y manuales para Software de base de IBM 000-8697