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.  DMC 3.1.5 - Query execution time

    Posted 07/08/21 04:06 PM
    We have configured recently DMC 3.1.5 and pulled report for last 12 hrs. The metrics shows as below for query execution time. So, how to read and understand this? 

    For each execution how much time its taking and the units of it? (is it in ms/sec/min ?)
    Top 10 statements
    Longest running queries

    Top 10
    SQL statement
    Query execution time
    CPU time
    Executions
    1
    insert into OVN.USERTABLEPART16K (CREATE_DATE,YCSB_KEY, FIELD0)...
    		 2d:09:41:57.157 03:24:54.316 207,858,056


    ------------------------------
    Krishna Rao Murakonda
    ------------------------------

    #Db2


  • 2.  RE: DMC 3.1.5 - Query execution time

    Posted 07/09/21 05:38 AM
    Hi Krishna,

    It is a formatted representation of time. Query execution time is 2d:09:41:57.157, means that the time is 2 days, 9 hours, 41 minutes, 57 seconds and 157 milliseconds.

    In your example, this SQL  statement was executed 207,858,056 times over the last 12 hours, for a total query execution time of more than two days, each execution takes 2d:09:41:57.157 / 207,858,056, about 1ms. And CPU time is the same.


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



  • 3.  RE: DMC 3.1.5 - Query execution time

    Posted 07/09/21 12:56 PM
    Hi Rui,

    Thanks for the explanation, sounds good. 

    Wonder if there is a way for us to get the historical avg, min and max execution time(s) for a query in DMC.

    ------------------------------
    Krishna Rao Murakonda
    ------------------------------

    Original Message


  • 4.  RE: DMC 3.1.5 - Query execution time

    Posted 07/09/21 11:49 AM

    My "wild" guess would be 2 Days, 9 Hours, 41 Minutes, 57 Seconds 157/1000 sec...

    :-)



    ------------------------------
    Jan Nelken
    ------------------------------



  • 5.  RE: DMC 3.1.5 - Query execution time

    Posted 07/09/21 12:58 PM
    Thanks Jan.

    ------------------------------
    Krishna Rao Murakonda
    ------------------------------

    Original Message


Related Content