IFCID 313 - Uncommitted Unit of Recovery

This topic shows detailed information about Record Trace - IFCID 313 - Uncommitted Unit of Recovery.

Uncommitted unit of recovery (UR) shows data from IFCID 313. It reflects the same information given in the Db2 messages DSNR035I and DSNR036I.

Record trace - IFCID 313 - Uncommitted Unit of Recovery

The field labels shown in the following sample layout of Record Trace - IFCID 313 - Uncommitted Unit of Recovery are described in the following section. 


                    10:14:49.79222814    555   1 313 UNCOMMITED     N/P                                                   
                    N/P                               UNIT OF RECOV NETWORKID:  DKBD0N01  LUNAME:  BDP0DTST  LUWSEQ:     6
------------------------------------------------------------------------------------------------------------------------- 
UNCOMMITTED URID : X'404040402D291B439AFE'                     CHKPTS TAKEN  :          0    TYPE OF UR/UW: FL            
NETWORKID        : DKBD0N01         LUNAME        : BDP0DTST   INSTANCE      : CB6E8EBE3DF1  COMMIT COUNT :          6    
CONNECTION ID    : RRSAF            CORRELATION ID: TOPRYD     MESSAGE NUMBER: DSNJ031I                                   
PLAN NAME        : BDBSBATC         LOG RECS WRTN :     300000 THRESHOLD TYPE: LOG RECORDS                                
AUTHORIZATION ID : UBIFAP                                                                                                 
END USER USERID  : UBIFAP                                                                                                 
TRANSACTION      : TOPRYD                                                                                                 
WORKSTATION      : RRSAF
UNCOMMITTED URID

The ID of the uncommitted unit of recovery.

Field Name: QW0313ID

CHKPTS TAKEN

For inflight units of recovery (UR), the number of checkpoints taken since the beginning of the UR. For indoubt URs, this field is set to -1 .

Field Name: QW0313CK

TYPE OF UR/UW
The type of uncommitted unit of recovery (UR/UW):
FL
Inflight UR
DU
Indoubt UR
RR
Repeatable read

Field Name: QW0313TY

LUWID - NETWORKID, LUNAME, INSTANCE, COMMIT COUNT
The logical unit of work ID (LUWID) identifies the thread within the network. It consists of the:
  • Fully qualified network name
  • Logical unit name
  • Logical unit of work (LUW) instance number
  • Logical unit of work (LUW) sequence number which identifies the last COMMIT scope, in which the logical unit participated

Field Name: QW0313LU

CONNECTION ID

The connection ID.

Field Name: QW0313CN

CORRELATION ID

The correlation ID.

Field Name: QW0313CR

MESSAGE NUMBER

The number of the Db2 message reflecting the information in this IFCID.

Field Name: QW0313MG

PLAN NAME

Plan Name from URE, if the UR is active, from RURE, if the UR is inactive (indoubt).

Field Name: QW0313PN

LOG RECS WRTN
Shows one of the following:
  • The number of log records written
  • The total number of minutes that the reader has been running

Field Name: QW0313LW

THRESHOLD TYPE
The type of threshold reached:
C
Checkpoints
L
Log records

Field Name: QW0313TH

AUTHORIZATION ID

Authorization ID from URE, if the UR is active, from RURE, if the UR is inactive (indoubt).

Field Name: QW0313AI

END USER USERID

End-user ID from CCB, if the UR is active. End user information is not available for indoubt URs.

Field Name: QW0313EU

TRANSACTION

End-user transaction name from CCB, if the UR is active. End user information is not available for indoubt URs.

Field Name: QW0313ET

WORKSTATION

End-user workstation name from CCB if the UR is active. End user information is not available for indoubt URs.

Field Name: QW0313EW