IBM Support

IT39754: LOCKING EVENT MONITOR "DROPPED RECORD" EVENT LEADS TO THE FLOOD OF DB2DIAG.LOG WARNING MESSAGES

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • When a LOCKING event monitor is active, it is possible during a
    period when MON_HEAP memory isn't available for a "dropped
    record" probe to occur.   When this occurs the probe keeps
    reoccurring and flooding the db2diag.log
    
    A sample probe is the following:
    
    2021-12-21-07.25.47.184568-300 E410844623E619        LEVEL:
    Warning
    PID     : 45331                TID : 140716403582720 PROC :
    db2sysc 0
    INSTANCE: xxxxxxxx             NODE : 000            DB   :
    xxxxxxx
    APPHDL  : 0-143                APPID: *LOCAL.DB2.2X1205XXXX15
    AUTHID  : xxxxx                HOSTNAME: xxxxxxxxxxxxxxxx
    EDUID   : 334                  EDUNAME: db2fw12 (xxxxxx) 0
    FUNCTION: DB2 UDB, database monitor,
    sqmFastWriterManager::processDroppedRecords, probe:10
    DATA #1 : <preformatted>
    Event monitor has 161 dropped records
    Start time: 12/15/2021 01:18:16.307628
    End time: 12/19/2021 07:30:44.545009
    
    The probes will stop when the database is deactivated.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Db2v11.1                                                     *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * Locking Event Monitor ?dropped record? event does not get    *
    * cleaned up properly leading to the the following probe       *
    * flooding db2diag.log                                         *
    * 2021-12-21-07.25.47.184568-300 E410844623E619        LEVEL:  *
    * Warning                                                      *
    * PID     : 45331                TID : 140716403582720 PROC :  *
    * db2sysc 0                                                    *
    * INSTANCE: xxxxxxxx             NODE : 000            DB   :  *
    * xxxxxxx                                                      *
    * APPHDL  : 0-143                APPID:                        *
    * *LOCAL.DB2.211205083315                                      *
    * AUTHID  : xxxxx                HOSTNAME: xxxxxxxxxxxxxxxx    *
    * EDUID   : 334                  EDUNAME: db2fw12 (xxxxxx) 0   *
    * FUNCTION: DB2 UDB, database monitor,                         *
    * sqmFastWriterManager::processDroppedRecords, probe:10        *
    * DATA #1 : <preformatted>                                     *
    * Event monitor has 161 dropped records                        *
    * Start time: 12/15/2021 01:18:16.307628                       *
    * End time: 12/19/2021 07:30:44.545009                         *
    * The probes will stop when the database is deactivated.       *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to 11.1.4.7                                          *
    ****************************************************************
    

Problem conclusion

  • Upgrade to 11.1.4.7
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT39754

  • 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

    2022-01-26

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

    IT39875

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:
03 May 2022