Db2 On Premise and Cloud

 View Only

DMC - Statements not showing in Package cache tab but only in In-Flight Executions

  • 1.  DMC - Statements not showing in Package cache tab but only in In-Flight Executions

    Posted Fri March 04, 2022 09:14 AM
    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
    ------------------------------