IT25493: DB2 STANDBY CRASH ON SQLOGETMEMPOOLSTATSUNLATCHED WHEN DB2_HADR_ROS IS ENABLED

APAR status

• Closed as program error.

Error description

• A DB2 HADR standby might crash if a Snapshot is run and
  DB2_HADR_ROS  is enabled.
  The stack will show the following functions:
  
  0 ossDumpStackTraceInternal
  
  1 ossDumpStackTraceV98
  
  2 OSSTrapFile::dumpEx
  
  3 sqlo_trce
  
  4 sqloEDUCodeTrapHandler
  
  5 __PRETTY_FUNCTION__.6036
  
  6 sqloGetMemPoolStatsUnlatched
  
  7 sqlmindb
  
  8 sqm_snap_dbase
  
  9 sqlmonssagnt
  
  10 sqlmonssbackend
  
  11 sqlesrvr
  
  12 sqleMappingFnServer
  
  13 sqlerKnownProcedure
  
  14 sqlerCallDL
  
  15 sqljs_ddm_excsqlstt
  
  16 sqljsParseRdbAccessed
  
  17 sqljsParse
  
  18 sqljsSqlam
  
  19 sqljsDrdaAsInnerDriver
  
  20 sqljsDrdaAsDriver
  
  21 sqeAgent::RunEDU
  
  22 sqzEDUObj::EDUDriver
  
  23 sqloEDUEntry
  
  24 pthread_attr_setinheritsched
  
  25 clone
  

Local fix

• Use this registry to force db latch over database snapshot and
  other snapshots that report memory usage:
  db2set db2_system_monitor_settings=nodblatch:none
  

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 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