Team,

Is there any way to find the each SQL TOTAL run(execution) time.

For example;

db2 'select count(distinct RET) from prod.Xtable'

By running the snapshot for the above SQL I can able to see the start time of this SQL.

How to get the end time.

NO EVENT MONITOR PLEASE.

Thanks,
-R

if you update monitor switches : timestamp - statement
get snapshot .. for dynamic sql
you will see : execution time...

You could use the db2batch utility to run your query - it will report preparation and execution times.