Fixes are available
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:
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
RB10 PSY
UP
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
04 May 2022