DB2 V8 performance

[LinuAIX]

Hi All,

We just upgraded our data warehouse from DB2 v7.X to v8. Our run queue on a 6 way S80 used to hit 9 on really really busy days. This is the joy I have now:

15 9 1269628 1072 0 0 0 724 2865 0 3195 46039 20488 67 33 0 0
39 3 1269638 1057 0 0 0 3422 14300 0 3203 42630 17431 71 29 0 0
18 7 1269639 1167 0 0 0 4958 20804 0 4606 43843 25740 67 32 0 0
22 9 1269642 1174 0 0 0 3568 12509 0 3063 43917 16890 77 22 0 0
43 7 1269652 1060 0 0 0 3679 14500 0 3611 47168 20345 67 32 0 1
39 8 1269652 1096 0 0 0 5051 23138 0 4921 54956 31172 57 41 0 2
29 10 1269652 1067 0 0 0 4648 21610 0 4429 48987 23528 65 35 0 0
25 10 1269652 1103 0 0 0 5203 26902 0 4896 54448 29522 56 42 0 2
29 7 1269652 1054 0 0 0 5511 24543 0 5113 53145 28833 59 40 0 1
19 10 1269652 1052 0 0 0 4079 15373 0 4288 48214 24515 65 34 0 1
30 6 1269652 1067 0 0 0 4800 15615 0 4370 51781 27425 65 31 0 4
32 8 1269652 1080 0 0 0 3552 11726 0 3703 47253 20588 72 28 0 0
17 4 1269652 1165 0 0 0 5084 25599 0 4447 51383 26102 62 37 0 1
17 9 1269652 1117 0 0 0 4334 14761 0 4221 46353 21814 70 30 0 0
35 9 1269652 1132 0 0 0 5088 13003 0 4407 58472 29070 58 41 0 2
21 6 1269652 1097 0 0 0 4301 8716 0 4284 53154 25114 65 35 0 0
18 8 1269664 1108 0 0 0 4250 10574 0 4316 51588 23041 61 39 0 0
13 11 1269679 1047 0 0 0 4701 9540 0 4871 57171 29222 56 42 0 2
10 18 1269686 1071 0 0 0 4523 10836 0 4710 64524 28087 52 45 0 3

Anybody else run into this. We had a time last week when the system was locked up for all intent and purpose. The run queue hit 110 once while I was watching. Thanks,

Larry

 

[theycallmetim]

There are quite a few bugs in db2 v8. Make sure you have the latest fixpak installed (5). What level of AIX are you running?

Looks like you have a very active memory system there. Most of your CPU time may be spent in scanning/freeing pages. Do you have tprof installed?

run tprof -x sleep 60. Take a look at either sleep.prof or __prof.all (depending on AIX level) See what is using the most cpu.

 

[LinuAIX]

Thanks for the reply Tim, is that Tim The Enchanter!

Our DB2 dude installed the latest fixpack so that is not it... I'll kick off a tprof and see what that yields...