Db2

  • 1.  EVENT Monitor Error messages in Diaglog

    Posted Thu March 19, 2020 04:14 PM
    Hello,
    I see these messages in the diaglog, I removed the database connections on the console and added them back, still doesn't go away.

    2020-03-19-16.08.52.646260-240 I132065832A708       LEVEL: Error
    PID     : 4849954              TID : 120740         PROC : db2sysc 0
    INSTANCE: ######          NODE : 000           DB   : ##########
    APPHDL  : 0-26535              APPID: ##############
    AUTHID  : #########               HOSTNAME: ########
    EDUID   : 120740               EDUNAME: db2agent (FTMDB) 0
    FUNCTION: DB2 UDB, database monitor, sqm_evmon_mgr::set_evmon_active, probe:20
    MESSAGE : ZRC=0x800D0029=-2146631639=SQLM_RC_EVNSET "evmon not set"
              DIA8050E Event monitor already active or inactive.
    CALLED  : DB2 UDB, database monitor, sqm_evmon_mgr::start_evmon
    DATA #1 : String with size, 17 bytes
    RTMON_EVMON_STATS



    Regards,
    Rakesh​​​​​​​​​​​

    ------------------------------
    RAKESH CHATURVIDI
    ------------------------------

    #Db2


  • 2.  RE: EVENT Monitor Error messages in Diaglog

    Posted Thu March 19, 2020 10:12 PM
    Hi RAKESH,

    If your statistics event monitor (to collect query running time distribution statistic data for Summary page - Database Responsiveness) works properly, please ignore these message. This is a known issue, and we already improve such log messages in next release. Thanks!

    ------------------------------
    XIAO MIN ZHAO
    ------------------------------



  • 3.  RE: EVENT Monitor Error messages in Diaglog

    Posted Mon July 06, 2020 10:04 AM
    Hi XIAO

    I am also receiving the same message in db2diag.log..  Do  you want to us to upgrade on 3.1.2.0 Version to fix this issue

    2020-07-06-01.13.41.685015-240 I1826A753 LEVEL: Error
    PID : 51642676 TID : 17626 PROC : db2sysc 0
    INSTANCE: db2im123 NODE : 000 DB : AKBNMLMO
    APPHDL : 0-46115 APPID: 10.201.113.59.54667.200706051341
    UOWID : 7 ACTID: 1
    AUTHID : DBMON HOSTNAME: nasdbmo11
    EDUID : 17626 EDUNAME: db2agent (AKBNMLMO) 0
    FUNCTION: DB2 UDB, database monitor, sqm_evmon_mgr::set_evmon_active, probe:20
    MESSAGE : ZRC=0x800D0029=-2146631639=SQLM_RC_EVNSET "evmon not set"

    ------------------------------
    PRASHANT SHIVMATH
    ------------------------------



  • 4.  RE: EVENT Monitor Error messages in Diaglog

    Posted Mon July 06, 2020 11:50 PM
    Edited by System Fri January 20, 2023 04:36 PM
    Hi PRASHANT,

    Yes. We add check before changing all types of event monitor status. This issue is supposed to be covered in the fix. Would you please upgrade your DMC to 3.1.2.0 Version and see whether these errors are gone?

    ------------------------------
    XIAO MIN ZHAO
    ------------------------------