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
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
Comment