Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2003
    Location
    Austin, TX, USA
    Posts
    278

    Unanswered: Dynamic Sql Snapshot

    Hi Everyone,

    I have taken a snapshot of dynamic sql being run on a DB2 Database version 8 fixpack 3 on Windows 2000 Machine.

    The snapshot is like this

    Number of executions = 35

    Number of compilations = 0

    Worst preparation time (ms) = 2

    Best preparation time (ms) = 2

    Internal rows deleted = 0

    Internal rows inserted = 0

    Rows read = 3035760

    Internal rows updated = 0

    Rows written = 0

    Statement sorts = 70

    Total execution time (sec.ms) = 21.033072

    Total user cpu time (sec.ms) = 11.750000

    Total system cpu time (sec.ms) = 9.234375

    Statement text = Select name from employee.

    I cannot infer the following

    1. The total execution time for a single query is 21 seconds.

    2. The total execution for executing the query 35 times is 21 seconds.

    Can anyone please explain the relation between Number ot Executions and Total Execution Time.

    I am confused.

    Thanks in advance

    Nitin.

  2. #2
    Join Date
    Jul 2001
    Location
    Bangalore, India
    Posts
    28
    hi,
    the total execution time that you see is the total time taken for total number of executions. So, in order to get exec time for one execution, you need to divide Total Execution time by number of executions and ofcourse, you will get an average value.
    hope this answers your question..
    Ravi

  3. #3
    Join Date
    Jul 2003
    Location
    Austin, TX, USA
    Posts
    278
    Thks ravi,

    My confusion is cleared.

    Regds

    Nitin

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •