Version : DB2 V9.7 FP4
Environment: Single partitioned
OS level : AIX 6.1
We are performing load test on database to determine how much load database can handle. Before the start of the test CPU usage on the server was 10-15%. But at one point during the test, I could see 100 application in executing state on database end and CPU reaching 100%.
I would like to know how would be measure CPU used by each application. This is to findout the applications which are using most of the CPU and tune them to reduce the query response times and thereby reducing the CPU usage.
Is this the right approach. Can someone please shed light and let me know how do we determine CPU used by each db2 application.