473,322 Members | 1,480 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

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

configuration advisor on buffer pool size

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
36 4266
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
"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
"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
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
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
"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
"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
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
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
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
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
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
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
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
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
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
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
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
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
"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
"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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Larry Trutter | last post by:
Environment: Windows 2000 DB2 Version 8 fixpack 4 I am attempting to use DB2 Configuration Advisor. But when I get to the end of that wizard process (sequentially - I went through all the...
0
by: xixi | last post by:
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...
3
by: Mark | last post by:
In a DB2 V8.1 performance tuning document from a 3rd party vendor, I found this statement. Can anyone verify this? "DB2 requires 100 bytes of memory for every buffer pool and extended storage...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

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.