IFCID 377 - Pseudo Delete Daemon Cleanup

This topic shows detailed information about "Record Trace - IFCID 377 - Pseudo Delete Daemon Cleanup".

IFCID 0377 records automatic cleanup of pseudo-deleted index entries by the index pseudo-delete daemon. This record is not associated with a trace class.

Record trace - IFCID 377 - Pseudo Delete Daemon Cleanup

The field labels shown in the following sample layout of "Record Trace - IFCID 377 - Pseudo Delete Daemon Cleanup" are described in the following section.

PRIMAUTH CONNECT   INSTANCE      END_USER       WS_NAME                       TRANSACT                                              
ORIGAUTH CORRNAME  CONNTYPE      RECORD TIME    DESTNO ACE IFC  DESCRIPTION   DATA                                                  
PLANNAME CORRNMBR                TCB CPU TIME              ID                                                                       
-------- -------- ----------- ----------------- ------ --- --- -------------- ------------------------------------------------------
SYSOPR   DB2B     CB6EA03AAC12 N/P              N/P                           N/P                                                   
SYSOPR   014.IDAE 'BLANK'     11:47:21.66633960    454   1 377 PSEUDO DELETE  NETWORKID:  DKBD0N01  LUNAME:  BDP0DTST  LUWSEQ:   144
'BLANK'  MK01                 N/P                              DAEMON CLEANUP                                                       
         |------------------------------------------------------------------------------------------------------------------------- 
         |DATABASE ID        :  403                       INDEX PAGE NUMBER  :          11        PARTITION NUMBER   :           1  
         |INDEX PAGE SET ID  :  16                        PD ENTRIES REMOVED :         594                                          
         |FLAG:              :  PAGE IS DELETED FROM INDEX                                                                          
         |------------------------------------------------------------------------------------------------------------------------- 
                              11:47:21.67700906    455   1 377 PSEUDO DELETE  N/P                                                   
                              N/P                              DAEMON CLEANUP NETWORKID:  DKBD0N01  LUNAME:  BDP0DTST  LUWSEQ:   144
         |------------------------------------------------------------------------------------------------------------------------- 
         |DATABASE ID        :  403                       INDEX PAGE NUMBER  :          34        PARTITION NUMBER   :           1  
         |INDEX PAGE SET ID  :  16                        PD ENTRIES REMOVED :         594                                          
         |FLAG:              :  PAGE IS DELETED FROM INDEX                                                                          
         |-------------------------------------------------------------------------------------------------------------------------

DATABASE ID

The database ID of the index for which entries are cleaned up.

Field Name: QW0377DB

INDEX PAGE NUMBER

The page number of the index page that was cleaned up.

Field Name: QW0377PG

PARTITION NUMBER

The index partition number.

Field Name: QW0377PT

INDEX PAGE SET ID

The page set ID of the index.

Field Name: QW0377OB

PD ENTRIES REMOVED

The number of pseudo-deleted entries that were removed.

Field Name: QW0377NU

FLAG

The reason for the page removal:

A page is deleted from an index (DB2 field: QW0377DL)
A page is cleaned up (DB2 field: QW0377CL)

Field Name: RW0377DL

Feedback