and show system
SELECT SUBSTR(BP_NAME,:L0 ,:L1 ) AS BP_NAME, TOTAL_HIT_RATIO_PERCENT, DATA_HIT_RATIO_PERCENT, INDEX_HIT_RATIO_PERCENT, XDA_HIT_RATIO_PERCENT FROM SYSIBMADM.BP_HITRATIO
all screens work well , except package cache.. if you repeat the refresh xxx times, sometimes, you get a display...
------------------------------
Thank for all update/help
Best Regards, Guy Przytula
------------------------------
Original Message:
Sent: Thu December 24, 2020 10:04 PM
From: HAO WU
Subject: package cache
@Guy Przytula Merry Christmas! Thanks for sharing the issue you met in DMC. There might be couple of reasons which cause no data returned in this page. Please help check below list and let us know if more information needed.
1. Confirm whether the monitored db is active and connected by DMC. Go to Administration- Connection profile - select the target db name - click "Edit" - click "Test connection"
2. Confirm whether the target db is monitored by DMC. In DMC homepage, there is summary of databases in "Available", "Disconnected" and "Not monitored" . Confirm the target db is not in "Not monitored" category.
3. Is there some queries running at the time you selecting monitor-statement- package cache? You can select monitor - statement - Inflight executions to check whether there is some queries running.
4. Please click the "show system" button in monitor-statement- package cache and monitor - statement - Inflight executions to display queries executed by DMC monitor. DMC issues queries to get monitor data from the target db in every time interval (for example 5min) which is called "system queries". DMC hides these "system queries" by default. You can display system queries in this way even you don't have any workload running on the target db. This is a simple way to tell whether DMC monitor works or not. If "show system" returns value, so DMC monitor is working. If "show system" doesn't return value, then the target db might be either disconnected or not monitored by DMC.
------------------------------
HAO WU
Original Message:
Sent: Mon December 21, 2020 02:43 AM
From: Guy Przytula
Subject: package cache
when selecting monitor-statements-package cache : nothing is displayed - even doing many times refresh ..
------------------------------
Thanks for all answers
Best Regards,
Guy Przytula
------------------------------
#Db2