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? 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?
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?
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
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
so does that means i shouldn't manually change the buffpage parameter
to the same as ibmdefaultbf size?
so does that means i shouldn't manually change the buffpage parameter
to the same as ibmdefaultbf size?
> 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
> 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
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
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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
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...
|
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
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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
|
by: Mushico |
last post by:
How to calculate date of retirement from date of birth
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
| |