469,883 Members | 1,140 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,883 developers. It's quick & easy.

CPU Utilization of the queries

i want to find out the CPU Utilization per application in my DB. The problem is that we have OLTP and DSS transactions happening on the same server and we are not able to convince the client that the CPU utilization is going high because of the DSS queries. If somehow i could get the queries which are fired and the cpu utilization taken by these queries, then i would be able to convince them. I dont know which would be the best way to trap this, as there are may utilities through which I can get the dynamic statements. for ex- db2top, db2pd, SQL table functions, snapshot and event monitors.

We are running UDB 8.2 with DPF.
Jan 2 '07 #1
0 1416

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by Simon Sadedin | last post: by
7 posts views Thread by reachsamdurai | last post: by
3 posts views Thread by Sam Durai | last post: by
reply views Thread by PRR | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.