MLN: alter bufferpool on subset of MLNs

[Paul Samundar]

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.

[Rhino]

"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

[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! =-----

[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! =-----