How to get aggregate statistics

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Quasar - 29 Oct 2007 10:33 GMT

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

Reply to this Message

Roger - 29 Oct 2007 14:17 GMT

> Good morning :)
> I'm trying to get useful performance information from my DB2 v8.2
[quoted text clipped - 10 lines]
>
> 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

Reply to this Message

Quasar - 30 Oct 2007 12:56 GMT

> 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

Reply to this Message