Hello Filipe,
How much is your virtual CPUs configured ?
What is your hardware P7, P8, P9 ?
Not sure how big and loaded is your DB2 database , but it looks like for database 0.2 Physical CPU is too low .
ON Power 7 smt 4 is enabled by default
Recommended Ratio Entitled (Physical CPU) capacity to virtual 1 :8
Power8 onward
SMT8 is enabled by default
So IBM recommending to reduce virtual CPUs on P8 onwards , so ratio becomes 1: 4
But so far customer are not understanding SMT4 vs SMT8 .. so relying on SAP or DB2 / Oracle's vendors old recommendations .. and asking more virtual CPUs .. ending up with degraded performance .
You can adjust/ increase your CPU's configuration accordingly
- CPU entitledment configured is 0.2
- CPU entitledment consumed is 1.9
- DB2 CPU Usage is 700%,800%, etc.
Thanks,
Afzal Muhammad
IBM Certified AIX System Administrator AIX 6.1
IBM Certfied AIX System Administrator AIX 4.3
IBM Certified WebSphere 6.0 Adminstrator
Red Had Linux 7 Certified System Administrator (RHCSA)
Global pSeries platform services – AIX
Ford Motor Company, Dearborn Michigan
United States of America
Tel: Cell 1-704-492-0586
Email: mafzal10@ford.com