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

MLN: alter bufferpool on subset of MLNs

P: n/a
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
Share this Question
Share on Google+
3 Replies


P: n/a

"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

P: n/a
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

P: n/a
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.