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

The DSNT830I 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 PSID DBNAME   IX-SPACE LVL PART TRAV. COUNT FTB FACTOR
---- ---- -------- -------- --- ---- ----------- ----------- 
0017 0005 DB1      IX1      003 0001 00000000999 -0000000001

******* DISPLAY OF STATS ENDED ****************** 

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 as a moving average.

FTB FACTOR

Db2 calculates the FTB factor value from the index traversal count and other factors, such as index page splits, and internally applies its as a weight for evaluating whether specific indexes can benefit from index traversal.