Anindya,

Put this statement before and after your query
db2 values (current timestamp) >> "C:\snapsp.txt"
and dont forget to redirect your output to a file that will capture the time difference,

Thanks,
Amit

On Tue, 18 May 2004 anindya wrote :
>Hi All,
>Do you suggest and Command which will give the present timestamp of
>the server? I would like to use that command before and after the Long
>query to find out the time taken by the Query. I know there is Date() and
>Timestamp() Functions. But these are not commands which will serve my
>purpose.
>For example the format would be...
>
><command to get present time stamp>
><My Query to execute>
><command to get present time stamp again>
>
>Any Idea???
>
>Thank you all.
>
>
>
>
>---------------------------------------------------------------------
>PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
>website: http://www.LazyDBA.com
>To unsubscribe, e-mail: [Email address protected]
>For additional commands, e-mail: [Email address protected]
>


DB2 & UDB email list listserv db2-l LazyDBA home page