why we are using 32K while mentioning a DB2 Buffer pool

josephvincentd · New User Joined: 19 May 2005 Posts: 18

hi,

why we are using 32K while mentioning a DB2 Buffer pool.

regards

vincent

sarojini · New User Joined: 08 Dec 2005 Posts: 10 Location: India

1.in db2 alter modify command is worked or not.if it is working please send the answer?

senthilssg · Active User Joined: 09 Dec 2005 Posts: 54

Hi,

There are 4 sizes of Buffer pool
4k,8k,16k,32k sizes,
According to our need only we can either use 4k or 8k or 16 k or 32 k size of bufferpool .

4k page size bufferpool - bp0 t0 bp49 ie totally 50. 4k size bufferpool are available
8k-----------BP8k.BP*k1,..
16K----------BP16k,BP16k1..
32k----------BP32k,BP32k1..

similarly , for each size different nos available . nos of bufferpool for each size varies from version to version

type available page size

tablespace 4k 8k 16k 32k
indexspace 4k
workfile table space 4k 32k

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 .

senthilssg · Active User Joined: 09 Dec 2005 Posts: 54

Hi,

There are 4 sizes of Buffer pool
4k,8k,16k,32k sizes,
According to our need only we can either use 4k or 8k or 16 k or 32 k size of bufferpool .

4k page size bufferpool - bp0 t0 bp49 ie totally 50. 4k size bufferpool are available
8k-----------BP8k.BP*k1,..
16K----------BP16k,BP16k1..
32k----------BP32k,BP32k1..

similarly , for each size different nos available . nos of bufferpool for each size varies from version to version

type available page size

tablespace 4k 8k 16k 32k
indexspace 4k
workfile table space 4k 32k

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 .

Regards,
senthil

''if anything wrong, correct me''

iknow

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.

Hope this helps.