A fix is available
APAR status
Closed as program error.
Error description
Db2 hangs with many EDUs waiting on logTailHeartBeatLatch. This problem only occurs on database using HADR feature. It is caused by abnormal termination of "db2pd -hadr" command, where the db2pd process was killed while holding this particular latch. The problem can be identified with db2hadrp thread having the following stack: 0x090000006C2C0C98 sqloXlatchConflict + 0x8F8 0x090000006E089910 sqlpGetLogTailHeartBeat__FP9SQLP_DBCBP17SQLPG_LOG_TAIL_HB + 0x370 0x090000006DDB9FF0 hdrStoreLocMonElements + 0xAF0 0x090000006DDBA478 hdrStoreReceivedMonElements__FP8HDR_DBCBP11HDR_HDR_MSG + 0x58 0x090000006DDFF428 hdrEduP__6hdrEduFCbPUl + 0x2968 0x090000006DE160E0 hdrEduEntry__6hdrEduFv + 0x1DA0 Waiting on latch type: (SQLO_LT_SQLP_DBCB__logTailHeartBeatLatch) - Address: (0xa0002000009e2e8), Line: 6632, File: sqlputil.C
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * HADR * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Update to db2 version 11.1.4.7 * ****************************************************************
Problem conclusion
Update to db2 version 11.1.4.7
Temporary fix
Comments
APAR Information
APAR number
IT39279
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
2021-12-01
Closed date
2022-04-17
Last modified date
2022-04-17
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
DB2 FOR LUW
Fixed component ID
DB2FORLUW
Applicable component levels
RB10 PSN
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