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

CPU utilization by a certain query

P: n/a
How can we find out CPU utilization at query level (which query is
using how much % of CPU ) when multiple queries are running in
parallel.. against DB2 database on AIX. Is there any utility, tool,
method in DB2 itself which can be used for this OR is there any third
party tool, utility which can be used ?
- Sam

Feb 7 '07 #1
Share this Question
Share on Google+
3 Replies


P: n/a
On Feb 7, 11:36 pm, "Sam Durai" <reachsamdu...@gmail.comwrote:
How can we find out CPU utilization at query level (which query is
using how much % of CPU ) when multiple queries are running in
parallel.. against DB2 database on AIX. Is there any utility, tool,
method in DB2 itself which can be used for this OR is there any third
party tool, utility which can be used ?

- Sam
How about Query Patroller.
You can determine the query cost with that.

Swami

Feb 7 '07 #2

P: n/a
On Feb 7, 11:36 pm, "Sam Durai" <reachsamdu...@gmail.comwrote:
How can we find out CPU utilization at query level (which query is
using how much % of CPU ) when multiple queries are running in
parallel.. against DB2 database on AIX. Is there any utility, tool,
method in DB2 itself which can be used for this OR is there any third
party tool, utility which can be used ?

- Sam
We were facing the same problem in our production environments. But we
have overcome the issue!!
You can create event monitors for statements and then get the CPU
"time". Those when compared relatively will give you an approx picture
of which query is taking how much CPU and then tune those queries
accordingly.

Saurabh

Feb 8 '07 #3

P: n/a
Sam Durai wrote:
How can we find out CPU utilization at query level (which query is
using how much % of CPU ) when multiple queries are running in
parallel.. against DB2 database on AIX. Is there any utility, tool,
method in DB2 itself which can be used for this OR is there any third
party tool, utility which can be used ?
- Sam
Perhaps this utility might help you:
http://members.tripod.com/chuzhoi_files/index.html
Note that it is not an official one. The same might be accomplished
using some monitors.

Regards,
Michael
Feb 8 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.