Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2008
    Posts
    11

    Unanswered: To get query execution time

    Hi,

    Can anyone tel me the equivalent command in DB2 for - "set timing on" option present in Oracle to know the query execution time ?

    I am using DB2 V 8.1

    Thanks,
    Arunvijay

  2. #2
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    Have a look at db2batch
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  3. #3
    Join Date
    Nov 2005
    Location
    IL
    Posts
    557
    time db2-tvf filename
    --
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows

    DB2 v9.7.0.6 os 6.1.0.0

Posting Permissions

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