Db2

Db2

Connect with Db2, open source, and other data experts to gain value from your data, share insights, and solve problems.

 View Only

  • 1.  package cache

    Posted Wed December 30, 2020 05:20 AM

    looking at output of dmc : package cache and snapshot of dynamic sql there is a big difference

    nbr of execution was 10 and after refresh 9  ??

    snapshot :

    is the info coming from different places ?



    ------------------------------
    Thank for all update/help
    Best Regards, Guy Przytula
    ------------------------------

    #Db2


  • 2.  RE: package cache

    Posted Wed January 06, 2021 02:38 AM
    Hi Guy,

    The number of executions shown in the DMC does not come directly from the raw value of the snapshot, but rather the increment value over the selected period (Latest is the last 5min by default). And it is reasonable that the number of execution from 10 to 9 after a refresh, the 9 comes from the delta value of latest collection.

    ------------------------------
    KAI DING
    ------------------------------

    Original Message


  • 3.  RE: package cache

    Posted Thu January 07, 2021 07:44 PM
    Hi Guy

    The number of executions shown in the DMC does not come directly from the raw value of the snapshot, but rather the increment value over the selected period (Latest is the last 5min by default).  And it is reasonable that the number of execution from 10 to 9 after a refresh, the 9 comes from the delta value of latest collection.

    ------------------------------
    Rui Li
    ------------------------------

    Original Message


Related Content