Env: DB2 8.2 / AIX 5.3
AIX Server hosts only DB2 server and sometimes CPU is more in wait time(around 30%). What could be the reason for this ? How to do PD for this problem ? Any suggestions
Quote:
System configuration: lcpu=16 mem=49151MB
kthr memory page faults cpu
------- --------------------- ------------------------------------ ------------------ -----------
r b avm fre re pi po fr sr cy in sy cs us sy id wa
1 1 6996809 537799 0 0 0 0 0 0 2659 28016 16771 25 7 34 34
3 1 6996530 538078 0 0 0 0 0 0 2618 28705 16402 31 7 31 30
3 1 6996526 538082 0 0 0 0 0 0 2671 28456 16385 30 7 31 31
2 1 6996623 537985 0 0 0 0 0 0 2903 28039 17446 23 7 35 34
5 1 6996805 537803 0 0 0 0 0 0 2824 34250 17257 33 8 30 29
2 1 6996782 537826 0 0 0 0 0 0 3481 57273 18030 33 8 29 29
4 1 6996551 538057 0 0 0 0 0 0 4082 80280 19770 28 8 32 32
2 1 6996600 538008 0 0 0 0 0 0 4056 73073 20226 25 8 34 33
1 0 6996675 537933 0 0 0 0 0 0 3905 70938 19562 25 8 34 33
3 0 6996881 537727 0 0 0 0 0 0 3122 61898 18301 30 8 31 31
|
dBforums
>
CPU Wait Time & DB2 Performance
08-21-09, 12:54
Linear Mode
