how to get running time of query

[Luke Xu]

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

[Blair Kenneth Adamache]

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

Post by Luke Xu
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