By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,286 Members | 1,290 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,286 IT Pros & Developers. It's quick & easy.

Query Execution Time

P: n/a
Hello all,

I installed the trial version of DB2 UDB 8.2, I was wondering, how can
I determine the exact execution time (in miliseconds not timerons) for
a specific query ?

Thank you very much.

Awaiting your response.

Best Regards,
Salem

Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
UnixSlaxer wrote:
Hello all,

I installed the trial version of DB2 UDB 8.2, I was wondering, how can
I determine the exact execution time (in miliseconds not timerons) for
a specific query ?

Thank you very much.

Awaiting your response.

Best Regards,
Salem

There is a tool called db2batch which works like the command line.
It sorts out compile and execution time.
I presume you are not expecting DB2 to "predict" the execution time.
That does not exist.

Cheers
Serge
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.