IFCID 477 - FTB IDX ALLOC

This topic shows detailed information about Record Trace - IFCID 477 - FTB IDX ALLOC.

IFCID 477 shows the allocation and deallocation of structures for fast index traversal (FTB). This record is written when the performance class 4 trace is on.

Record trace - IFCID 477 - FTB IDX ALLOC

The field labels shown in the following sample layout of Record Trace - IFCID 477 - FTB IDX ALLOC 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 477 FTB IDX ALLOC  NETWORKID:  DSND20G   LUNAME:  DSNDC1H   
N/P                  N/P                                                                                      
-------------------------------------------------------------------------------------------------------------
ACTION : CREATE
DBID: 265      PSID: 11       PARTITION NO:     1 INDEX LEVELS:     2 FTB SIZE:        2339584

ACTION

Shows the allocation and deallocation for fast index traversal. It can have the following values:

Create
Free

Field Name: QW0477FL

DBID

Shows the database ID.

Field Name: QW0477DB

PSID

Shows the index page set ID.

Field Name: QW0477OB

PARTITION NO

Shows the partition number.

Field Name: QW0477PT

INDEX LEVELS

Shows the number of index levels in the fast traversal block (FTB).

Field Name: QW0477LV

FTB SIZE

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

Field Name: QW0477SZ