I've recently added a cron job to collect "dynamic sql snapshot" and got
very excited at some huge numbers until I figure out I should divide

Total execution time (sec.ms) / Number of executions

In the example below, I get 373 sec.ms (1608686319 / 4307732)

Is 373 sec.ms a reasonable number? Is the number of executions too high?
What numbers are considered good / bad? Any other snapshots I should
collect?

Thank you in advance for your suggestion (tomorrow is Friday :)

Number of executions = 4307732
Number of compilations = 2
Worst preparation time (ms) = 59
Best preparation time (ms) = 1
Internal rows deleted = 0
Internal rows inserted = 0
Rows read = 4209772
Internal rows updated = 0
Rows written = 0
Statement sorts = 0
Statement sort overflows = 0
Total sort time = 0
Buffer pool data logical reads = 4230668
Buffer pool data physical reads = 454478
Buffer pool temporary data logical reads = 0
Buffer pool temporary data physical reads = 0
Buffer pool index logical reads = 12995643
Buffer pool index physical reads = 76966
Buffer pool temporary index logical reads = 0
Buffer pool temporary index physical reads = 0
Total execution time (sec.ms) = 1608686319.718094
Total user cpu time (sec.ms) = 494.320000
Total system cpu time (sec.ms) = 4513.890000

Cheers
Ray

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