UDB 8.2 Win2k3 - Bufferpool Allocation

Travis Bindenagel

UDB 8.2 Win2k3 - Bufferpool Allocation
Hello fellow listers!
I have a question about bufferpool allocation. We have 5 history tables
that are very heavily read, and only about 1% of all I/O is for updates.
Each table is in excess of 10 million rows, with anywhere from 3-7
indexes per table. They also are best suited to 16k bufferpools, base
on row size etc. My question is whether it is best to have 1 larger 16k
bufferpool for all of the tables, or to put them each on their own
moderately sized 16k bp. Are there any accepted guidelines for making
this determination? Apologies if this has been discussed at length
previously. I searched and could not find it in the archives.

Thanks in advance.

Regards,
Travis Bindenagel
DBA/Programmer/Analyst
Education Assistance Corporation

---------------------------------------------------------------------------------
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: UDB 8.2 Win2k3 - Bufferpool Allocation
(in response to Travis Bindenagel)
It's highly unlikely that they should be in separate pools.
Start with one 16K pool, and then tune from there if necessary.

Regards,
Joel

----- Original Message -----
From: "Travis Bindenagel" <[login to unmask email]>
Newsgroups: bit.listserv.db2-l
To: <[login to unmask email]>
Sent: Wednesday, January 11, 2006 1:31 PM
Subject: [DB2-L] UDB 8.2 Win2k3 - Bufferpool Allocation


Hello fellow listers!
I have a question about bufferpool allocation. We have 5 history tables
that are very heavily read, and only about 1% of all I/O is for updates.
Each table is in excess of 10 million rows, with anywhere from 3-7
indexes per table. They also are best suited to 16k bufferpools, base
on row size etc. My question is whether it is best to have 1 larger 16k
bufferpool for all of the tables, or to put them each on their own
moderately sized 16k bp. Are there any accepted guidelines for making
this determination? Apologies if this has been discussed at length
previously. I searched and could not find it in the archives.

Thanks in advance.

Regards,
Travis Bindenagel
DBA/Programmer/Analyst
Education Assistance Corporation

---------------------------------------------------------------------------------
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

Avram Friedman

Re: UDB 8.2 Win2k3 - Bufferpool Allocation
(in response to Joel Goldstein)
Travis
I would suggest you visit www.responsivesystems.com
The company is run by Joel Goldstein who is very active on this list. His buffer pool tools are considered to be industry standard tools.

There are a lot of papers and presentations on his site that discuss all aspects of buffer pool use.



Travis Bindenagel <[login to unmask email]> wrote:
Hello fellow listers!
I have a question about bufferpool allocation. We have 5 history tables
that are very heavily read, and only about 1% of all I/O is for updates.
Each table is in excess of 10 million rows, with anywhere from 3-7
indexes per table. They also are best suited to 16k bufferpools, base
on row size etc. My question is whether it is best to have 1 larger 16k
bufferpool for all of the tables, or to put them each on their own
moderately sized 16k bp. Are there any accepted guidelines for making
this determination? Apologies if this has been discussed at length
previously. I searched and could not find it in the archives.

Thanks in advance.

Regards,
Travis Bindenagel
DBA/Programmer/Analyst
Education Assistance Corporation

---------------------------------------------------------------------------------
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




Avram Friedman
(877)311-0480 Voice Mail
[login to unmask email]
Http://www.IBMsysProg.com




---------------------------------------------------------------------------------
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

Mike Bell

Re: UDB 8.2 Win2k3 - Bufferpool Allocation
(in response to Avram Friedman)
Just remember that your indexes for these tables will still be in 4K
bufferpools. You may want to assign them to a separate bufferpool so you
don't affect the rest of your processing.

Mike
HLS Technologies

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf
Of Travis Bindenagel
Sent: Wednesday, January 11, 2006 12:31 PM
To: [login to unmask email]
Subject: [DB2-L] UDB 8.2 Win2k3 - Bufferpool Allocation

Hello fellow listers!
I have a question about bufferpool allocation. We have 5 history tables
that are very heavily read, and only about 1% of all I/O is for updates.
Each table is in excess of 10 million rows, with anywhere from 3-7
indexes per table. They also are best suited to 16k bufferpools, base
on row size etc. My question is whether it is best to have 1 larger 16k
bufferpool for all of the tables, or to put them each on their own
moderately sized 16k bp. Are there any accepted guidelines for making
this determination? Apologies if this has been discussed at length
previously. I searched and could not find it in the archives.

Thanks in advance.

Regards,
Travis Bindenagel
DBA/Programmer/Analyst
Education Assistance Corporation

----------------------------------------------------------------------------
-----
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

---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.510 / Virus Database: 307 - Release Date: 8/14/2003


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.510 / Virus Database: 307 - Release Date: 8/14/2003


---------------------------------------------------------------------------------
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