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 ACTION
----- ----- -------- -------- ---- ----- ----------  ---------- ------
00017 00005 DB1      IX1      003  0001  0000000999  -000000001 A

******* 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.

ACTION

indicates the action taken for each index, with the following possible values:

A

The index is candidate for FTB creation when the INDEX_MEMORY_CONTROL subsystem parameter setting is (SELECTED,n).

D

FTB creation is disabled for the index.

F

FTB creation is forced for the index.

blank

All other situations.