If this is your first visit, be sure to check out the FAQ by clicking the link above.
You may have to register before you can post: click the register link above to proceed.
To start viewing messages, select the forum that you want to visit from the selection below.
we are having some 4 hrs constant load performance tests going on where the final readings comes some what like these
db2 9.1.3
windows
------------
Buffer pool data writes = 21341
Asynchronous pool data page writes = 15711
Buffer pool index writes = 5134841
Asynchronous pool index page writes = 152345
sum of all Bufferpool ~ 2GB
softmax 1000
logfilsz 12000
CHNGPGS_THRESH 25
NUM_IOCLEANERS AUTOMATIC
-------------
even though the % steal is quite low but isn't in our case the page cleaners
are getting fired too aggresively.
can someone please recommend some better cfg
thanks,
but dont you think synch write is happening too often than asynch writes.
i am really bothered because of that. wont delaying cleaning would increase it further ?
check how many page cleaners are active at a time, so u would get an idea..then if u see more steal cleaner triggers..try to increase it...its just a thought..test it thoroughly...