Buffer Pool Tuning
Posted: Thu Jun 14, 2012 8:53 am
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
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