By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,905 Members | 894 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,905 IT Pros & Developers. It's quick & easy.

configuration advisor on buffer pool size

P: n/a
hi, we are using db2 udb v8.1 on windows, i try to use the
configuration advisor to get recommendation on the parameter setting,
at first, i give the target memory for DB2 is 80% of the physical
memory, it gives me a recommendation on bufferpool size, so i accept
the change, later on , i found that i gave too much memory to DB2, so
i change the target lower, but the recommendation doesn't change the
buffer pool size accordingly, why is that? thanks
Nov 12 '05 #1
Share this Question
Share on Google+
36 Replies


P: n/a
Xixi, I believe that when you say it does not change, you are still
looking at the value through the COnfigure Parameters option in the
COntrol Center.
This application, when it opens, snapshots the DB CFG and picks the
values it reads. When you run the Advisor output, you change the actual
file with the immediate or deferred option, and the old value is still
cached and displayed.
If you look at the size of the bp using the Buffer Pools object in the
db drop down on the control center you should see the new value. If
not, just refresh the the buffwer pool object.
Or, if you do not mind, just close the CC and reopen it. Go to the
Configure parameters and you shouyld see your new value.
HTH, Pierre.

xixi wrote:
hi, we are using db2 udb v8.1 on windows, i try to use the
configuration advisor to get recommendation on the parameter setting,
at first, i give the target memory for DB2 is 80% of the physical
memory, it gives me a recommendation on bufferpool size, so i accept
the change, later on , i found that i gave too much memory to DB2, so
i change the target lower, but the recommendation doesn't change the
buffer pool size accordingly, why is that? thanks


--
Pierre Saint-Jacques - Reply to: sesconsjunk at attglobaljunk dot com
Reconstruct address: Remove the two junk and replace at and dot by
their symbols.
IBM DB2 Cerified Solutions Expert - Administration
SES Consultants Inc.

Nov 12 '05 #2

P: n/a
Xixi, I believe that when you say it does not change, you are still
looking at the value through the COnfigure Parameters option in the
COntrol Center.
This application, when it opens, snapshots the DB CFG and picks the
values it reads. When you run the Advisor output, you change the actual
file with the immediate or deferred option, and the old value is still
cached and displayed.
If you look at the size of the bp using the Buffer Pools object in the
db drop down on the control center you should see the new value. If
not, just refresh the the buffwer pool object.
Or, if you do not mind, just close the CC and reopen it. Go to the
Configure parameters and you shouyld see your new value.
HTH, Pierre.

xixi wrote:
hi, we are using db2 udb v8.1 on windows, i try to use the
configuration advisor to get recommendation on the parameter setting,
at first, i give the target memory for DB2 is 80% of the physical
memory, it gives me a recommendation on bufferpool size, so i accept
the change, later on , i found that i gave too much memory to DB2, so
i change the target lower, but the recommendation doesn't change the
buffer pool size accordingly, why is that? thanks


--
Pierre Saint-Jacques - Reply to: sesconsjunk at attglobaljunk dot com
Reconstruct address: Remove the two junk and replace at and dot by
their symbols.
IBM DB2 Cerified Solutions Expert - Administration
SES Consultants Inc.

Nov 12 '05 #3

P: n/a
it doesn't change because the Configuration advisor didn't give a
recommendation value for new buffer pool size just like for other
parameters, cause i could see that. even i close the control center
and reopen it, it still display the size which use 80% memory, not the
new target memory. thanks
Nov 12 '05 #4

P: n/a
it doesn't change because the Configuration advisor didn't give a
recommendation value for new buffer pool size just like for other
parameters, cause i could see that. even i close the control center
and reopen it, it still display the size which use 80% memory, not the
new target memory. thanks
Nov 12 '05 #5

P: n/a
I think I got confused.
If you say it still shows 80% od memory, then it is working as expected.
The Advisor opens on the premise that you are running a dedicated
system, one instance owning one database.
Given that, it will always open recommending using 80% of leftover
memory for the db.
Even if you execute the Advisor recommendations and reopen the Advisor,
the 80 % value will still show up, independent of any choices you made
while choosing and running the advisor output.
I also think, not sure, that if you change the 80% with the slider and
set it to 70% for example, when you reopen the advisor after running it,
it will come and show an 80% value again.
HTH, Pierre.

xixi wrote:
it doesn't change because the Configuration advisor didn't give a
recommendation value for new buffer pool size just like for other
parameters, cause i could see that. even i close the control center
and reopen it, it still display the size which use 80% memory, not the
new target memory. thanks


--
Pierre Saint-Jacques - Reply to: sesconsjunk at attglobaljunk dot com
Reconstruct address: Remove the two junk and replace at and dot by
their symbols.
IBM DB2 Cerified Solutions Expert - Administration
SES Consultants Inc.

Nov 12 '05 #6

P: n/a
I think I got confused.
If you say it still shows 80% od memory, then it is working as expected.
The Advisor opens on the premise that you are running a dedicated
system, one instance owning one database.
Given that, it will always open recommending using 80% of leftover
memory for the db.
Even if you execute the Advisor recommendations and reopen the Advisor,
the 80 % value will still show up, independent of any choices you made
while choosing and running the advisor output.
I also think, not sure, that if you change the 80% with the slider and
set it to 70% for example, when you reopen the advisor after running it,
it will come and show an 80% value again.
HTH, Pierre.

xixi wrote:
it doesn't change because the Configuration advisor didn't give a
recommendation value for new buffer pool size just like for other
parameters, cause i could see that. even i close the control center
and reopen it, it still display the size which use 80% memory, not the
new target memory. thanks


--
Pierre Saint-Jacques - Reply to: sesconsjunk at attglobaljunk dot com
Reconstruct address: Remove the two junk and replace at and dot by
their symbols.
IBM DB2 Cerified Solutions Expert - Administration
SES Consultants Inc.

Nov 12 '05 #7

P: n/a
when i use the configuration advisor, the first screen come up with a
slide bar as target memory 80%, then i take it and finish the rest of
the steps, it gives me recommendation on the bufferpool size , e.g.
4000000 (about 2g) , so i accept it. later on the same server(windows
2003) has to hold app server and the database server at the same time,
and also i have two databases being used under same instance, so i
decided to use the configuration advisor change the target memory, the
first screen still come up with 80% target, i slide the bar to use
40%, finish the rest of steps, then i saw the recommendation for the
bufferpool size doen't change , still 4000000, that is why confusing
me. why the new update on the memory is not reflected?
Nov 12 '05 #8

P: n/a
when i use the configuration advisor, the first screen come up with a
slide bar as target memory 80%, then i take it and finish the rest of
the steps, it gives me recommendation on the bufferpool size , e.g.
4000000 (about 2g) , so i accept it. later on the same server(windows
2003) has to hold app server and the database server at the same time,
and also i have two databases being used under same instance, so i
decided to use the configuration advisor change the target memory, the
first screen still come up with 80% target, i slide the bar to use
40%, finish the rest of steps, then i saw the recommendation for the
bufferpool size doen't change , still 4000000, that is why confusing
me. why the new update on the memory is not reflected?
Nov 12 '05 #9

P: n/a
That the buffer pool value 4000000 (4M pages ???) does not change after
you new specs. has me confused.
Is it really 4,000,000 pages??? That really is 16 GB of memory and
you'd absolutely need t run on a 64 bit system for this.

If you set it at 4MB or 1000 pages then it should not change even if you
only claim 40% of memeory on the second run of your advisor.

Torestate, I do not think that the Advisor changes the 80% claim when it
starts for every time it runs. I do not think that there's a paramater
that will remeber you chose 60% one time, 40% another and so on. It
just comes up with 805 each time and lets you reset.
HTH, Pierre.

xixi wrote:
when i use the configuration advisor, the first screen come up with a
slide bar as target memory 80%, then i take it and finish the rest of
the steps, it gives me recommendation on the bufferpool size , e.g.
4000000 (about 2g) , so i accept it. later on the same server(windows
2003) has to hold app server and the database server at the same time,
and also i have two databases being used under same instance, so i
decided to use the configuration advisor change the target memory, the
first screen still come up with 80% target, i slide the bar to use
40%, finish the rest of steps, then i saw the recommendation for the
bufferpool size doen't change , still 4000000, that is why confusing
me. why the new update on the memory is not reflected?


--
Pierre Saint-Jacques - Reply to: sesconsjunk at attglobaljunk dot com
Reconstruct address: Remove the two junk and replace at and dot by
their symbols.
IBM DB2 Cerified Solutions Expert - Administration
SES Consultants Inc.

Nov 12 '05 #10

P: n/a
That the buffer pool value 4000000 (4M pages ???) does not change after
you new specs. has me confused.
Is it really 4,000,000 pages??? That really is 16 GB of memory and
you'd absolutely need t run on a 64 bit system for this.

If you set it at 4MB or 1000 pages then it should not change even if you
only claim 40% of memeory on the second run of your advisor.

Torestate, I do not think that the Advisor changes the 80% claim when it
starts for every time it runs. I do not think that there's a paramater
that will remeber you chose 60% one time, 40% another and so on. It
just comes up with 805 each time and lets you reset.
HTH, Pierre.

xixi wrote:
when i use the configuration advisor, the first screen come up with a
slide bar as target memory 80%, then i take it and finish the rest of
the steps, it gives me recommendation on the bufferpool size , e.g.
4000000 (about 2g) , so i accept it. later on the same server(windows
2003) has to hold app server and the database server at the same time,
and also i have two databases being used under same instance, so i
decided to use the configuration advisor change the target memory, the
first screen still come up with 80% target, i slide the bar to use
40%, finish the rest of steps, then i saw the recommendation for the
bufferpool size doen't change , still 4000000, that is why confusing
me. why the new update on the memory is not reflected?


--
Pierre Saint-Jacques - Reply to: sesconsjunk at attglobaljunk dot com
Reconstruct address: Remove the two junk and replace at and dot by
their symbols.
IBM DB2 Cerified Solutions Expert - Administration
SES Consultants Inc.

Nov 12 '05 #11

P: n/a
sorry , it should be 400,000 pages, we do run on a 64bit machine.

i change the memory slide bar to 40% of target, the new bufferpool
size doen't change for recommendation, no matter i start the DB2 or
not, i have to manually do the change for bufferpool size i guess. it
is inconvenient.
Nov 12 '05 #12

P: n/a
sorry , it should be 400,000 pages, we do run on a 64bit machine.

i change the memory slide bar to 40% of target, the new bufferpool
size doen't change for recommendation, no matter i start the DB2 or
not, i have to manually do the change for bufferpool size i guess. it
is inconvenient.
Nov 12 '05 #13

P: n/a
Xixi, it is working as expected but not as you expect.
Changing the slider on the Advisor from 80% to 40% affects not only the
size of buffer pools.

What the % means is that you are reserving 40%(or 80%, 60%, ...) for all
of the DB Global Shared Memory.
This includes the DB Heap, Package Cache, Catalog Cache, Locklist,
SortHeapTrhreshold_Share, and so on.
So for a 400,000 pages buffer pool aggregate, you need a DB Heap of
about 16,000 pages. The rest should total 10,000 pages at the very most
which gives you a Global Shared Memory request of about 430,000 pages,
or a little over 1.75 GB for Global Shared Memory.
If you set aside 20% of memory for the OS and its Services plus the DAS
and the instance, and then 40% for Global Shared Memory, then the
leftover 40% will be used for the coordinator agents of your connections.

From prior docs. in tuning, a rough rule of thumb is to allocate 20%
for OS and stuff, then use 65% of leftover memory for buffer pools in an
OLTP system, Or, 50% for buffer pools in a DSS system, in this case the
last 10% should be given to the sortheaps.

HTH, Pierre.

xixi wrote:
sorry , it should be 400,000 pages, we do run on a 64bit machine.

i change the memory slide bar to 40% of target, the new bufferpool
size doen't change for recommendation, no matter i start the DB2 or
not, i have to manually do the change for bufferpool size i guess. it
is inconvenient.


--
Pierre Saint-Jacques - Reply to: sesconsjunk at attglobaljunk dot com
Reconstruct address: Remove the two junk and replace at and dot by
their symbols.
IBM DB2 Cerified Solutions Expert - Administration
SES Consultants Inc.

Nov 12 '05 #14

P: n/a
Xixi, it is working as expected but not as you expect.
Changing the slider on the Advisor from 80% to 40% affects not only the
size of buffer pools.

What the % means is that you are reserving 40%(or 80%, 60%, ...) for all
of the DB Global Shared Memory.
This includes the DB Heap, Package Cache, Catalog Cache, Locklist,
SortHeapTrhreshold_Share, and so on.
So for a 400,000 pages buffer pool aggregate, you need a DB Heap of
about 16,000 pages. The rest should total 10,000 pages at the very most
which gives you a Global Shared Memory request of about 430,000 pages,
or a little over 1.75 GB for Global Shared Memory.
If you set aside 20% of memory for the OS and its Services plus the DAS
and the instance, and then 40% for Global Shared Memory, then the
leftover 40% will be used for the coordinator agents of your connections.

From prior docs. in tuning, a rough rule of thumb is to allocate 20%
for OS and stuff, then use 65% of leftover memory for buffer pools in an
OLTP system, Or, 50% for buffer pools in a DSS system, in this case the
last 10% should be given to the sortheaps.

HTH, Pierre.

xixi wrote:
sorry , it should be 400,000 pages, we do run on a 64bit machine.

i change the memory slide bar to 40% of target, the new bufferpool
size doen't change for recommendation, no matter i start the DB2 or
not, i have to manually do the change for bufferpool size i guess. it
is inconvenient.


--
Pierre Saint-Jacques - Reply to: sesconsjunk at attglobaljunk dot com
Reconstruct address: Remove the two junk and replace at and dot by
their symbols.
IBM DB2 Cerified Solutions Expert - Administration
SES Consultants Inc.

Nov 12 '05 #15

P: n/a
thanks for your quick reply to my email. i think what i try to say is
at the beginning, i want to give DB2 server 80% of memory (includes
you said global memory, db heap, .....), so it gives me
suggestion on the bufferpool size to 400000 pages, and some other
changes on locklist, package heap too, so i accept the changes, now
the bufferpool size is 400000 pages, but it gives me problem since i
have a application server hold on the same machine, i need to give it
memory too, so i decide i should let DB2 has only 40% of total memory,
give 40% memory to application server,
then i change only give DB2 to 40% of memory, but it gives me some
advice on logfilesize change, package cache size, but no advise on the
bufferpool size, so when i look at by control center, the size is
unchanged , i have to manually do it. shouldn't be advise change from
the advisor after i gives different memory request?
Nov 12 '05 #16

P: n/a
thanks for your quick reply to my email. i think what i try to say is
at the beginning, i want to give DB2 server 80% of memory (includes
you said global memory, db heap, .....), so it gives me
suggestion on the bufferpool size to 400000 pages, and some other
changes on locklist, package heap too, so i accept the changes, now
the bufferpool size is 400000 pages, but it gives me problem since i
have a application server hold on the same machine, i need to give it
memory too, so i decide i should let DB2 has only 40% of total memory,
give 40% memory to application server,
then i change only give DB2 to 40% of memory, but it gives me some
advice on logfilesize change, package cache size, but no advise on the
bufferpool size, so when i look at by control center, the size is
unchanged , i have to manually do it. shouldn't be advise change from
the advisor after i gives different memory request?
Nov 12 '05 #17

P: n/a
"xixi" <da****@yahoo.com> wrote in message
news:c0**************************@posting.google.c om...
thanks for your quick reply to my email. i think what i try to say is
at the beginning, i want to give DB2 server 80% of memory (includes
you said global memory, db heap, .....), so it gives me
suggestion on the bufferpool size to 400000 pages, and some other
changes on locklist, package heap too, so i accept the changes, now
the bufferpool size is 400000 pages, but it gives me problem since i
have a application server hold on the same machine, i need to give it
memory too, so i decide i should let DB2 has only 40% of total memory,
give 40% memory to application server,
then i change only give DB2 to 40% of memory, but it gives me some
advice on logfilesize change, package cache size, but no advise on the
bufferpool size, so when i look at by control center, the size is
unchanged , i have to manually do it. shouldn't be advise change from
the advisor after i gives different memory request?


Does the DB2 command
AUTOCONFIGURE USING mem_percent 40 APPLY NONE
suggest different sizes?

Regards
Paul Vernon
Business Intelligence, IBM Global Services

Nov 12 '05 #18

P: n/a
"xixi" <da****@yahoo.com> wrote in message
news:c0**************************@posting.google.c om...
thanks for your quick reply to my email. i think what i try to say is
at the beginning, i want to give DB2 server 80% of memory (includes
you said global memory, db heap, .....), so it gives me
suggestion on the bufferpool size to 400000 pages, and some other
changes on locklist, package heap too, so i accept the changes, now
the bufferpool size is 400000 pages, but it gives me problem since i
have a application server hold on the same machine, i need to give it
memory too, so i decide i should let DB2 has only 40% of total memory,
give 40% memory to application server,
then i change only give DB2 to 40% of memory, but it gives me some
advice on logfilesize change, package cache size, but no advise on the
bufferpool size, so when i look at by control center, the size is
unchanged , i have to manually do it. shouldn't be advise change from
the advisor after i gives different memory request?


Does the DB2 command
AUTOCONFIGURE USING mem_percent 40 APPLY NONE
suggest different sizes?

Regards
Paul Vernon
Business Intelligence, IBM Global Services

Nov 12 '05 #19

P: n/a
one thing i noticed is that i used control center change the
bufferpool size IBMfefaultfb from 437471 to 250000, but the get db cfg
still gives me 437471, so which value DB2 is using? i am confusing
Nov 12 '05 #20

P: n/a
one thing i noticed is that i used control center change the
bufferpool size IBMfefaultfb from 437471 to 250000, but the get db cfg
still gives me 437471, so which value DB2 is using? i am confusing
Nov 12 '05 #21

P: n/a
"xixi" <da****@yahoo.com> wrote in message
news:c0*************************@posting.google.co m...
one thing i noticed is that i used control center change the
bufferpool size IBMfefaultfb from 437471 to 250000, but the get db cfg
still gives me 437471, so which value DB2 is using? i am confusing


If you want to change the bufferpool size, alter each of the bufferpools. Do
not use the default parameter.
Nov 12 '05 #22

P: n/a
"xixi" <da****@yahoo.com> wrote in message
news:c0*************************@posting.google.co m...
one thing i noticed is that i used control center change the
bufferpool size IBMfefaultfb from 437471 to 250000, but the get db cfg
still gives me 437471, so which value DB2 is using? i am confusing


If you want to change the bufferpool size, alter each of the bufferpools. Do
not use the default parameter.
Nov 12 '05 #23

P: n/a
this is what i do, i go to control center, right click buffer pools,
do alter, then change the size. i saw the size changed, but once i db
cfg , i still get the old size value
Nov 12 '05 #24

P: n/a
this is what i do, i go to control center, right click buffer pools,
do alter, then change the size. i saw the size changed, but once i db
cfg , i still get the old size value
Nov 12 '05 #25

P: n/a
xixi,

that's it.

The buffpage is the default if you create a new bufferpool and put a -1 in
the field,
so the bufferpool created will take the buffpage from db cfg.

On the other side, if you create an bufferpool wih a really size, not -1 you
have
a bufferpool with this size.

regards,

Joachim Müller

"xixi" <da****@yahoo.com> schrieb im Newsbeitrag
news:c0**************************@posting.google.c om...
this is what i do, i go to control center, right click buffer pools,
do alter, then change the size. i saw the size changed, but once i db
cfg , i still get the old size value

Nov 12 '05 #26

P: n/a
xixi,

that's it.

The buffpage is the default if you create a new bufferpool and put a -1 in
the field,
so the bufferpool created will take the buffpage from db cfg.

On the other side, if you create an bufferpool wih a really size, not -1 you
have
a bufferpool with this size.

regards,

Joachim Müller

"xixi" <da****@yahoo.com> schrieb im Newsbeitrag
news:c0**************************@posting.google.c om...
this is what i do, i go to control center, right click buffer pools,
do alter, then change the size. i saw the size changed, but once i db
cfg , i still get the old size value

Nov 12 '05 #27

P: n/a
no, i am not creating a new bufferpool, i am change the bufferpool
size of ibmdefaultbf. in control center, you can have option to change
the size, and i saw the size changed immediately , but not under
configuraion parameter buffpage. i still don't understand why they
aren't consistent, i have to restart the instance in order to change
buffpage parameter to make the same as i alter the size of
ibmdefaultbf.
Nov 12 '05 #28

P: n/a
no, i am not creating a new bufferpool, i am change the bufferpool
size of ibmdefaultbf. in control center, you can have option to change
the size, and i saw the size changed immediately , but not under
configuraion parameter buffpage. i still don't understand why they
aren't consistent, i have to restart the instance in order to change
buffpage parameter to make the same as i alter the size of
ibmdefaultbf.
Nov 12 '05 #29

P: n/a
xixi,

if you want to change the db cfg buffpage parameter you have to update

db2 update db cfg for <db-name> using buffpage <size in 4k pages>

and then update the ibmdefaultbp in the CC to -1.

I think you have to stop and start the instance or disconnect all.

regards,
Joachim Müller

"xixi" <da****@yahoo.com> schrieb im Newsbeitrag
news:c0**************************@posting.google.c om...
no, i am not creating a new bufferpool, i am change the bufferpool
size of ibmdefaultbf. in control center, you can have option to change
the size, and i saw the size changed immediately , but not under
configuraion parameter buffpage. i still don't understand why they
aren't consistent, i have to restart the instance in order to change
buffpage parameter to make the same as i alter the size of
ibmdefaultbf.

Nov 12 '05 #30

P: n/a
xixi,

if you want to change the db cfg buffpage parameter you have to update

db2 update db cfg for <db-name> using buffpage <size in 4k pages>

and then update the ibmdefaultbp in the CC to -1.

I think you have to stop and start the instance or disconnect all.

regards,
Joachim Müller

"xixi" <da****@yahoo.com> schrieb im Newsbeitrag
news:c0**************************@posting.google.c om...
no, i am not creating a new bufferpool, i am change the bufferpool
size of ibmdefaultbf. in control center, you can have option to change
the size, and i saw the size changed immediately , but not under
configuraion parameter buffpage. i still don't understand why they
aren't consistent, i have to restart the instance in order to change
buffpage parameter to make the same as i alter the size of
ibmdefaultbf.

Nov 12 '05 #31

P: n/a
so if i only use control center to change the ibmdefaultbf size by
alter, is that enough? do i need to change the buffpage parameter by
doing update db cfg to let them consistent?

"Joachim Mueller" <jom0309@[--spam--]douglas-informatik.de> wrote in message news:<c7**********@news.dtag.de>...
xixi,

if you want to change the db cfg buffpage parameter you have to update

db2 update db cfg for <db-name> using buffpage <size in 4k pages>

and then update the ibmdefaultbp in the CC to -1.

I think you have to stop and start the instance or disconnect all.

regards,
Joachim Müller

"xixi" <da****@yahoo.com> schrieb im Newsbeitrag
news:c0**************************@posting.google.c om...
no, i am not creating a new bufferpool, i am change the bufferpool
size of ibmdefaultbf. in control center, you can have option to change
the size, and i saw the size changed immediately , but not under
configuraion parameter buffpage. i still don't understand why they
aren't consistent, i have to restart the instance in order to change
buffpage parameter to make the same as i alter the size of
ibmdefaultbf.

Nov 12 '05 #32

P: n/a
so if i only use control center to change the ibmdefaultbf size by
alter, is that enough? do i need to change the buffpage parameter by
doing update db cfg to let them consistent?

"Joachim Mueller" <jom0309@[--spam--]douglas-informatik.de> wrote in message news:<c7**********@news.dtag.de>...
xixi,

if you want to change the db cfg buffpage parameter you have to update

db2 update db cfg for <db-name> using buffpage <size in 4k pages>

and then update the ibmdefaultbp in the CC to -1.

I think you have to stop and start the instance or disconnect all.

regards,
Joachim Müller

"xixi" <da****@yahoo.com> schrieb im Newsbeitrag
news:c0**************************@posting.google.c om...
no, i am not creating a new bufferpool, i am change the bufferpool
size of ibmdefaultbf. in control center, you can have option to change
the size, and i saw the size changed immediately , but not under
configuraion parameter buffpage. i still don't understand why they
aren't consistent, i have to restart the instance in order to change
buffpage parameter to make the same as i alter the size of
ibmdefaultbf.

Nov 12 '05 #33

P: n/a
Ian
xixi wrote:
so if i only use control center to change the ibmdefaultbf size by
alter, is that enough? do i need to change the buffpage parameter by
doing update db cfg to let them consistent?


The BUFFPAGE database config parameter is a holdover from DB2 V2.1. It
is used to define the size (number of pages) of any bufferpool IF and
only if the NPAGES value in SYSCAT.BUFFERPOOLS is -1. This applies to
_all_ bufferpools where NPAGES = -1, not just IBMDEFAULTBP.

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----
Nov 12 '05 #34

P: n/a
Ian
xixi wrote:
so if i only use control center to change the ibmdefaultbf size by
alter, is that enough? do i need to change the buffpage parameter by
doing update db cfg to let them consistent?


The BUFFPAGE database config parameter is a holdover from DB2 V2.1. It
is used to define the size (number of pages) of any bufferpool IF and
only if the NPAGES value in SYSCAT.BUFFERPOOLS is -1. This applies to
_all_ bufferpools where NPAGES = -1, not just IBMDEFAULTBP.

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----
Nov 12 '05 #35

P: n/a
"xixi" <da****@yahoo.com> wrote in message
news:c0**************************@posting.google.c om...
so if i only use control center to change the ibmdefaultbf size by
alter, is that enough? do i need to change the buffpage parameter by
doing update db cfg to let them consistent?

Ignore the buffpage parm, and just set each bufferpool the size you want it
with alter bufferpool (or use control center). Just leave buffpage the way
it is.
Nov 12 '05 #36

P: n/a
"xixi" <da****@yahoo.com> wrote in message
news:c0**************************@posting.google.c om...
so if i only use control center to change the ibmdefaultbf size by
alter, is that enough? do i need to change the buffpage parameter by
doing update db cfg to let them consistent?

Ignore the buffpage parm, and just set each bufferpool the size you want it
with alter bufferpool (or use control center). Just leave buffpage the way
it is.
Nov 12 '05 #37

This discussion thread is closed

Replies have been disabled for this discussion.