IBM Support

IT25493: DB2 STANDBY CRASH ON SQLOGETMEMPOOLSTATSUNLATCHED WHEN DB2_HADR_ROS IS ENABLED

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

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 number

    IT25493

  • 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-06-26

  • Closed date

    2020-01-16

  • Last modified date

    2020-01-16

  • 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":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 January 2020