Groups > DB2 > DB2 UDB > Re: how to get running time of query




how to get running time of query

how to get running time of query
Wed, 6 Feb 2008 10:45:49 -0500
When I use DB2 Command Editor to run query, the tool shows a windows with 
running time. However, when the query completes, the window is gone. How do 
I know how long it takes to run the query?

Thank you

Luke

Post Reply
Re: how to get running time of query
Wed, 06 Feb 2008 12:29:44 -050
Have a look at db2batch for performance testing with queries - search 
here on db2batch - there are many helpful topics:

http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/index.jsp

Luke Xu wrote:
> When I use DB2 Command Editor to run query, the tool shows a windows with 
> running time. However, when the query completes, the window is gone. How do

> I know how long it takes to run the query?
> 
> Thank you
> 
> Luke
> 
Post Reply
about | contact