On 4/11/2017 2:24 PM, Blaicher, Christopher Y. wrote:
It has been a while since I worked on DB2, but it is sounding like your buffer pools are too big.
With large memory systems everyone should have all of the production (and, ideally, test systems too) buffer pools define with PGFIX(YES) specified. Even if they are over defined in size. This can *measurably* cut DB2 CPU overhead by eliminating the need to fix and unfix pages for I/O and buffer pool pages will not unexpectedly creep out to AUX if they are not changed for a long time.
Regards, Greg ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
