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 <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> 17.02.2003 03:51 Please respond to "ADSM: Dist Stor Manager" To: [EMAIL PROTECTED] 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. ...