the above table gives the details of size of pages belonging to diff DB2 objects .
noramally BP0 is used for catalog table space ..
acccording your pagesize of tablespace , you can use corresponding size of buffer pool .
if your tablespace contains page size of 4k , you can use 4k size bufferpool like either BP0 or BP1 0r ..
if your tablespace contains page size of 32k , you can use 32k size bufferpool like either BP32k or BP32k1 0r ..
Index spaces uses 4k size buffer pool only . so u can assign either bp0 or any 4k size buffer pool .
the above table gives the details of size of pages belonging to diff DB2 objects .
noramally BP0 is used for catalog table space ..
acccording your pagesize of tablespace , you can use corresponding size of buffer pool .
if your tablespace contains page size of 4k , you can use 4k size bufferpool like either BP0 or BP1 0r ..
if your tablespace contains page size of 32k , you can use 32k size bufferpool like either BP32k or BP32k1 0r ..
Index spaces uses 4k size buffer pool only . so u can assign either bp0 or any 4k size buffer pool .
Joined: 22 Aug 2005 Posts: 411 Location: Colarado, US
Hi There,
As a follow up to the previous psot, let me add some more points to the above query.
A buffer pool is main storage that is reserved to satisfy the buffering requirements for one or more tablespaces or indexes and is made up of either 4K or 32K pages.
Buffer pools available in db2
Ten 32k size buffer pools and fifty 4k size buffer pools (bp0 to bp49)default buffer pools are bp0,bp1,bp2 & bp32.