472,952 Members | 2,161 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,952 software developers and data experts.

how to change the bufferpool size correctly?

hi, we are using db2 udb v8.1 on windows, normally i would use control
center to change bufferpool size since i know the change will be
effect immediately for version 8.1, so i right click bufferpool, do
alter, change the size (to a smaller one), after that , i use the
configuration parameter to check the bufferpool size, it still show
the old value, i close the control center and reopen , still the same,
so is that i must stop the instance in order to pick up the right
value?
Nov 12 '05 #1
10 12828
A bufferpool change won't take effect until a time when there are no
active connections. Is there a refresh option in the Control Center?

xixi wrote:
hi, we are using db2 udb v8.1 on windows, normally i would use control
center to change bufferpool size since i know the change will be
effect immediately for version 8.1, so i right click bufferpool, do
alter, change the size (to a smaller one), after that , i use the
configuration parameter to check the bufferpool size, it still show
the old value, i close the control center and reopen , still the same,
so is that i must stop the instance in order to pick up the right
value?


Nov 12 '05 #2
A bufferpool change won't take effect until a time when there are no
active connections. Is there a refresh option in the Control Center?

xixi wrote:
hi, we are using db2 udb v8.1 on windows, normally i would use control
center to change bufferpool size since i know the change will be
effect immediately for version 8.1, so i right click bufferpool, do
alter, change the size (to a smaller one), after that , i use the
configuration parameter to check the bufferpool size, it still show
the old value, i close the control center and reopen , still the same,
so is that i must stop the instance in order to pick up the right
value?


Nov 12 '05 #3
Blair Adamache <ba*******@2muchspam.yahoo.com> wrote in message news:<c6**********@hanover.torolab.ibm.com>...
A bufferpool change won't take effect until a time when there are no
active connections. Is there a refresh option in the Control Center?


Not strictly true. Changes to the size of a buffer pool default to being IMMEDIATE
unless otherwise specified, or (in the case of an increase in size), the db
shared set isnt big enough to contain the new size.
hi, we are using db2 udb v8.1 on windows, normally i would use control
center to change bufferpool size since i know the change will be
effect immediately for version 8.1, so i right click bufferpool, do
alter, change the size (to a smaller one), after that , i use the
configuration parameter to check the bufferpool size, it still show
the old value, i close the control center and reopen , still the same,
so is that i must stop the instance in order to pick up the right
value?


You make reference to 'configuration parameter' - I presume that you are looking
at the value of BUFFPAGE? This wouldnt change - you havent modified it. BUFFPAGE
only affects buffer pools which have a size listed of -1. See the documentation
for more information

hj
Nov 12 '05 #4
Blair Adamache <ba*******@2muchspam.yahoo.com> wrote in message news:<c6**********@hanover.torolab.ibm.com>...
A bufferpool change won't take effect until a time when there are no
active connections. Is there a refresh option in the Control Center?


Not strictly true. Changes to the size of a buffer pool default to being IMMEDIATE
unless otherwise specified, or (in the case of an increase in size), the db
shared set isnt big enough to contain the new size.
hi, we are using db2 udb v8.1 on windows, normally i would use control
center to change bufferpool size since i know the change will be
effect immediately for version 8.1, so i right click bufferpool, do
alter, change the size (to a smaller one), after that , i use the
configuration parameter to check the bufferpool size, it still show
the old value, i close the control center and reopen , still the same,
so is that i must stop the instance in order to pick up the right
value?


You make reference to 'configuration parameter' - I presume that you are looking
at the value of BUFFPAGE? This wouldnt change - you havent modified it. BUFFPAGE
only affects buffer pools which have a size listed of -1. See the documentation
for more information

hj
Nov 12 '05 #5
so does that means i shouldn't manually change the buffpage parameter
to the same as ibmdefaultbf size?
Nov 12 '05 #6
so does that means i shouldn't manually change the buffpage parameter
to the same as ibmdefaultbf size?
Nov 12 '05 #7
> so does that means i shouldn't manually change the buffpage parameter
to the same as ibmdefaultbf size?


Unless you want to change the size of all bufferpools which have a size of -1
(ie, use BUFFPAGE as the size), then there's no reason to change BUFFPAGE when
you alter the size of ibmdefaultbp

hj
Nov 12 '05 #8
> so does that means i shouldn't manually change the buffpage parameter
to the same as ibmdefaultbf size?


Unless you want to change the size of all bufferpools which have a size of -1
(ie, use BUFFPAGE as the size), then there's no reason to change BUFFPAGE when
you alter the size of ibmdefaultbp

hj
Nov 12 '05 #9
the change of buffpage parameter default is 250, then after i load the
database data, i do a configuration advisor, it recommend change the
buffpage to new value, so i accept it and saw the change affected
buffpage parameter and ibmdefaultbf size, if as you said, buffpage
prameter change only affect bufferpools with a size of -1, why the
configuration adviseo change buffpage parameter? this makes me
confusing since i have thought alter bufferpool size and update db cfg
buffpage is same thing.

go****@zipperup.org (Hildy Johnson) wrote in message news:<2e**************************@posting.google. com>...
so does that means i shouldn't manually change the buffpage parameter
to the same as ibmdefaultbf size?


Unless you want to change the size of all bufferpools which have a size of -1
(ie, use BUFFPAGE as the size), then there's no reason to change BUFFPAGE when
you alter the size of ibmdefaultbp

hj

Nov 12 '05 #10
the change of buffpage parameter default is 250, then after i load the
database data, i do a configuration advisor, it recommend change the
buffpage to new value, so i accept it and saw the change affected
buffpage parameter and ibmdefaultbf size, if as you said, buffpage
prameter change only affect bufferpools with a size of -1, why the
configuration adviseo change buffpage parameter? this makes me
confusing since i have thought alter bufferpool size and update db cfg
buffpage is same thing.

go****@zipperup.org (Hildy Johnson) wrote in message news:<2e**************************@posting.google. com>...
so does that means i shouldn't manually change the buffpage parameter
to the same as ibmdefaultbf size?


Unless you want to change the size of all bufferpools which have a size of -1
(ie, use BUFFPAGE as the size), then there's no reason to change BUFFPAGE when
you alter the size of ibmdefaultbp

hj

Nov 12 '05 #11

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: xixi | last post by:
hi, we are using db2 udb v8.1 on windows, normally i would use control center to change bufferpool size since i know the change will be effect immediately for version 8.1, so i right click...
5
by: Paul | last post by:
Hi, is there any way to know the content of the bufferpool : - space usage not present in snapshot - tables actually cached in and number of pages, same for index ... thx
5
by: Hemant Shah | last post by:
Folks, I am not sure what I am doing wrong, but We have an transaction that does some serious calculation on small chink of data over and over again. It selects few rows from the table...
1
by: Pablo | last post by:
Hi Db2 Administrators.. I have a doubt respect of change in size of bufferpools, I know when change of bufferpool size I must reconfigure the parameter dbhash ... someone has a thumb rule for...
20
by: Hemant Shah | last post by:
Folks, I am using DB2 UDB 8.2 on AIX 5.1. How large of a bufferpool can you create? I tried to create a 4GB bufferpool db2 complained that is cannot allocate enogth memory. I have 16GB on this...
3
by: dotyet | last post by:
Hi Everyone, I am in a very strange situation, and am looking for suggestions to tackle it. I have a 10 gig database on 64-bit windows 2003 running platform. The database has about 5 gigs of...
1
by: Raja Shekar | last post by:
HI Every body , I would like to know whether is it mandatory to give Tablespace page size and Bufferpool page size equal..? i also heard like while creating tablespace if pages size of tablespace...
3
by: dunleav1 | last post by:
In 9.1 and 9.5 (Linux 64 bit) when a buffer pool is set to self- tuning, how are blocks configured in respect to blocked vs non-blocked when self-tuning is set to on? (ie) I have one bufferpool...
0
by: dot.yet | last post by:
Hi Everyone, environment: DB2 9.5 WSE with FP 2a Solaris 10 u5 - 64-bit SMP - 2 Quad CPUS - total 8 cores 16 GB RAM SAMPLE database Solaris Containers
0
by: Mushico | last post by:
How to calculate date of retirement from date of birth
2
by: DJRhino | last post by:
Was curious if anyone else was having this same issue or not.... I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 4 Oct 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
0
by: Aliciasmith | last post by:
In an age dominated by smartphones, having a mobile app for your business is no longer an option; it's a necessity. Whether you're a startup or an established enterprise, finding the right mobile app...
0
tracyyun
by: tracyyun | last post by:
Hello everyone, I have a question and would like some advice on network connectivity. I have one computer connected to my router via WiFi, but I have two other computers that I want to be able to...
2
by: giovanniandrean | last post by:
The energy model is structured as follows and uses excel sheets to give input data: 1-Utility.py contains all the functions needed to calculate the variables and other minor things (mentions...
1
by: Teri B | last post by:
Hi, I have created a sub-form Roles. In my course form the user selects the roles assigned to the course. 0ne-to-many. One course many roles. Then I created a report based on the Course form and...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 1 Nov 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM) Please note that the UK and Europe revert to winter time on...
3
by: nia12 | last post by:
Hi there, I am very new to Access so apologies if any of this is obvious/not clear. I am creating a data collection tool for health care employees to complete. It consists of a number of...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.