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 12523
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 discussion thread is closed Replies have been disabled for this discussion. Similar topics
reply
views
Thread by xixi |
last post: by
|
5 posts
views
Thread by Paul |
last post: by
|
5 posts
views
Thread by Hemant Shah |
last post: by
|
1 post
views
Thread by Pablo |
last post: by
|
20 posts
views
Thread by Hemant Shah |
last post: by
|
3 posts
views
Thread by dotyet |
last post: by
|
1 post
views
Thread by Raja Shekar |
last post: by
|
3 posts
views
Thread by dunleav1 |
last post: by
|
reply
views
Thread by dot.yet |
last post: by
| | | | | | | | | | |