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
------------------------------
#Db2