IFCID 389 - FTB Indexes

IFCID 389 traces indexes with structures for fast index traversal (FTB). This record is written when the Statistics class 8 trace is on.

Record Trace - IFCID 389 - FTB Indexes

The field labels shown in the following sample layout of Record Trace - IFCID 389 - FTB Indexes are described in the following section.

CONNECT   INSTANCE      END_USER       WS_NAME                       TRANSACT
CORRNAME  CONNTYPE      RECORD TIME    DESTNO ACE IFC  DESCRIPTION   DATA
CORRNMBR                TCB CPU TIME              ID
-------- ----------- ----------------- ------ --- --- -------------- -----------------------------------------
N/P      D0B9113C791A N/P              N/P                           N/P
N/P      'BLANK'     18:19:12.26938222  12133   1 389 FTB INDEXES    NETWORKID:  DSND20G   LUNAME:  DSNDC1H
N/P                  N/P
-------------------------------------------------------------------------------------------------------------
NUMBER OF INDEXES  :           7
DBID: 364      PSID: 10       PARTITION NO:     1 INDEX LEVELS    :         2 FTB SIZE  :        2339584
                                                  INDEX TRAVERSALS:        10 FTB FACTOR:             15
DBID: 364      PSID: 5        PARTITION NO:     1 INDEX LEVELS    :         3 FTB SIZE  :        1368064
                                                  INDEX TRAVERSALS:        12 FTB FACTOR:             17
DBID: 370      PSID: 5        PARTITION NO:     1 INDEX LEVELS    :         2 FTB SIZE  :        1560064
                                                  INDEX TRAVERSALS:        20 FTB FACTOR:             16
DBID: 370      PSID: 5        PARTITION NO:     2 INDEX LEVELS    :         3 FTB SIZE  :        5209600
                                                  INDEX TRAVERSALS:        15 FTB FACTOR:             18
DBID: 370      PSID: 5        PARTITION NO:     3 INDEX LEVELS    :         2 FTB SIZE  :        2560000
                                                  INDEX TRAVERSALS:         5 FTB FACTOR:             10
DBID: 370      PSID: 5        PARTITION NO:     4 INDEX LEVELS    :         3 FTB SIZE  :         146176
                                                  INDEX TRAVERSALS:        11 FTB FACTOR:             99
DBID: 350      PSID: 5        PARTITION NO:     1 INDEX LEVELS    :         2 FTB SIZE  :         195584
                                                  INDEX TRAVERSALS:        17 FTB FACTOR:             54

NUMBER OF INDEXES

The number of indexes with fast traversal blocks.

Field Name: QW0389NU

DBID

The database ID.

Field Name: QW0389DB

PSID

The index page set ID.

Field Name: QW0389OB

PARTITION NO

The partition number.

Field Name: QW0389PT

INDEX LEVELS

The number of index levels in the fast traversal block.

Field Name: QW0389LV

FTB SIZE

Indicates the size of the fast traversal block (FTB), in bytes.

Field Name: QW0389SZ

FTB FACTOR

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

Field Name: QW0389FF

INDEX TRAVERSALS

The number of index traversals

Field Name: QW0389IT