467,185 Members | 1,230 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,185 developers. It's quick & easy.

MLN: alter bufferpool on subset of MLNs

Hi All,
Consider a scenario of (let's say) total of 8 MLNs.

How can I change BP size (which is defined over all of these 8 MLNs)
on one particular node (or subset of nodes). I understand that there
are bunch of way one could achieve this.

1) DB2NODE env variable
2) db2_all "<<+nnn<db2 ALTER BUFFERPOOL ..."
3) db2 ALTER BUFFERPOOL ... DBPARTITIONNUM <db-partition-number>

none of above constructs work for me, whenever I run any of these, it
changes BP size on all nodes. Do you have any suggestions?

Thanks in advance,
-Paul.
Nov 12 '05 #1
  • viewed: 1804
Share:
3 Replies

"Paul Samundar" <sa******@email.com> wrote in message
news:fb**************************@posting.google.c om...
Hi All,
Consider a scenario of (let's say) total of 8 MLNs.

How can I change BP size (which is defined over all of these 8 MLNs)
on one particular node (or subset of nodes). I understand that there
are bunch of way one could achieve this.

1) DB2NODE env variable
2) db2_all "<<+nnn<db2 ALTER BUFFERPOOL ..."
3) db2 ALTER BUFFERPOOL ... DBPARTITIONNUM <db-partition-number>

none of above constructs work for me, whenever I run any of these, it
changes BP size on all nodes. Do you have any suggestions?

I've been working with DB2 for quite a while but I can't for the life of me
think of what you mean by "MLN". Could you possibly spell out this acronym
for us? If other people are also baffled by this acronym, you might not get
an answer for this question....

Rhino
Nov 12 '05 #2
Ian
Paul Samundar wrote:
Hi All,
Consider a scenario of (let's say) total of 8 MLNs.

How can I change BP size (which is defined over all of these 8 MLNs)
on one particular node (or subset of nodes). I understand that there
are bunch of way one could achieve this.

1) DB2NODE env variable
2) db2_all "<<+nnn<db2 ALTER BUFFERPOOL ..."
3) db2 ALTER BUFFERPOOL ... DBPARTITIONNUM <db-partition-number>


#3 is the correct syntax, as in

alter bufferpool mybp dbpartitionnum 3 size 20000;

Once you've done this, it makes an entry in syscat.bufferpoolnodes.

See the ALTER BUFFERPOOL statement documentation for more details.

-----= 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 #3
Ian
Rhino wrote:

I've been working with DB2 for quite a while but I can't for the life of me
think of what you mean by "MLN". Could you possibly spell out this acronym
for us? If other people are also baffled by this acronym, you might not get
an answer for this question....


MLN = Multiple Logical Nodes, as in a EEE system with more than one
partition per phyiscal server.

-----= 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 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

5 posts views Thread by Paul | last post: by
5 posts views Thread by Hemant Shah | last post: by
3 posts views Thread by Gregor =?UTF-8?B?S292YcSN?= | last post: by
reply views Thread by Ian | last post: by
3 posts views Thread by dunleav1 | last post: by
reply views Thread by dot.yet@gmail.com | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.