Db2 local buffer pool tuning

Daniel Lapp

Db2 local buffer pool tuning
I was recently looking at the IBM class CV950 DB2 9 For Z/OS System Performance Analysis and Tuning and one of the subjects was "Monitor and tune DB2 buffer pools, EDM pool, logging and IRLM execution". Should I take that to mean the tuning of bufferpools is the DB2 System programmer's responsibility ?

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

Carol Anne Sutfin

Re: Db2 local buffer pool tuning
(in response to Daniel Lapp)
Daniel
That depends on the definition of DBA at your installation.

Title does not determine the things you are responsible for, only the
knowledge you have.
Just be kind and let everyone else know what you are doing to the buffer
pools.

Carol Sutfin
Corporate DBA
Regions Financial Corp.
(205)261-5214
[login to unmask email]



From: Daniel Lapp <[login to unmask email]>
To: [login to unmask email]
Date: 01/12/2011 02:06 PM
Subject: [DB2-L] Db2 local buffer pool tuning
Sent by: IDUG DB2-L <[login to unmask email]>



I was recently looking at the IBM class CV950 DB2 9 For Z/OS System
Performance Analysis and Tuning and one of the subjects was "Monitor and
tune DB2 buffer pools, EDM pool, logging and IRLM execution". Should I
take that to mean the tuning of bufferpools is the DB2 System programmer's
responsibility ?

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 *
http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2
information. *
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is
the home of IDUG's Listserv

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

Daniel Lapp

Re: Db2 local buffer pool tuning
(in response to Carol Anne Sutfin)
I was asking because it appears IBM considers it a System Programming
function. I haven;t looked so it may also be a topic in the DBA classes as
well.

On Wed, Jan 12, 2011 at 3:28 PM, <[login to unmask email]> wrote:

> Daniel
> That depends on the definition of DBA at your installation.
>
> Title does not determine the things you are responsible for, only the
> knowledge you have.
> Just be kind and let everyone else know what you are doing to the buffer
> pools.
>
> Carol Sutfin
> Corporate DBA
> Regions Financial Corp.
> (205)261-5214
> [login to unmask email]
>
>
>
> From: Daniel Lapp <[login to unmask email]>
> To: [login to unmask email]
> Date: 01/12/2011 02:06 PM
> Subject: [DB2-L] Db2 local buffer pool tuning
> Sent by: IDUG DB2-L <[login to unmask email]>
>
>
>
> I was recently looking at the IBM class CV950 DB2 9 For Z/OS System
> Performance Analysis and Tuning and one of the subjects was "Monitor and
> tune DB2 buffer pools, EDM pool, logging and IRLM execution". Should I
> take that to mean the tuning of bufferpools is the DB2 System programmer's
> responsibility ?
>
> _____________________________________________________________________
> * IDUG North America * Anaheim, California * May 2-6 2011 *
> http://IDUG.ORG/NA *
> * Your only source for independent, unbiased, and trusted DB2
> information. *
> ** The best DB2 technical sessions in the world
> ** Independent, not-for-profit, User Run - the IDUG difference!
> _____________________________________________________________________
>
> If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is
> the home of IDUG's Listserv
>
> _____________________________________________________________________
> * IDUG North America * Anaheim, California * May 2-6 2011 *
> http://IDUG.ORG/NA *
> * Your only source for independent, unbiased, and trusted DB2
> information. *
> ** The best DB2 technical sessions in the world
> ** Independent, not-for-profit, User Run - the IDUG difference!
> _____________________________________________________________________
>
> If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is
> the home of IDUG's Listserv
>



--
Dan Lapp
"The lapper"

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

Fred Edgar

Re: Db2 local buffer pool tuning
(in response to Daniel Lapp)
At our shop we, (DBAs), do both the system programming and the DBA
stuff. However we don't do data modeling. I guess we're more of the
System DBA types. We do the bufferpool tuning as there is no one else
to do it.

--- On Wed, 1/12/11, Daniel Lapp <[login to unmask email]> wrote:

> From: Daniel Lapp <[login to unmask email]>
> Subject: [DB2-L] Db2 local buffer pool tuning
> To: [login to unmask email]
> Date: Wednesday, January 12, 2011, 2:06 PM
> I was recently looking at the IBM
> class CV950 DB2 9 For Z/OS System  Performance Analysis
> and Tuning and one of the subjects was "Monitor and tune DB2
> buffer pools, EDM pool, logging and IRLM execution". 
> Should I take that to mean the tuning of bufferpools is the
> DB2 System programmer's responsibility ?
>
> _____________________________________________________________________
> * IDUG North America * Anaheim, California * May 2-6 2011
> *  http://IDUG.ORG/NA *
> *   Your only source for independent,
> unbiased, and trusted DB2 information.   *
> **    The best DB2 technical sessions in the
> world
> **    Independent, not-for-profit, User Run - the
> IDUG difference!
> _____________________________________________________________________
>
> If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of
> IDUG's Listserv
>




_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

Max Scarpa

Re: Db2 local buffer pool tuning
(in response to Fred Edgar)
In good old days yes it was, but now, with shrinking of teams where a
sysprog is a DBA and sometimes more (as it was my case), it could be
considered a 'DB2 sysDBA' duty. And a z/OS sysprog duty as well, who has
to provide real storage to back up DB2 BPs :-)

Max Scarpa

Groucho Marx's SQL analysis: "Error -904 means 'resource unavailable' or
'my head aches'"

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** DB2 certification -> no additional charge
** Meet fellow DB2 users and leading DB2 consultants
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

Adam Baldwin

Re: Db2 local buffer pool tuning
(in response to Max Scarpa)
Hi Daniel. "Monitor and tune DB2 buffer pools" - responsibility of DBAs or Sysprogs? As always.... one could say that it depends. There are various aspects of buffer pool tuning, some of which are more "DBA" related and some of which are more "Sysprog" related.
For instance, one side of BP tuning relates to the placement of specific objects - tablespaces or indexes - in specific buffer pools. This depends on how objects are accessed, their importance from an application perspective, the nature of the data etc. Knowledge of the application is not necessarily something that a Sysprog will have. A DBA is more likely to know that TABLEX contains frequently access static data and should ideally always be in memory.

Once a BP strategy has been defined - BPs for sequentially accessed objects, randomly accessed, etc etc there remains the ongoing task of monitoring and tuning those buffer pools. E.g. A buffer pool designed to keep critical lookup tables in memory that starts to have a lot of synchronous I/O needs looking at. That is something that a Sysprog might well be looking at.

So, buffer pool tuning is likely to require knowledge of both the application and the subsystem. I would want a DBA to be aware that TABLEX is accessed read only, nearly always sequentially and that the data is only ever modified via LOAD and I would expect the DBA to define the object to an appropriate BP. I wouldn't necessarily expect that DBA to specify the various buffer pool thresholds for that BP.

Cheers, Adam


_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** DB2 certification -> no additional charge
** Meet fellow DB2 users and leading DB2 consultants
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

Robert Knight

Re: Db2 local buffer pool tuning
(in response to Adam Baldwin)
I have been in numerous shops where the sys prog did the work and at times the DBA did the work.



I was also in sites where everything was in BP0 and without a monitor.



Other sites had buffer pools defined with 20000 and only 3 active buffers.



So basically my opinion is this: if you can tune it and get better performance than by all means do it.



If you have a monitor great you should be able to make the recommendations to a sys prog if they are responsible.



If you don't have a monitor which some shops don't then it's the best guess or split up by size and data type (index or space) into their own pools. At least with the display bufferpool report you can at least deteremine the sync/async writes are above 5.



Just an opinion.



Bob Knight





-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Daniel Lapp
Sent: Wednesday, January 12, 2011 3:07 PM
To: [login to unmask email]
Subject: [DB2-L] Db2 local buffer pool tuning



I was recently looking at the IBM class CV950 DB2 9 For Z/OS System Performance Analysis and Tuning and one of the subjects was "Monitor and tune DB2 buffer pools, EDM pool, logging and IRLM execution". Should I take that to mean the tuning of bufferpools is the DB2 System programmer's responsibility ?



_____________________________________________________________________

* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *

* Your only source for independent, unbiased, and trusted DB2 information. *

** The best DB2 technical sessions in the world

** Independent, not-for-profit, User Run - the IDUG difference!

_____________________________________________________________________



If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** DB2 certification -> no additional charge
** Meet fellow DB2 users and leading DB2 consultants
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

Max Scarpa

Re: Db2 local buffer pool tuning
(in response to Robert Knight)
I'd add:

I did this tuning but once we did it and we sent new instructions about
new bufferpools structure usage. Unfortunately DBA who were in charge to
create in prod DB2 objects never read that doc (bufferpool what ???) so
after few months I find again ALL new tablespaces using BP0/BP1 (depending
on the example they got first in their library.....) so at the very end it
was useless for new objects. We had to beat DBAs/programmers first and
then writing a tool to check bufferpool were correct before going into
production :-( , just to be sure. We got some benefits, but in that case
tuning should have been enclosed in a wider, system-tuning plan (WLM in
primis).

Just one examples from trenches.

Max Scarpa
'Nemo propheta in patria'


IDUG DB2-L <[login to unmask email]> wrote on 13/01/2011 12.42.26:

> From: Robert Knight <[login to unmask email]>
> To: [login to unmask email]
> Date: 13/01/2011 12.45
> Subject: Re: [DB2-L] Db2 local buffer pool tuning
> Sent by: IDUG DB2-L <[login to unmask email]>
>
> I have been in numerous shops where the sys prog did the work and at
> times the DBA did the work.
>
> I was also in sites where everything was in BP0 and without a monitor.
>
> Other sites had buffer pools defined with 20000 and only 3 active
buffers.
>
> So basically my opinion is this: if you can tune it and get better
> performance than by all means do it.
>
> If you have a monitor great you should be able to make the
> recommendations to a sys prog if they are responsible.
>
> If you don’t have a monitor which some shops don’t then it’s the
> best guess or split up by size and data type (index or space) into
> their own pools. At least with the display bufferpool report you can
> at least deteremine the sync/async writes are above 5.
>
> Just an opinion.
>
> Bob Knight
>
>
> -----Original Message-----
> From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Daniel Lapp
> Sent: Wednesday, January 12, 2011 3:07 PM
> To: [login to unmask email]
> Subject: [DB2-L] Db2 local buffer pool tuning
>
> I was recently looking at the IBM class CV950 DB2 9 For Z/OS System
> Performance Analysis and Tuning and one of the subjects was "Monitor
> and tune DB2 buffer pools, EDM pool, logging and IRLM execution".
> Should I take that to mean the tuning of bufferpools is the DB2
> System programmer's responsibility ?
>
> _____________________________________________________________________
> * IDUG North America * Anaheim, California * May 2-6 2011 * http://
> IDUG.ORG/NA *
> * Your only source for independent, unbiased, and trusted DB2
> information. *
> ** The best DB2 technical sessions in the world
> ** Independent, not-for-profit, User Run - the IDUG difference!
> _____________________________________________________________________
>
> If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L
> is the home of IDUG's Listserv
>

> [image removed]
> The IDUG DB2-L Listserv is only part of your membership in IDUG. If
> you are not already an IDUG member, please register here.

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** DB2 certification -> no additional charge
** Meet fellow DB2 users and leading DB2 consultants
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

Cathy Taddei

Re: Db2 local buffer pool tuning
(in response to Max Scarpa)
We do it the way Adam described -- DBA's define the characteristics of bufferpools (index, data, random vs. sequential, vendor tools, etc.) then assign tables to them. The systems programmer (me) assigns pages to the pools and monitors their health, making adjustments when warranted. I also monitor memory usage and paging for the box as a whole, since I directly affect it by assigning pages to bufferpools, and paging can be devastating to system response time.

Cathy

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Adam Baldwin
Sent: Thursday, January 13, 2011 1:04 AM
To: [login to unmask email]
Subject: Re: [DB2-L] Db2 local buffer pool tuning

Hi Daniel. "Monitor and tune DB2 buffer pools" - responsibility of DBAs or Sysprogs? As always.... one could say that it depends. There are various aspects of buffer pool tuning, some of which are more "DBA" related and some of which are more "Sysprog" related.
For instance, one side of BP tuning relates to the placement of specific objects - tablespaces or indexes - in specific buffer pools. This depends on how objects are accessed, their importance from an application perspective, the nature of the data etc. Knowledge of the application is not necessarily something that a Sysprog will have. A DBA is more likely to know that TABLEX contains frequently access static data and should ideally always be in memory.

Once a BP strategy has been defined - BPs for sequentially accessed objects, randomly accessed, etc etc there remains the ongoing task of monitoring and tuning those buffer pools. E.g. A buffer pool designed to keep critical lookup tables in memory that starts to have a lot of synchronous I/O needs looking at. That is something that a Sysprog might well be looking at.

So, buffer pool tuning is likely to require knowledge of both the application and the subsystem. I would want a DBA to be aware that TABLEX is accessed read only, nearly always sequentially and that the data is only ever modified via LOAD and I would expect the DBA to define the object to an appropriate BP. I wouldn't necessarily expect that DBA to specify the various buffer pool thresholds for that BP.

Cheers, Adam


_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** DB2 certification -> no additional charge
** Meet fellow DB2 users and leading DB2 consultants
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** DB2 certification -> no additional charge
** Meet fellow DB2 users and leading DB2 consultants
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

Raymond Bell

Re: Db2 local buffer pool tuning
(in response to Cathy Taddei)
...or you could do it the easy way and let a tool do it for you, based on the observed behavioural characteristics (sounds like a psychometric evaluation, don't it?) of the objects and the processes that touch them. Better than trying to model the objects; put things in pools (and modify the attributes of the pools too) based on observation, not estimation. And I wouldn't necessarily trust someone that says, 'Oh, this ol' thing? It's purely random read-only access.' Is it? They might be wrong. Or they might be right - today; what about next week? Next month? Objects change their behaviour over time. I used to be a womaniser. These days... er, OK, so maybe the analogy doesn't hold up, but you get the idea. ;o)

Anyway, skirting with danger again here, and obviously a vested interest, but I'd go with a decent bufferpool analysis tool and let it work it out.

Cheers,


Raymond

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Taddei, Cathy
Sent: 13 January 2011 17:14
To: [login to unmask email]
Subject: Re: [DB2-L] Db2 local buffer pool tuning

We do it the way Adam described -- DBA's define the characteristics of bufferpools (index, data, random vs. sequential, vendor tools, etc.) then assign tables to them. The systems programmer (me) assigns pages to the pools and monitors their health, making adjustments when warranted. I also monitor memory usage and paging for the box as a whole, since I directly affect it by assigning pages to bufferpools, and paging can be devastating to system response time.

Cathy

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Adam Baldwin
Sent: Thursday, January 13, 2011 1:04 AM
To: [login to unmask email]
Subject: Re: [DB2-L] Db2 local buffer pool tuning

Hi Daniel. "Monitor and tune DB2 buffer pools" - responsibility of DBAs or Sysprogs? As always.... one could say that it depends. There are various aspects of buffer pool tuning, some of which are more "DBA" related and some of which are more "Sysprog" related.
For instance, one side of BP tuning relates to the placement of specific objects - tablespaces or indexes - in specific buffer pools. This depends on how objects are accessed, their importance from an application perspective, the nature of the data etc. Knowledge of the application is not necessarily something that a Sysprog will have. A DBA is more likely to know that TABLEX contains frequently access static data and should ideally always be in memory.

Once a BP strategy has been defined - BPs for sequentially accessed objects, randomly accessed, etc etc there remains the ongoing task of monitoring and tuning those buffer pools. E.g. A buffer pool designed to keep critical lookup tables in memory that starts to have a lot of synchronous I/O needs looking at. That is something that a Sysprog might well be looking at.

So, buffer pool tuning is likely to require knowledge of both the application and the subsystem. I would want a DBA to be aware that TABLEX is accessed read only, nearly always sequentially and that the data is only ever modified via LOAD and I would expect the DBA to define the object to an appropriate BP. I wouldn't necessarily expect that DBA to specify the various buffer pool thresholds for that BP.

Cheers, Adam


_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** DB2 certification -> no additional charge
** Meet fellow DB2 users and leading DB2 consultants
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** DB2 certification -> no additional charge
** Meet fellow DB2 users and leading DB2 consultants
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** DB2 certification -> no additional charge
** Meet fellow DB2 users and leading DB2 consultants
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

Ted MacNEIL

Re: Db2 local buffer pool tuning
(in response to Raymond Bell)
>The systems programmer (me) assigns pages to the pools

I find that an interesting statement, since z/OS does not allow the 'assignment' of pages.
There was storage isolation before Goal Mode, and Memory Critical around OS/390 2.7.

Could you please explain what you mean by the above?

-
Ted MacNEIL
[login to unmask email]

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** DB2 certification -> no additional charge
** Meet fellow DB2 users and leading DB2 consultants
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

Cathy Taddei

Re: Db2 local buffer pool tuning
(in response to Ted MacNEIL)
-ALTER BUFFERPOOL(name) VPSIZE(number)

That's all I meant. I could have said "allocate pages" but you could come back with a similar question. I cannot communicate precisely enough if I have to account for the most narrow interpretation of every possible word.

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Ted MacNEIL
Sent: Thursday, January 13, 2011 10:40 AM
To: [login to unmask email]
Subject: Re: [DB2-L] Db2 local buffer pool tuning

>The systems programmer (me) assigns pages to the pools

I find that an interesting statement, since z/OS does not allow the 'assignment' of pages.
There was storage isolation before Goal Mode, and Memory Critical around OS/390 2.7.

Could you please explain what you mean by the above?

-
Ted MacNEIL
[login to unmask email]

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** DB2 certification -> no additional charge
** Meet fellow DB2 users and leading DB2 consultants
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

Philip Gunning

Re: Db2 local buffer pool tuning
(in response to Cathy Taddei)
Thanks for the clarification Cathy :)
Sent via BlackBerry by AT&T

-----Original Message-----
From: "Taddei, Cathy" <[login to unmask email]>
Sender: IDUG DB2-L <[login to unmask email]>
Date: Thu, 13 Jan 2011 13:14:21
To: <[login to unmask email]>
Reply-To: IDUG DB2-L <[login to unmask email]>
Subject: Re: [DB2-L] Db2 local buffer pool tuning

-ALTER BUFFERPOOL(name) VPSIZE(number)

That's all I meant. I could have said "allocate pages" but you could come back with a similar question. I cannot communicate precisely enough if I have to account for the most narrow interpretation of every possible word.

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Ted MacNEIL
Sent: Thursday, January 13, 2011 10:40 AM
To: [login to unmask email]
Subject: Re: [DB2-L] Db2 local buffer pool tuning

>The systems programmer (me) assigns pages to the pools

I find that an interesting statement, since z/OS does not allow the 'assignment' of pages.
There was storage isolation before Goal Mode, and Memory Critical around OS/390 2.7.

Could you please explain what you mean by the above?

-
Ted MacNEIL
[login to unmask email]

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** DB2 certification -> no additional charge
** Meet fellow DB2 users and leading DB2 consultants
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** DB2 certification -> no additional charge
** Meet fellow DB2 users and leading DB2 consultants
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

Ted MacNEIL

Re: Db2 local buffer pool tuning
(in response to Philip Gunning)
>That's all I meant. I could have said "allocate pages" but you could come back with a similar question.
>I cannot communicate precisely enough if I have to account for the most narrow interpretation of every possible word.

I'm sorry but I didn't realise that I was making a narrow interpretation.
Allocating virtual storage is a lot different than what you originally stated.
I needed to understand what you meant.

-
Ted MacNEIL
[login to unmask email]

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** DB2 certification -> no additional charge
** Meet fellow DB2 users and leading DB2 consultants
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

Avram Friedman

Re: Db2 local buffer pool tuning
(in response to Ted MacNEIL)
Whoes responsibility varies greatly from shop to shop.
It could be a systems programmer, dba, performance / capacity team, operations staff, etc etc.

More importantly monitoring is usually automated detection of critical conditions and correction is ideally quite rare.

Historically adjustments required a restart and it was a rare restart that included a correction to buffer pool sizes.
Now timing is easier but newer change control process keep adjustments in the rare catagory, perhaps even less often than what occured in the days where restart was required.

Let me ask, how often do you tune up your car? Is it also a case of automaticly monitoring for exceptions and rare adjustments?
Why?

There has always been a major mis-match between the intensity people claim in looking after turning issues and the reality of the situation

These are what I think the driving forces are
1. The desire for stability and the risk of change.
2. Do as little as possible, I think most famous DB2 advocates were shocked to learn that many shops did not routinly do runstats and rebinds even with version upgrades.
In the same light I was always shocked by the teams that insisted on complex access path comparisons for version upgrades but did not have a clean plan table
3. Remeember many DB2 tunable resources like pools are shared by many instances of what ever the target object is. They are system resources not user resources. User performace problems are best handled by application teams and usually by application code. There is no DB2 go fast for accounts payable. DB2 does not even know what accounts payable is or how it compares to anything else.

Regards
Avram Friedman

On Wed, 12 Jan 2011 15:06:38 -0500, Daniel Lapp <[login to unmask email]> wrote:

>I was recently looking at the IBM class CV950 DB2 9 For Z/OS System Performance Analysis and Tuning and one of the subjects was "Monitor and tune DB2 buffer pools, EDM pool, logging and IRLM execution". Should I take that to mean the tuning of bufferpools is the DB2 System programmer's responsibility ?
>
>_____________________________________________________________________
>* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
>* Your only source for independent, unbiased, and trusted DB2 information. *
>** The best DB2 technical sessions in the world
>** Independent, not-for-profit, User Run - the IDUG difference!
>_____________________________________________________________________
>
>If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** DB2 certification -> no additional charge
** Meet fellow DB2 users and leading DB2 consultants
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

Avram Friedman

Re: Db2 local buffer pool tuning
(in response to Avram Friedman)
On Thu, 13 Jan 2011 08:44:52 +0100, Max Scarpa <[login to unmask email]> wrote:

And a z/OS sysprog duty as well, who has
>to provide real storage to back up DB2 BPs :-)
>
>Max Scarpa
>
>Groucho Marx's SQL analysis: "Error -904 means 'resource unavailable' or
>'my head aches'"
>

I thought it was all virtual anyway.

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** DB2 certification -> no additional charge
** Meet fellow DB2 users and leading DB2 consultants
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

Avram Friedman

Re: Db2 local buffer pool tuning
(in response to Avram Friedman)
Good point Ted
Page is one of those words that is defined in many diffrent ways.
In the z/os world Page can not be well understood with out defining frame and slot.
In DB2 not only does page mean something else but the terms frame and slot are meaningless

In DB2 V8 and above DB2 buffer pool pages, page prefixes or both can obtionally be long term page fixed by sub pool.
Its one of those tunning knobs.

Avram Friedman

On Thu, 13 Jan 2011 18:39:51 +0000, Ted MacNEIL <[login to unmask email]> wrote:

>>The systems programmer (me) assigns pages to the pools
>
>I find that an interesting statement, since z/OS does not allow the 'assignment' of pages.
>There was storage isolation before Goal Mode, and Memory Critical around OS/390 2.7.
>
>Could you please explain what you mean by the above?
>
>-
>Ted MacNEIL
>[login to unmask email]
>
>_____________________________________________________________________
>* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
>* If you are going to attend only one conference this year, this is it! *
>** DB2 certification -> no additional charge
>** Meet fellow DB2 users and leading DB2 consultants
>_____________________________________________________________________
>
>If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** DB2 certification -> no additional charge
** Meet fellow DB2 users and leading DB2 consultants
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

Daniel Lapp

Re: Db2 local buffer pool tuning
(in response to Avram Friedman)
Ah, Raymond's comments I can really sink my teeth into ! Some folks swear
they know exactly how every object is used, abused, accessed, etc... But I
have a hard time believing that after what I've seen over my almost thirty
years in this business. A good tool would certainly help with understanding
and trending how the objects were really being used over time and could help
to adjust for it. Even in small shops there can be thousands of objects,
shops using ERP software are good examples. I would venture to guess the
investment in a decent tool easily outweighs the expense of a person's time
and effort to manually try to guess at how the pools should be managed;
especially if one or two objects are incorrectly placed in a pool.

Oh well, the world would be an entirely different place if I was in charge
:-)

On Thu, Jan 13, 2011 at 12:49 PM, Bell, Raymond <[login to unmask email]>wrote:

> ...or you could do it the easy way and let a tool do it for you, based on
> the observed behavioural characteristics (sounds like a psychometric
> evaluation, don't it?) of the objects and the processes that touch them.
> Better than trying to model the objects; put things in pools (and modify
> the attributes of the pools too) based on observation, not estimation. And
> I wouldn't necessarily trust someone that says, 'Oh, this ol' thing? It's
> purely random read-only access.' Is it? They might be wrong. Or they
> might be right - today; what about next week? Next month? Objects change
> their behaviour over time. I used to be a womaniser. These days... er, OK,
> so maybe the analogy doesn't hold up, but you get the idea. ;o)
>
> Anyway, skirting with danger again here, and obviously a vested interest,
> but I'd go with a decent bufferpool analysis tool and let it work it out.
>
> Cheers,
>
>
> Raymond
>
> -----Original Message-----
> From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Taddei, Cathy
> Sent: 13 January 2011 17:14
> To: [login to unmask email]
> Subject: Re: [DB2-L] Db2 local buffer pool tuning
>
> We do it the way Adam described -- DBA's define the characteristics of
> bufferpools (index, data, random vs. sequential, vendor tools, etc.) then
> assign tables to them. The systems programmer (me) assigns pages to the
> pools and monitors their health, making adjustments when warranted. I also
> monitor memory usage and paging for the box as a whole, since I directly
> affect it by assigning pages to bufferpools, and paging can be devastating
> to system response time.
>
> Cathy
>
> -----Original Message-----
> From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Adam Baldwin
> Sent: Thursday, January 13, 2011 1:04 AM
> To: [login to unmask email]
> Subject: Re: [DB2-L] Db2 local buffer pool tuning
>
> Hi Daniel. "Monitor and tune DB2 buffer pools" - responsibility of DBAs or
> Sysprogs? As always.... one could say that it depends. There are various
> aspects of buffer pool tuning, some of which are more "DBA" related and some
> of which are more "Sysprog" related.
> For instance, one side of BP tuning relates to the placement of specific
> objects - tablespaces or indexes - in specific buffer pools. This depends on
> how objects are accessed, their importance from an application perspective,
> the nature of the data etc. Knowledge of the application is not necessarily
> something that a Sysprog will have. A DBA is more likely to know that TABLEX
> contains frequently access static data and should ideally always be in
> memory.
>
> Once a BP strategy has been defined - BPs for sequentially accessed
> objects, randomly accessed, etc etc there remains the ongoing task of
> monitoring and tuning those buffer pools. E.g. A buffer pool designed to
> keep critical lookup tables in memory that starts to have a lot of
> synchronous I/O needs looking at. That is something that a Sysprog might
> well be looking at.
>
> So, buffer pool tuning is likely to require knowledge of both the
> application and the subsystem. I would want a DBA to be aware that TABLEX is
> accessed read only, nearly always sequentially and that the data is only
> ever modified via LOAD and I would expect the DBA to define the object to an
> appropriate BP. I wouldn't necessarily expect that DBA to specify the
> various buffer pool thresholds for that BP.
>
> Cheers, Adam
>
>
> _____________________________________________________________________
> * IDUG North America * Anaheim, California * May 2-6 2011 *
> http://IDUG.ORG/NA *
> * If you are going to attend only one conference this year, this is it!
> *
> ** DB2 certification -> no additional charge
> ** Meet fellow DB2 users and leading DB2 consultants
> _____________________________________________________________________
>
> If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is
> the home of IDUG's Listserv
>
> _____________________________________________________________________
> * IDUG North America * Anaheim, California * May 2-6 2011 *
> http://IDUG.ORG/NA *
> * If you are going to attend only one conference this year, this is it!
> *
> ** DB2 certification -> no additional charge
> ** Meet fellow DB2 users and leading DB2 consultants
> _____________________________________________________________________
>
> If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is
> the home of IDUG's Listserv
>
> _____________________________________________________________________
> * IDUG North America * Anaheim, California * May 2-6 2011 *
> http://IDUG.ORG/NA *
> * If you are going to attend only one conference this year, this is it!
> *
> ** DB2 certification -> no additional charge
> ** Meet fellow DB2 users and leading DB2 consultants
> _____________________________________________________________________
>
> If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is
> the home of IDUG's Listserv
>



--
Dan Lapp
"The lapper"

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** DB2 certification -> no additional charge
** Meet fellow DB2 users and leading DB2 consultants
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

Joel Goldstein

Db2 local buffer pool tuning
(in response to Daniel Lapp)
Amen Daniel...

Joel


Joel Goldstein
Responsive Systems
IBM Gold Consultant
Buffer Pool Tool for DB2, the worldwide industry standard
Performance software that works...... Predicts IO Rate !!
Predicts Group Buffer Pool performance too
www.responsivesystems.com

Buffer Pool Tool for DB2 on www.LinkedIn.com
Watch the 3-Minute Buffer Pool Tool Movie at:
www.responsivesystems.com/Movie1

tel. (732) 972-1261
fax.(732) 972-9416

----- Original Message -----
From: Daniel Lapp
Newsgroups: bit.listserv.db2-l
To: [login to unmask email]
Sent: Thursday, January 13, 2011 10:50 PM
Subject: Re: [DB2-L] Db2 local buffer pool tuning


Ah, Raymond's comments I can really sink my teeth into ! Some folks swear
they know exactly how every object is used, abused, accessed, etc... But I
have a hard time believing that after what I've seen over my almost thirty
years in this business. A good tool would certainly help with
understanding and trending how the objects were really being used over time
and could help to adjust for it. Even in small shops there can be
thousands of objects, shops using ERP software are good examples. I would
venture to guess the investment in a decent tool easily outweighs the
expense of a person's time and effort to manually try to guess at how the
pools should be managed; especially if one or two objects are incorrectly
placed in a pool.


Oh well, the world would be an entirely different place if I was in charge
:-)



On Thu, Jan 13, 2011 at 12:49 PM, Bell, Raymond <[login to unmask email]>
wrote:

...or you could do it the easy way and let a tool do it for you, based on
the observed behavioural characteristics (sounds like a psychometric
evaluation, don't it?) of the objects and the processes that touch them.
Better than trying to model the objects; put things in pools (and modify
the attributes of the pools too) based on observation, not estimation. And
I wouldn't necessarily trust someone that says, 'Oh, this ol' thing? It's
purely random read-only access.' Is it? They might be wrong. Or they
might be right - today; what about next week? Next month? Objects change
their behaviour over time. I used to be a womaniser. These days... er,
OK, so maybe the analogy doesn't hold up, but you get the idea. ;o)

Anyway, skirting with danger again here, and obviously a vested interest,
but I'd go with a decent bufferpool analysis tool and let it work it out.

Cheers,


Raymond


-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Taddei, Cathy
Sent: 13 January 2011 17:14
To: [login to unmask email]
Subject: Re: [DB2-L] Db2 local buffer pool tuning

We do it the way Adam described -- DBA's define the characteristics of
bufferpools (index, data, random vs. sequential, vendor tools, etc.) then
assign tables to them. The systems programmer (me) assigns pages to the
pools and monitors their health, making adjustments when warranted. I also
monitor memory usage and paging for the box as a whole, since I directly
affect it by assigning pages to bufferpools, and paging can be devastating
to system response time.

Cathy


--------------------------------------------------------------------
mail2web.com – What can On Demand Business Solutions do for you?
http://link.mail2web.com/Business/SharePoint

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** DB2 certification -> no additional charge
** Meet fellow DB2 users and leading DB2 consultants
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

Ted MacNEIL

Re: Db2 local buffer pool tuning
(in response to Joel Goldstein)
>In DB2 V8 and above DB2 buffer pool pages, page prefixes or both can obtionally be long term page fixed by sub pool.

I'm aware of that capability.
I just needed clarification on what was meant by the 'assignment' of pages.

-
Ted MacNEIL
[login to unmask email]

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
_____________________________________________________________________
http://www.IDUG.org/mentor
How can you expand your staff or do succession planning in this economy?
Mentoring is a proven, economical, way to train the next generation of DB2 Users!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

Adam Baldwin

Re: Db2 local buffer pool tuning
(in response to Ted MacNEIL)
I fully agree re the need for a decent monitoring tool and behavioural observation (thanks Doctor Raymond). One has to start somewhere though and I would like to think that the development DBAs have some idea as to how the objects they are creating are going to be used. I'm obviously not yet jaundiced enough despite 23 years of DB2... bring back our one big buffer pool.

tfif.

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
_____________________________________________________________________
http://www.IDUG.org/mentor
How can you expand your staff or do succession planning in this economy?
Mentoring is a proven, economical, way to train the next generation of DB2 Users!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

Mike Bracey

Re: Db2 local buffer pool tuning
(in response to Adam Baldwin)
[AD] What an interesting debate with many excellent points. As has been pointed out previously and like many other performance topics, buffer pool tuning requires input from sys progs, storage administrators, DBAs and application developers.
BTW if I may be so bold having had much positive feedback, and assuming you do not have one of the many excellent tools in the market place, you could try this one, which is no charge:
http://www.redbooks.ibm.com/abstracts/redp4604.html
You will find a rexx tool under additional resources. If you like what you find then please send me an email and I will mail you a later version which also captures data from group buffer pools. The program uses a DISPLAY BUFFERPOOL to capture performance data and then calculates the average page residency time for each pool as defined in the redpaper.

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
_____________________________________________________________________
http://www.IDUG.org/mentor
How can you expand your staff or do succession planning in this economy?
Mentoring is a proven, economical, way to train the next generation of DB2 Users!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

Jay Reavill

Re: Db2 local buffer pool tuning
(in response to Mike Bracey)
Hi Mike,

This tool sounds very interesting, but I'm having trouble getting to the
Additional Resources page and I've checked that I'm using passive FTP.
Would it be possible to put this tool out on the IDUG site? I might
have better luck there.

Thanks,
Jay

------------------------------------------------------------------------
Jay Reavill
DBA
Fidelity National Information Services, Inc.
11601 Roosevelt Blvd., St. Petersburg, FL. 33716
Office: 727-227-2144 | Cell: 727-215-5794
[login to unmask email]
------------------------------------------------------------------------

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Mike Bracey
Sent: Friday, January 14, 2011 4:59 AM
To: [login to unmask email]
Subject: Re: [DB2-L] Db2 local buffer pool tuning

[AD] What an interesting debate with many excellent points. As has been
pointed out previously and like many other performance topics, buffer
pool tuning requires input from sys progs, storage administrators, DBAs
and application developers.
BTW if I may be so bold having had much positive feedback, and assuming
you do not have one of the many excellent tools in the market place, you
could try this one, which is no charge:
http://www.redbooks.ibm.com/abstracts/redp4604.html
You will find a rexx tool under additional resources. If you like what
you find then please send me an email and I will mail you a later
version which also captures data from group buffer pools. The program
uses a DISPLAY BUFFERPOOL to capture performance data and then
calculates the average page residency time for each pool as defined in
the redpaper.

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 *
http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2
information. *
_____________________________________________________________________
http://www.IDUG.org/mentor
How can you expand your staff or do succession planning in this economy?
Mentoring is a proven, economical, way to train the next generation of
DB2 Users!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L
is the home of IDUG's Listserv

_____________

The information contained in this message is proprietary and/or confidential. If you are not the intended recipient, please: (i) delete the message and all copies; (ii) do not disclose, distribute or use the message in any manner; and (iii) notify the sender immediately. In addition, please be aware that any message addressed to our domain is subject to archiving and review by persons other than the intended recipient. Thank you.
_____________

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
_____________________________________________________________________
http://www.IDUG.org/mentor
How can you expand your staff or do succession planning in this economy?
Mentoring is a proven, economical, way to train the next generation of DB2 Users!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

PAUL WALTERS

Re: Db2 local buffer pool tuning
(in response to Jay Reavill)
I have used Mike's REXX and it is an excellent alternative. And the red paper is a great reference.

If you are about to start this process - use all the resources that are available before you spend resource to acquire a product.

As to who should be responsible for buffer pool tuning? Object placement should be more of the responsibility of the application DBA because they should understand the applications they support better than anyone else. Some of actual buffer pool settings should be a shared responsibility. One person should likely establish the master plan for buffer pool usage.

In our environment we had previously just defined buffers based on applications (a new application would just get 2 new buffers). We moved to a usage based buffer pool assignment - it was relatively easy to locate objects that were mostly random or mostly sequential and place them into pools that were tuned to support that type of activity.

During our project - we started with 38 pools and consolidated down to 14 pools and achieved a 20% saving for our environment.


-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Mike Bracey
Sent: Friday, January 14, 2011 4:59 AM
To: [login to unmask email]
Subject: Re: [DB2-L] Db2 local buffer pool tuning

[AD] What an interesting debate with many excellent points. As has been pointed out previously and like many other performance topics, buffer pool tuning requires input from sys progs, storage administrators, DBAs and application developers.
BTW if I may be so bold having had much positive feedback, and assuming you do not have one of the many excellent tools in the market place, you could try this one, which is no charge:
http://www.redbooks.ibm.com/abstracts/redp4604.html
You will find a rexx tool under additional resources. If you like what you find then please send me an email and I will mail you a later version which also captures data from group buffer pools. The program uses a DISPLAY BUFFERPOOL to capture performance data and then calculates the average page residency time for each pool as defined in the redpaper.

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
_____________________________________________________________________
http://www.IDUG.org/mentor
How can you expand your staff or do succession planning in this economy?
Mentoring is a proven, economical, way to train the next generation of DB2 Users!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

This E-Mail has been scanned for viruses.

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
_____________________________________________________________________
http://www.IDUG.org/mentor
How can you expand your staff or do succession planning in this economy?
Mentoring is a proven, economical, way to train the next generation of DB2 Users!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

Raymond Bell

Re: Db2 local buffer pool tuning
(in response to PAUL WALTERS)
Hey Adam,



No offence taken nor, I hope, received. I too hope (including those times when I was one) the Dev DBAs would have some idea as to object behaviour. And the Developers, come to it, but sometimes either they don’t know or the ground changes from under them and the behaviour that was intended, and maybe started out, changed. Think it’s called the Real World. You know, the one behind the blue pill?



Cheers,





Raymond

PS. Take 2 and call me in the morning. This is your Doctor speaking, after all.

PPS. Mike, no need for [AD]; a free REXX is, after all, free. Unless you have to pay for REXX itself?



-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Adam Baldwin
Sent: 14 January 2011 08:25
To: [login to unmask email]
Subject: Re: [DB2-L] Db2 local buffer pool tuning



I fully agree re the need for a decent monitoring tool and behavioural observation (thanks Doctor Raymond). One has to start somewhere though and I would like to think that the development DBAs have some idea as to how the objects they are creating are going to be used. I'm obviously not yet jaundiced enough despite 23 years of DB2... bring back our one big buffer pool.



tfif.



_____________________________________________________________________

* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *

* Your only source for independent, unbiased, and trusted DB2 information. *

_____________________________________________________________________

http://www.IDUG.org/mentor

How can you expand your staff or do succession planning in this economy?

Mentoring is a proven, economical, way to train the next generation of DB2 Users!

_____________________________________________________________________



If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
_____________________________________________________________________
http://www.IDUG.org/mentor
How can you expand your staff or do succession planning in this economy?
Mentoring is a proven, economical, way to train the next generation of DB2 Users!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

Adam Baldwin

Re: Db2 local buffer pool tuning
(in response to Raymond Bell)
Doctor Raymond, an interesting choice of prescription - the "blue pill". What are you trying to tell us?

Cheers, Adam

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
_____________________________________________________________________
http://www.IDUG.org/mentor
How can you expand your staff or do succession planning in this economy?
Mentoring is a proven, economical, way to train the next generation of DB2 Users!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

Max Scarpa

Re: Db2 local buffer pool tuning
(in response to Adam Baldwin)
> it’s called the Real World. You know, the one behind the blue pill?

Interesting Friday prescription, with the weekend coming. BTW nothing
against headaches Dr. Raymond ?

Max Scarpa

Destroyed by XML




_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
_____________________________________________________________________
http://www.IDUG.org/mentor
How can you expand your staff or do succession planning in this economy?
Mentoring is a proven, economical, way to train the next generation of DB2 Users!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

Lynne Flatley

Re: Db2 local buffer pool tuning
(in response to Max Scarpa)
It's reference to the movie, The Matrix... ;-)

On Fri, Jan 14, 2011 at 10:11 AM, Adam Baldwin <[login to unmask email]>wrote:

> Doctor Raymond, an interesting choice of prescription - the "blue pill".
> What are you trying to tell us?
>
> Cheers, Adam
>
> _____________________________________________________________________
> * IDUG North America * Anaheim, California * May 2-6 2011 *
> http://IDUG.ORG/NA *
> * Your only source for independent, unbiased, and trusted DB2
> information. *
> _____________________________________________________________________
> http://www.IDUG.org/mentor
> How can you expand your staff or do succession planning in this economy?
> Mentoring is a proven, economical, way to train the next generation of DB2
> Users!
> _____________________________________________________________________
>
> If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is
> the home of IDUG's Listserv
>

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
_____________________________________________________________________
http://www.IDUG.org/mentor
How can you expand your staff or do succession planning in this economy?
Mentoring is a proven, economical, way to train the next generation of DB2 Users!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

Max Scarpa

Re: Db2 local buffer pool tuning
(in response to Lynne Flatley)
Really ? Matrix movie ? I thought Doctor 'Calegari' Bell referred to other
movies.

Sorry Raymond and shame on me.

Max Scarpa


_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
_____________________________________________________________________
http://www.IDUG.org/mentor
How can you expand your staff or do succession planning in this economy?
Mentoring is a proven, economical, way to train the next generation of DB2 Users!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

Mike Bracey

Re: Db2 local buffer pool tuning
(in response to Max Scarpa)
[AD]As requested, I have just added V3.2 of the rexx buffer pool monitoring tool, file DBPRESV32.zip, to the IBM Developerworks files website:
https://www.ibm.com/developerworks/mydeveloperworks/files/app?lang=en#/person/270003F953/file/d7c1eead-cd74-40c9-9236-a03a7cc71933
A description should be added in a day or two by the administrators. Any feedback welcome.

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** DB2 certification -> no additional charge
** Meet fellow DB2 users and leading DB2 consultants
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv