By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,856 Members | 2,004 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,856 IT Pros & Developers. It's quick & easy.

How to get aggregate statistics

P: n/a
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

Oct 29 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
On Oct 29, 4:33 am, Quasar <quas...@gmail.comwrote:
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

Oct 29 '07 #2

P: n/a
On Oct 29, 2:17 pm, Roger <wondering...@gmail.comwrote:
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

Oct 30 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.