Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2003
    Posts
    38

    Post Unanswered: Getting sql execution time

    Hi,

    Can you please tell me how to get the execution time of an sql query
    .Although we get the elapsed time from command center, we need to get it at
    db2 command prompt or thru any utility by which we generating a report for
    al the sqls executed.
    In oracle we can easily do by setting envirnoment param on SQL Prompt.
    How to do it in DB2 ?

    Thanks,
    Raj
    Raj Shekhar

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: Getting sql execution time

    If this is for a benchmark , you can use the db2batch command ...

    HTH

    Sathyaram

    Originally posted by Raj Shekhar
    Hi,

    Can you please tell me how to get the execution time of an sql query
    .Although we get the elapsed time from command center, we need to get it at
    db2 command prompt or thru any utility by which we generating a report for
    al the sqls executed.
    In oracle we can easily do by setting envirnoment param on SQL Prompt.
    How to do it in DB2 ?

    Thanks,
    Raj
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

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