Page 1 of 1

Buffer Pool Tuning

PostPosted: Thu Jun 14, 2012 8:53 am
by jaggz
Dear All,

Could anyone please enlighten me the importance of creating the tablespace with BufferPool size of BP0 ? Does it mean if a table space with BP0 would consume more Auxiliary storage when a millions of records are loaded ?

Could anyone please explain me the above fundamental of having BP0 ? Is it good to have BP0 for a small shop ?

Jaggz

Re: Buffer Pool Tuning

PostPosted: Thu Jun 14, 2012 12:21 pm
by GuyC
the 0 in BP0 is not the size, it is just a number.
bufferpool tuning is not something to explain in a forum post.