Hello Walter,
Package cache only displays top 20 (by default) queries order by the following 16 KPIs:
1. num_exec_with_metrics
2. stmt_exec_time
3. total_cpu_time
4. rows_read
5. rows_returned
6. total_act_wait_time
7. lock_wait_time
8. sort_overflows
9. logical_reads
10. physical_reads
11. temp_reads
12. pool_data_l_reads
13. pool_index_l_reads
14. lock_escals
15. lock_waits
16. wlm_queue_time_total
If your system is very busy, the query might not be in the top 20 list, and that's the reason you don't see it in the package cache pane.
You can change the default configuration in the monitoring profile:
I hope that helps!
------------------------------
Cintia Ogura
------------------------------
Original Message:
Sent: Fri March 04, 2022 07:28 AM
From: Walter Flávio
Subject: DMC - Statements not showing in Package cache tab but only in In-Flight Executions
Hello,
We used to use IBM Data Server Manager then we did a new fresh installation of the IBM Data Management Console ( version 3.1.7.0 Enterprise Build: 20220118-151147 ).
There is much doubts about it but what I did understand is I did a custom search in the past time and found a query was on In-flight execution tab doing a lot of I/O ( rows read ) but the same query was not showing in package cache tab.
I know that In-Flight Executions retrieves data from table function MON_GET_ACTIVITY. It returns the list of all activities that were submitted and have not yet been completed but in this case a query was in executeing state at Mar 3, 2022 2:34:40 PM but when I go on package cache tab I didnt find even when I selected the end time 3 PM.
How can be possible a application being listed on in-flight executions tab from Statement and not showing in package cache tab ?
------------------------------
Walter Flávio
------------------------------
#Db2