DB2 LUW 8.1 FP14
RedHat AS

In "db2 get snapshot for dynamic sql" output I see (amongst other
things):

Number of executions = 235
Number of compilations = 1
Worst preparation time (ms) = 4
Best preparation time (ms) = 4
....
Total execution time (sec.ms) = 12.540242
Total user cpu time (sec.ms) = 11.250000
Total system cpu time (sec.ms) = 0.500000
Statement text = select dchart from charts where
custom = 'N' and ( (chart_prefix like ?) )

So what I'm seeing here is a parameterized SQL statement that has been
executed 235 times.

My question is about the Total execution time, 12.54 seconds.

This means that this SQL was executed 235 times in 12.54 seconds?
12.54 / 235 = .053

Each execution took, on average, .053 seconds? Five hundredths of a
second? Am I interpreting this correctly?

TIA

aj

On Aug 13, 5:50 am, aj <ron...@mcdonalds.comwrote:

DB2 LUW 8.1 FP14
RedHat AS
>
In "db2 get snapshot for dynamic sql" output I see (amongst other
things):
>
Number of executions = 235
Number of compilations = 1
Worst preparation time (ms) = 4
Best preparation time (ms) = 4
....
Total execution time (sec.ms) = 12.540242
Total user cpu time (sec.ms) = 11.250000
Total system cpu time (sec.ms) = 0.500000
Statement text = select dchart from charts where
custom = 'N' and ( (chart_prefix like ?) )
>
So what I'm seeing here is a parameterized SQL statement that has been
executed 235 times.
>
My question is about the Total execution time, 12.54 seconds.
>
This means that this SQL was executed 235 times in 12.54 seconds?
12.54 / 235 = .053
>
Each execution took, on average, .053 seconds? Five hundredths of a
second? Am I interpreting this correctly?
>
TIA
>
aj

Yes, that is the correct interpretation.

--Jeff