Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

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

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
josephvincentd
Warnings : 1

New User


Joined: 19 May 2005
Posts: 17

PostPosted: Fri Dec 02, 2005 3:02 pm    Post subject: why we are using 32K while mentioning a DB2 Buffer pool
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    Post subject:
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    Post subject:
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    Post subject:
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: 413
Location: Colarado, US

PostPosted: Mon Dec 12, 2005 12:52 pm    Post subject: Re: why we are using 32K while mentioning a DB2 Buffer pool
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    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Pool Overflow in Mainframe ADABASE polymathtarun Java & MQSeries 4 Fri Jun 03, 2016 11:57 am
No new posts Buffer limit reached while handling h... rajendra kalepu COBOL Programming 32 Mon Mar 31, 2014 7:29 pm
No new posts Access to COBOL work file buffer in s... Lukasz.Wojtasiak PL/I & Assembler 5 Tue Apr 16, 2013 6:37 pm
No new posts How to refresh the shared pool / panel? enrico-sorichetti TSO/ISPF 7 Fri Sep 07, 2012 8:09 pm
No new posts Cobol Open Statement & VSAM Buffer kevodaly COBOL Programming 1 Thu Feb 02, 2012 1:07 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us