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

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

    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: 3.1.4.0-ibm-datamgtconsole-monitor-allPlatforms_20210129 

    Thanks.

    ------------------------------
    Jason Sizto
    ------------------------------