IBM Support

IT31098: RECOVERY FAILING DUE TO DUPLICATE XIDS IN THE TRANSACTION LOGS

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • Rollforward on HADR Standby is failing when it encounters
    duplicate XIDs during rollforward and fails the Standby.  This
    may also cause issues during regular rollforward operations.
    
    Example message:
    
    2019-09-20-15.37.49.992937+000 I11190960E501        LEVEL: Error
    PID    : 27533               TID : 140503441991424 PROC :
    db2sysc 0
    INSTANCE: db2inst1            NODE : 000           DB  : SAMPLE
    APPHDL : 0-56138             APPID: *LOCAL.DB2.190920153128
    HOSTNAME: db2server.ibm.com
    EDUID  : 12509               EDUNAME: db2redom (SAMPLE) 0
    FUNCTION: DB2 UDB, data protection services, sqlpSetXidInTEntry,
    probe:250
    MESSAGE : ZRC=0x80100007=-2146435065=SQLP_DUPID "Duplicate XID"
    
    2019-09-20-15.37.49.993291+000 I11191462E562        LEVEL: Error
    PID    : 27533               TID : 140503441991424 PROC :
    db2sysc 0
    INSTANCE: db2inst1            NODE : 000           DB  : SAMPLE
    APPHDL : 0-56138             APPID: *LOCAL.DB2.190920153128
    HOSTNAME: db2server.ibm.com
    EDUID  : 12509               EDUNAME: db2redom (SAMPLE) 0
    FUNCTION: DB2 UDB, recovery manager, sqlpRecDbRedo, probe:3555
    DATA #1 : <preformatted>
    tidhdl 1035 with tid 00000002648C7D77 has the same xid as tidhdl
    2950 with tid 00000002648C7D76, rc -2146435065
    

Local fix

  • N/A
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Any users doing RF recovery or HADR                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Version 11.1 Fixpack 6                            *
    ****************************************************************
    

Problem conclusion

  • Problem first fixed in Version 11.1 Fixpack 6
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT31098

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2019-11-27

  • Closed date

    2021-03-22

  • Last modified date

    2021-03-22

  • APAR is sysrouted FROM one or more of the following:

    IT30472

  • APAR is sysrouted TO one or more of the following:

    416AC4Ÿ

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1"}]

Document Information

Modified date:
23 March 2021