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

CPU Utilization of the queries

P: 27
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
Share this question for a faster answer!
Share on Google+

Post your reply

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