IT39279: Db2 hangs with many EDUs waiting on logTailHeartBeatLatch

Db2 Version 11.1 Mod 4 Fix Pack 7 for Linux, UNIX, and Windows

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 is sysrouted FROM one or more of the following:

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

  IT39359

Fix information

• Fixed component name

  DB2 FOR LUW

• Fixed component ID

  DB2FORLUW

Applicable component levels

• RB10 PSN

     UP