IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

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


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
josephvincentd
Warnings : 1

New User


Joined: 19 May 2005
Posts: 15

PostPosted: Fri Dec 02, 2005 3:02 pm
Reply with quote

hi,

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

regards

vincent
Back to top
View user's profile Send private message
sarojini

New User


Joined: 08 Dec 2005
Posts: 10
Location: India

PostPosted: Sat Dec 10, 2005 1:20 am
Reply with quote

1.in db2 alter modify command is worked or not.if it is working please send the answer?
Back to top
View user's profile Send private message
senthilssg

New User


Joined: 09 Dec 2005
Posts: 64
Location: USA

PostPosted: Mon Dec 12, 2005 12:18 pm
Reply with quote

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 .
Back to top
View user's profile Send private message
senthilssg

New User


Joined: 09 Dec 2005
Posts: 64
Location: USA

PostPosted: Mon Dec 12, 2005 12:20 pm
Reply with quote

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''
Back to top
View user's profile Send private message
iknow

Active User


Joined: 22 Aug 2005
Posts: 411
Location: Colarado, US

PostPosted: Mon Dec 12, 2005 12:52 pm
Reply with quote

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.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts VSAM BUFFER SPACE? CICS 17
No new posts Receommendations required for adding ... JCL & VSAM 5
No new posts Migrating Java application from JVM p... CICS 0
No new posts Pool Overflow in Mainframe ADABASE Java & MQSeries 4
No new posts Buffer limit reached while handling h... COBOL Programming 32
Search our Forums:

Back to Top