DB2 LUW Buffer Pool Tuning

Bill Gallagher

DB2 LUW Buffer Pool Tuning
Dear List:

Is there an easy way (I know nothing is really easy) to look at DB2
snapshots for buffer pools to determine what percentage of read requests
from the buffer pool are random versus sequential? At first glance I'm
speculating that synchronous reads would typically be random (i.e. one page
at a time) where asynchronous reads would be sequential (i.e. employing
prefetch).

I'm looking at some snapshots, and nothing is really jumping out at me as
being an obvious way to determine random vs. sequential access of
tablespace pages from a bufferpool.

To take it a level deeper, is it possible to get this information at a
tablespace level?

Thanks,

-------------------------------------------------------
Bill Gallagher
Database Administrator
IT / Common Services
Phoenix Life Insurance Company
860-403-6327
[login to unmask email]


*********************************************************************************** CONFIDENTIAL: This communication, including attachments, is intended only for the exclusive use of addressee and may contain proprietary, confidential and/or privileged information. If you are not the intended recipient, you are hereby notified that you have received this document in error, and any use, review, copying, disclosure, dissemination or distribution is strictly prohibited. If you are not the intended recipient, please notify the sender immediately by return e-mail, delete this communication and destroy any and all copies of this communication.

***********************************************************************************

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Joel Goldstein

Re: DB2 LUW Buffer Pool Tuning
(in response to Bill Gallagher)
Bill,

I believe most of the online monitors show you the information you want.
Synch reads are mostly random, except for the read for the first page that
starts SP running.
The monitor should also show you random getpages vs sequential so you can
calc your percentages of access.

Regards,
Joel


----- Original Message -----
From: <[login to unmask email]>
Newsgroups: bit.listserv.db2-l
To: <[login to unmask email]>
Sent: Friday, January 13, 2006 3:22 PM
Subject: [DB2-L] DB2 LUW Buffer Pool Tuning


> Dear List:
>
> Is there an easy way (I know nothing is really easy) to look at DB2
> snapshots for buffer pools to determine what percentage of read requests
> from the buffer pool are random versus sequential? At first glance I'm
> speculating that synchronous reads would typically be random (i.e. one
> page
> at a time) where asynchronous reads would be sequential (i.e. employing
> prefetch).
>
> I'm looking at some snapshots, and nothing is really jumping out at me as
> being an obvious way to determine random vs. sequential access of
> tablespace pages from a bufferpool.
>
> To take it a level deeper, is it possible to get this information at a
> tablespace level?
>
> Thanks,
>
> -------------------------------------------------------
> Bill Gallagher
> Database Administrator
> IT / Common Services
> Phoenix Life Insurance Company
> 860-403-6327
> [login to unmask email]
>
>
> ***********************************************************************************
> CONFIDENTIAL: This communication, including attachments, is intended only
> for the exclusive use of addressee and may contain proprietary,
> confidential and/or privileged information. If you are not the intended
> recipient, you are hereby notified that you have received this document in
> error, and any use, review, copying, disclosure, dissemination or
> distribution is strictly prohibited. If you are not the intended
> recipient, please notify the sender immediately by return e-mail, delete
> this communication and destroy any and all copies of this communication.
>
> ***********************************************************************************
>
> ---------------------------------------------------------------------------------
> Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
> home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page
> select "Join or Leave the list". The IDUG DB2-L FAQ is at
> http://www.idugdb2-l.org. The IDUG List Admins can be reached at
> [login to unmask email] Find out the latest on IDUG conferences
> at http://conferences.idug.org/index.cfm
>

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm