Results 1 to 3 of 3

Thread: Sql Run Time

  1. #1
    Join Date
    Sep 2004
    Posts
    111

    Arrow Unanswered: Sql Run Time

    Team,

    Is there any way to find the each SQL TOTAL run(execution) time.

    For example;

    db2 'select count(distinct RET) from prod.Xtable'

    By running the snapshot for the above SQL I can able to see the start time of this SQL.

    How to get the end time.

    NO EVENT MONITOR PLEASE.

    Thanks,
    -R

  2. #2
    Join Date
    Jun 2006
    Posts
    471
    if you update monitor switches : timestamp - statement
    get snapshot .. for dynamic sql
    you will see : execution time...
    Best Regards, Guy Przytula
    DB2 UDB LUW certified V6/7/8

  3. #3
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    You could use the db2batch utility to run your query - it will report preparation and execution times.
    ---
    "It does not work" is not a valid problem statement.

Posting Permissions

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