Db2 (On Premises and Cloud)

Expand all | Collapse all

Data Management Console 3.1.4

  • 1.  Data Management Console 3.1.4

    Posted Thu May 20, 2021 01:57 PM

    I am trying to establish the Stats Event Monitor.

    In Settings the Stats Event Monitor Opt-in is enabled.

    When I create a new connection to a database, All objects defined in Stored Procedure IBM_RTMON.EVMON_PREREQ() were created.
    But the Statistic Event Monitor itself seems not  to be created in the database, What am I doing wrong?

    SQL0204N "RTMON_EVMON_STATS" is an undefined name. SQLSTATE=42704

    db2 "select count(*) from syscat.eventmonitors where evmonname = 'RTMON_EVMON_STATS'"


    1 record(s) selected.

    The responsiveness window doesn't show any statistics.

    In the event monitor profile  view the warning message does not dissapear, only saying "the event monitor ran into a problem. please wait while the console fixes the issue ....."

    I have no idea, how I can fix this issue!

    Could you help?

    Best regards, Peter

    Peter Kremer

  • 2.  RE: Data Management Console 3.1.4

    Posted Fri May 21, 2021 01:16 AM
    Hi Peter,

    This is a known issue, there is a hotfix available on IBM Fix Central:  https://www.ibm.com/support/fixcentral/

    This is the name of the fix: 


    Jason Sizto