Bufferpools

Canvas Botha

Bufferpools
When a threshold on a bufferpool is exceeded, does it apply to that
indivdual bufferpool or to all the bufferpools system wide (IWTH in
particular)? Does this also apply to the group bufferpools in a data
sharing environment?



Mike Turner

Re: Bufferpools
(in response to Canvas Botha)
The thresholds only affect the one bufferpool for which they are triggered.
Other bufferpools within the member DB2 subsystem are not affected. Local
bufferpools in other member DB2 subsystems are not affected. Group
bufferpools are not directly affected, though the processing against them
may be impacted by the different processing pattern in the affected local
bufferpool.

Regards
Mike Turner
Email: [login to unmask email]
Homepage: http://ourworld.compuserve.com/homepages/michael_turner

Message text written by DB2 Data Base Discussion List
>When a threshold on a bufferpool is exceeded, does it apply to that
indivdual bufferpool or to all the bufferpools system wide (IWTH in
particular)? Does this also apply to the group bufferpools in a data
sharing environment?<



craig patton

Re: Bufferpools
(in response to Mike Turner)
Canvas,

In the deep past of DB2, when 1 bufferpool went critical, all bufferpools
went critical. This was changed many releases ago (back when we only had 4
bufferpools). In todays DB2, when a single bufferpool goes critical, the
other pools do NOT go critical with it.

I am mostly sure that Group bufferpools do not go critical when a local BP
goes critical.

HTH,
Craig Patton
DB2 DBA
Patton Research Group, Inc.


>From: Canvas Botha <[login to unmask email]>
>Reply-To: DB2 Data Base Discussion List <[login to unmask email]>
>To: [login to unmask email]
>Subject: Bufferpools
>Date: Thu, 9 Dec 1999 23:08:28 -0800
>
>When a threshold on a bufferpool is exceeded, does it apply to that
>indivdual bufferpool or to all the bufferpools system wide (IWTH in
>particular)? Does this also apply to the group bufferpools in a data
>sharing environment?
>
>
>
>
>

______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com



[login to unmask email]

Re: Bufferpools
(in response to craig patton)
I am not sure about any other thresholds except DMTH as i have not found
about this in any documents. However all the thresholds are maintained
separately (DMTH as well) but reaching DMTH in one pool causes pages not to
be released from other pools as well.

I hope some other answers will give new information to me as well.

Thanks

Sanjeev





Canvas Botha <[login to unmask email]>@RYCI.COM> on 12/10/99 07:08:28 AM

Please respond to DB2 Data Base Discussion List <[login to unmask email]>

Sent by: DB2 Data Base Discussion List <[login to unmask email]>


To: [login to unmask email]
cc:
Subject: Bufferpools


When a threshold on a bufferpool is exceeded, does it apply to that
indivdual bufferpool or to all the bufferpools system wide (IWTH in
particular)? Does this also apply to the group bufferpools in a data
sharing environment?