Db2 On Premise and Cloud

 View Only
Expand all | Collapse all

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:16 AM
    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
    ------------------------------


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

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



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

    Posted Thu March 10, 2022 08:14 AM
    Cintia,

    Thanks. Your explanation could help me not only to understand but customize the DMC.

    Walter Flávio Dias Broxado Santos

    INFRAESTRUTURA E OPERAÇÕES DE TI | Infraestrutura de TI

    Administrador de Banco de Dados

    Eu conecto pessoas para promover
    justiça financeira e prosperidade.

    https://www.bancoob.com.br/assinaturas/imagens/telefone-icon-20x20.png (61) 3217-8392 | sicoob.com.br
    https://www.bancoob.com.br/assinaturas/imagens/local-icon-20x20.png SEDE I: SIG quadra 6 lote 2080
    70610-460 Brasília/DF
    sicoob