How to get aggregate statistics

[Quasar]

Good morning :)
I'm trying to get useful performance information from my DB2 v8.2
server on Linux.
I'm asking your help to see if it's possible to have this kind of
report
- Number of queries executed and their execution time (elapsed time).
It'd be an aggregate report, so the same queries should be grouped
together with number of iterations. This will help me to concentrate
with the most complex queries

I've tried with event monitors, adding the statements monitoring, but
I was not able to have aggregate info

Thanks in advance for your help

[Roger]

On Oct 29, 4:33 am, Quasar <[e-mail]:

Good morning :)
I'm trying to get useful performance information from my DB2 v8.2
server on Linux.
I'm asking your help to see if it's possible to have this kind of
report
- Number of queries executed and their execution time (elapsed time).
It'd be an aggregate report, so the same queries should be grouped
together with number of iterations. This will help me to concentrate
with the most complex queries

I've tried with event monitors, adding the statements monitoring, but
I was not able to have aggregate info

Thanks in advance for your help

You can get this information using snapshot for dynamic sqls either
the classic method or the stored procedure method. This will give #
of execution, cpu used, the sql , etc. You can then slice and dice
it the way you want.

Roger

[Quasar]

On Oct 29, 2:17 pm, Roger <[e-mail]:

You can get this information using snapshot for dynamic sqls either
the classic method or the stored procedure method. This will give #
of execution, cpu used, the sql , etc. You can then slice and dice
it the way you want.

Roger

Thx a lot!! Really helpful!

Quasar