Hi Joachim,
I am not sure which event monitor blocks others, so far as I know statistics event monitor is lightweight, but activity event monitor and locking event monitor are heavy. Would you like to help me to try which event monitor is the root cause when you are free? That will take long time for you. And also I will try to do these using our playground, but not sure I can reproduce your problem on my environment.
Prepare:
Stop DMC and delete all monitor log file : monitor.(0-3)
Start DMC
Senario 1：Enable activity event monitor and statistics event monitor
1.Go to Event monitor profile page
2. Click ' ICT '
3. Set ' ON ' for Activity event monitor, Statistics event monitor
How to check:
Waiting for 10 minutes, you can check log file monitor.0, please search 'it time to start collect by last time haven't return :ICTConfigName = HistogramsData'. If log file doesn't contain it. please wait for 1.5 hour or more. If it still doesn't contain it. then go to senario 2. If contains, so please keep carefully when needing enable it.
Or Waiting for 1.5 hour or more, check UI if there is no data with last 1 hour for the Responsiveness widget, if no data on it, then the root cause is activity event monitor. If Responsiveness widget has data, please continue to senario 2.
Senario 2: Enable locking event monitor
1.Go to Event monitor profile page
2. Click ' ICT '
3. Set ' ON ' for locking event monitor, Activity event monitor, Statistics event monitor
Using same method, If find 'it time to start collect by last time haven't return :ICTConfigName = HistogramsData', the root cause should be locking and activity event monitor, please keep carefully when needing enable both them .
To make sure if the locking event monitor is the root cause, please disable activity and locking (please wait more than 1 minute, because disable them will take some time)then restart DMC , set 'ON' for locking and statistics, wait for same time period to check log again.
By the end, If when you enable locking, Activity, Statistics, but doesn't find the key message in log and Responsiveness widget also has data. that should keep carefully when needing enable them all.
------------------------------
Zhen Ling Yu
------------------------------
Original Message:
Sent: Mon December 07, 2020 07:44 AM
From: Joachim Müller
Subject: Db2 Data Management Console 3.1.3 Responsiveness
Hello Zhen,
That's what I also do before, but without success.
Do it again and send the monitor files from the logs directory.
Bets regards,
Joachim
------------------------------
Joachim Müller
Original Message:
Sent: Mon December 07, 2020 07:35 AM
From: Zhen Ling Yu
Subject: Db2 Data Management Console 3.1.3 Responsiveness
Hi Joachim,
Maybe it is held by some logic to not allow to modify it, I will investigate it .
And could you skip this step then disable and enable statistics event monitor profile?
------------------------------
Zhen Ling Yu
Original Message:
Sent: Mon December 07, 2020 06:35 AM
From: Joachim Müller
Subject: Db2 Data Management Console 3.1.3 Responsiveness
Hello Zhen,
That's what I did.
------------------------------
Joachim Müller
Original Message:
Sent: Mon December 07, 2020 06:18 AM
From: Zhen Ling Yu
Subject: Db2 Data Management Console 3.1.3 Responsiveness
Hi, Joachim
Please click 'Event Monitor Profile' and then find the name is same with your db, then click it.
------------------------------
Zhen Ling Yu
Original Message:
Sent: Mon December 07, 2020 05:13 AM
From: Joachim Müller
Subject: Db2 Data Management Console 3.1.3 Responsiveness
Hello Zhen,
Could it be, that you have another view as me?
I can't find the first view to change the tablespace.
Best regards,
Joachim
------------------------------
Joachim Müller
Original Message:
Sent: Mon December 07, 2020 04:47 AM
From: Zhen Ling Yu
Subject: Db2 Data Management Console 3.1.3 Responsiveness
Hello Joachim,
From Xiao Min's suggestion, would you please specify a new tablespace on Event Monitor Profile Page? and then disable statistics event monitor and enable again. please help upload monitor.* log files after doing these. Thank you.
------------------------------
Zhen Ling Yu
Original Message:
Sent: Mon December 07, 2020 01:23 AM
From: Joachim Müller
Subject: Db2 Data Management Console 3.1.3 Responsiveness
Hello XIAO,
See the result from the sql queries from one of our HADR monitored databases, which have no "Responsiveness" figures.
db2ict@r6l43[/db2/db2ict]> db2 "select evmonname,event_mon_state(evmonname) from syscat.eventmonitors"EVMONNAME 2-------------------------------------------------------------------------------------------------------------------------------- -----------MON_UTIL1498742453812 0PROFILE 0RTMON_EVMON_ACTIVITIES 0RTMON_EVMON_LOCKING 1RTMON_EVMON_STATS 1RTMON_EVMON_UTILITY 0 6 record(s) selected.db2ict@r6l43[/db2/db2ict]> db2 "SELECT WORKLOADID, WORKLOADNAME, ENABLED, COLLECTAGGACTDATA, COLLECTACTDATA, REMARKS FROM SYSCAT.WORKLOADS ORDER BY WORKLOADID"WORKLOADID WORKLOADNAME ENABLED COLLECTAGGACTDATA COLLECTACTDATA REMARKS ----------- -------------------------------------------------------------------------------------------------------------------------------- ------- ----------------- -------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 1 SYSDEFAULTUSERWORKLOAD Y B D - 2 SYSDEFAULTADMWORKLOAD Y B D - 3 DSM_WORKLOAD N N N - 4 CONSOLE_WORKLOAD Y N N - 4 record(s) selected.db2ict@r6l43[/db2/db2ict]> paceid from syscat.tables where tabname='HISTOGRAMBIN' and tabschema = 'IBM_RTMON')" <TBSPACE--------------------------------------------------------------------------------------------------------------------------------TS4MONITOR 1 record(s) selected.
Best regards,
Joachim
------------------------------
Joachim Müller
Original Message:
Sent: Sun December 06, 2020 08:49 PM
From: XIAO MIN ZHAO
Subject: Db2 Data Management Console 3.1.3 Responsiveness
Hi Joachim,
Would you please try to execute the following sqls on the HADR database (with none data in RESPONSIVENESS) and show me the results? Thanks!
select evmonname,event_mon_state(evmonname) from syscat.eventmonitors;SELECT WORKLOADID, WORKLOADNAME, ENABLED, COLLECTAGGACTDATA, COLLECTACTDATA, REMARKS FROM SYSCAT.WORKLOADS ORDER BY WORKLOADID;select tbspace from syscat.tablespaces where tbspaceid in (select tbspaceid from syscat.tables where tabname='HISTOGRAMBIN' and tabschema = 'IBM_RTMON');
------------------------------
XIAO MIN ZHAO
Original Message:
Sent: Fri December 04, 2020 07:13 AM
From: Joachim Müller
Subject: Db2 Data Management Console 3.1.3 Responsiveness
Hello Zhen,
I believe all looks fine:
------------------------------
Joachim Müller
Original Message:
Sent: Fri December 04, 2020 06:47 AM
From: Zhen Ling Yu
Subject: Db2 Data Management Console 3.1.3 Responsiveness
Seems static event monitor doesn't setup on it. you can click the new primary name to jump to summary page, there will be a link on that widget to guide how to setup static event monitor.
------------------------------
Zhen Ling Yu
Original Message:
Sent: Fri December 04, 2020 02:52 AM
From: Joachim Müller
Subject: Db2 Data Management Console 3.1.3 Responsiveness
Hello Kai,
attached you will find the monitor files from DMC.
Best regards,
Joachim
------------------------------
Joachim Müller
Original Message:
Sent: Fri December 04, 2020 02:36 AM
From: KAI DING
Subject: Db2 Data Management Console 3.1.3 Responsiveness
Hi Joachim,
Could you provide the monitor log for investigation? thanks.
------------------------------
KAI DING
Original Message:
Sent: Fri December 04, 2020 02:05 AM
From: Joachim Müller
Subject: Db2 Data Management Console 3.1.3 Responsiveness
Hello Kai,
non-HADR database are looking good, but HADR databases show no figures for "Responsiveness". We have no license for RoS, so we will only see empty responsiveness on the primary database. After a takeover we see empty responsiveness on the old standby (now the primary).
This is the screenshot form our Test DMC System:
Best regards,
Joachim
------------------------------
Joachim Müller
Original Message:
Sent: Fri December 04, 2020 01:53 AM
From: KAI DING
Subject: Db2 Data Management Console 3.1.3 Responsiveness
Hi Joachim,
To confirm, the non-HADR DBs are good. For HADR DBs, "Responsiveness" is empty. May I know that whether both primary and standby DB are empty?
------------------------------
KAI DING
Original Message:
Sent: Fri November 27, 2020 07:21 AM
From: Joachim Müller
Subject: Db2 Data Management Console 3.1.3 Responsiveness
Hello DMC Team.
After a few days of checking, it turns out that only the HADR databases are affected. Could you already verify this?
Best regards,
Joachim
------------------------------
Joachim Müller
Original Message:
Sent: Fri November 20, 2020 01:53 AM
From: Joachim Müller
Subject: Db2 Data Management Console 3.1.3 Responsiveness
Hello DMC Team,
After upgrade the DMC 3.1.2 to 3.1.3 I'm not able to see any values for "Responsiveness" for HADR databases.
Whether in the Overview nor in the Summary overview for a database.
------------------------------
Joachim Müller
------------------------------
#Db2