Querry Execution time

[nimisha123]

Hey experts

how can display execution time for a query i.e.time lapse between start and end of executing a query
am not using any DB2 tool for querry,,am direclty using command line,,so pelase help me to find any simple syntax
to get execution time
its very urgent ,am in the middle of a performance tuning,,please help me some DBa experts

Thanks

Nimisha

[cburnett]

Nimisha,
You might want to check out the db2batch utility which ships with the product - it will give you this info.