DSNT830I DBID PSID DBNAME IX-SPACE LVL PART TRAV. COUNT FTB FACTOR

Explanation

This message displays output from the DISPLAY STATS(INDEXTRAVERSECOUNT) command.

The output provides the following information about the index traverse count and FTB factor for one or more specified indexes. If multiple lines are included they are in descending order starting with the index with the highest FTB factor.

DBID

The internal identifier of the database that contains the index.

PSID

The page set descriptor of the index space.

DBNAME

The name of the database that contains the index.

IX-SPACE

The name of the index space.

LVL

The number of index levels in the index for which fast index traversal is being used. The FTBs (fast traverse blocks) for fast index traversal contain information for root and non-leaf index pages, but not for leaf pages.

PART

The index partition number.

TRAV. COUNT

The number of index traversals for the index space.

FTB FACTOR

A calculated value that Db2 uses to identify indexes that might benefit from fast index traversal.