Sorry, fingers were faster than brain.

bufpoolsize option is in kB, while "Buffer Pool Pages" output of "q db
f=d" is in 4kB pages. Therefore DB bufferpool might be occupying only 25%
of the real memory + up to 40% for file buffers ==> memory contention
might not have place.

Zlatko Krastev
IT Consultant






Zlatko Krastev/ACIT <acit AT ATTGLOBAL DOT NET>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
17.02.2003 03:51
Please respond to "ADSM: Dist Stor Manager"


        To:     ADSM-L AT VM.MARIST DOT EDU
        cc:
        Subject:        AIX TSM performance improvement (was Re: OS390 TSM 
Performance questions.)


Arnaud,

--> 6h1 machine, 2Gb memory ...
--> ... I increased bufpoolsize from 151552 to 524288 (where my
performance
problems began)!

512k pages, 4 kB each equals 2 GB. So you left no space for AIX, file
buffers, TSM code, etc. Consequences: excessive paging and performance
degradation.

...