Fixes are available
APAR status
Closed as program error.
Error description
A timing issue can cause the db2hadrs EDU to self deadlatch when it detects the lost of connection with the primary database while in the middle of requesting new log file to be created. The following output from db2pd -stack of the db2hadrs EDU can confirm the problem: <Stack> 0x090000000922BDA8 sqloXlatchConflict + 0x888 0x0900000009BA0780 sqlpgPostLogAlloc__FP9SQLP_DBCBCUl + 0x460 0x090000000AA13130 hdrCloseConn__FP8HDR_DBCBUi + 0x990 0x090000000AA12360 hdrSendMsg__FP8HDR_DBCBiP13HDR_RQST_COMMbP14SqlzDB2Version + 0x680 0x090000000AA11B5C hdrWrapAndSendMsg__FP8HDR_DBCB9HDR_RTYPEUiPclT3PP13HDR_RQST_COMM + 0x2DC 0x090000000AA30774 hdrSendHeartBeat__FP8HDR_DBCBCUl + 0x794 0x090000000AA8CD20 hdrSendHeartBeatAndUpdateReceiveTime__FP8HDR_DBCB + 0x20 0x090000000AA4DBA4 hdrWaitWithHeartBeat__FP16SQLO_EDUWAITPOSTPUiP8HDR_DBCB + 0xA4 0x0900000009B9FFF8 sqlpgWaitForLogAllocPostback__FP9SQLP_DBCB + 0x98 0x0900000009BA061C sqlpgPostLogAlloc__FP9SQLP_DBCBCUl + 0x2FC 0x090000000A9E0AF4 hdrSPostLogallocToCreateLogFile__FP9SQLP_DBCBUiCb + 0x254 0x090000000A9E40E8 hdrHandleXhdrMsg__FP8HDR_DBCBP11HDR_HDR_MSGPb + 0x1E28 0x090000000AA75E88 hdrEduS__6hdrEduFPUl + 0x1A88 0x090000000AA7FC18 hdrEduEntry__6hdrEduFv + 0x1438 0x090000000AA8BC90 RunEDU__6hdrEduFv + 0x30 0x09000000092BEBC0 EDUDriver__9sqzEDUObjFv + 0x300 0x09000000091ADB14 sqloEDUEntry + 0x374 </Stack> <LatchInformation> Waiting on latch type: (SQLO_LT_SQLP_DBCB__sqlp_logalloc_sem) - Address: (0xa0003000009b9a0), Line: 1016, File: sqlpgpst.C Holding Latch type: (SQLO_LT_SQLP_DBCB__sqlp_logalloc_sem) - Address: (0xa0003000009b9a0), Line: 1016, File: sqlpgpst.C HoldCount: 1 </LatchInformation> This problem was first introduced in V10.5 fixpak 5.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 11.1 Mod 4 Fixpack 5 or higher * ****************************************************************
Problem conclusion
First fixed in Db2 11.1 Mod 4 Fixpack 5
Temporary fix
Comments
APAR Information
APAR number
IT26775
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
2018-10-29
Closed date
2020-01-18
Last modified date
2020-01-18
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