473,378 Members | 1,391 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,378 software developers and data experts.

DBHEAP configuration for buffer pool size

In a DB2 V8.1 performance tuning document from a 3rd party vendor, I
found this statement. Can anyone verify this?

"DB2 requires 100 bytes of memory for every buffer pool and extended
storage page that is allocated to a database for use as a descriptor
in the database heap, so the size of the DBHEAP configuration
parameter should be considered before creating large buffer pools. For
example, a 1 gigabyte buffer pool with a page size of 4 KB will
require approximately 25 megabytes of database heap memory to store
the 262,144 descriptors required by the buffer pool."
Nov 12 '05 #1
3 5395
Mark ... this was true in V7.x ... but is "not" true in V8.x since we now use memory pools
in V8.x rather than the old memory model in V7.x.
Some details that may help you ... at a very high level (meaning not all possibilities
have been listed):

For Version 7

In bytes:

(logbufsz * 4K)

+ (catalogcache_sz * 4K)

+ 8K per table space

+ 4K per table

+ 100 bytes per page of Extended Storage

For Version 8

In bytes:

(logbufsz * 4K)

+ 10K per table space

+ 4K per table

+ ( 1K + 4*extents used ) per range clustered table (RCT)

This is documented (and more) at:
http://www-1.ibm.com/support/docview...=utf-8&lang=en
--

Bob
Engagement Specialist - DB2 Information Management Software - IBM Software Group
IBM Toronto Lab
[My comments are solely my own and are not meant to represent an official IBM position -
ask my cat!]

"Mark" <m0****@yahoo.com> wrote in message
news:a5**************************@posting.google.c om...
In a DB2 V8.1 performance tuning document from a 3rd party vendor, I
found this statement. Can anyone verify this?

"DB2 requires 100 bytes of memory for every buffer pool and extended
storage page that is allocated to a database for use as a descriptor
in the database heap, so the size of the DBHEAP configuration
parameter should be considered before creating large buffer pools. For
example, a 1 gigabyte buffer pool with a page size of 4 KB will
require approximately 25 megabytes of database heap memory to store
the 262,144 descriptors required by the buffer pool."

Nov 12 '05 #2
"Bob [IBM]" <Bo******@canada.com> wrote in message
news:2s*************@uni-berlin.de...
Mark ... this was true in V7.x ... but is "not" true in V8.x since we now use memory pools in V8.x rather than the old memory model in V7.x.
Some details that may help you ... at a very high level (meaning not all possibilities have been listed):

For Version 7

In bytes:

(logbufsz * 4K)

+ (catalogcache_sz * 4K)

+ 8K per table space

+ 4K per table

+ 100 bytes per page of Extended Storage

For Version 8

In bytes:

(logbufsz * 4K)

+ 10K per table space

+ 4K per table

+ ( 1K + 4*extents used ) per range clustered table (RCT)

This is documented (and more) at:
http://www-1.ibm.com/support/docview...=utf-8&lang=en --

Bob
Engagement Specialist - DB2 Information Management Software - IBM Software Group IBM Toronto Lab


Thank you for the link. So even for version 7, then the 100 bytes per page
only applies to the use of extended storage for buffer pools?

I don't understand why this stuff is not documented in the manual
("Administration Guide: Performance").
Nov 12 '05 #3
same topic but not same question : what's the advantages of bufferpools in
estore mode ?

Thanks

seb

"Mark A" <no****@nowhere.com> a écrit dans le message de
news:Oj************@news.uswest.net...
"Bob [IBM]" <Bo******@canada.com> wrote in message
news:2s*************@uni-berlin.de...
Mark ... this was true in V7.x ... but is "not" true in V8.x since we now
use memory pools
in V8.x rather than the old memory model in V7.x.
Some details that may help you ... at a very high level (meaning not all possibilities
have been listed):

For Version 7

In bytes:

(logbufsz * 4K)

+ (catalogcache_sz * 4K)

+ 8K per table space

+ 4K per table

+ 100 bytes per page of Extended Storage

For Version 8

In bytes:

(logbufsz * 4K)

+ 10K per table space

+ 4K per table

+ ( 1K + 4*extents used ) per range clustered table (RCT)

This is documented (and more) at:

http://www-1.ibm.com/support/docview...=utf-8&lang=en --

Bob
Engagement Specialist - DB2 Information Management Software - IBM

Software Group
IBM Toronto Lab


Thank you for the link. So even for version 7, then the 100 bytes per page
only applies to the use of extended storage for buffer pools?

I don't understand why this stuff is not documented in the manual
("Administration Guide: Performance").

Nov 12 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

8
by: Tron Thomas | last post by:
As part of applying for a programming position at a company, I recently I had submitted some code samples to one of the developers for review. This is the feedback I received: One of his...
7
by: eric | last post by:
Hi there, BP hit ratio = 1 - (BP physical reads / BP logical reads). If all the BP physical reads are asynchronous, it should mean that the pages are brought up to the bufferpool before the...
36
by: xixi | last post by:
hi, we are using db2 udb v8.1 on windows, i try to use the configuration advisor to get recommendation on the parameter setting, at first, i give the target memory for DB2 is 80% of the physical...
11
by: Issam | last post by:
Hello all, I am trying to change a db2 configuration parameter from within my jdbc code. When I use the following: Statement stmt2 = con.createStatement(); stmt2.executeUpdate( "update db cfg...
2
by: Kush | last post by:
Hi. I am kind of new to DB2 and to this newsgroup so please bear with me.. My question is: IBM installation creates 250 4k bufferpools by default. I want to increase this number to 1000, no...
6
by: Angel Tsankov | last post by:
Hi, I remember reading in a book (or in an article) that the optmial buffer growth factor is about 1.6. Now I need to find this book but I can't remember its title. Can someone help me with this?
4
by: Patrick Finnegan | last post by:
Is there a DB2 setting that will force a table to be cached in the buffer pool? We have four tables that we want to cache completely in the buffer pool to ensure that all the data is read from...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.