Db2

Db2

Where DBAs and data experts come together to stop operating and start innovating. Connect, share, and shape the AI era with us.


#Data


#Data
#Databases
#Operatingsystems
#Db2
#Databasesolutions
 View Only

  • 1.  package cache

    Posted 12/30/20 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 01/06/21 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
    ------------------------------



  • 3.  RE: package cache

    Posted 01/07/21 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
    ------------------------------



Related Content