473,320 Members | 2,083 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,320 software developers and data experts.

DB2 UDB 7.x BufferPool change

Hi Db2 Administrators..
I have a doubt respect of change in size of bufferpools, I know when
change of bufferpool size I must reconfigure the parameter dbhash ...
someone has a thumb rule for calculate this value ?

Thanks in advance

PID
Nov 12 '05 #1
1 1498
"Pablo" <th************@gmail.com> wrote in message
news:ct**********@news1.nivel5.cl...
Hi Db2 Administrators..
I have a doubt respect of change in size of bufferpools, I know when change of bufferpool size I must reconfigure the parameter dbhash ...
someone has a thumb rule for calculate this value ?
Thanks in advance

PID


Not sure what you are talking about with regard to dbhash. What OS are you
using?

Change the bufferpool size with alter bufferpool.

The total of all bufferpools in all active databases on your server should
be about 50% - 75% of the real memory available on that machine (Linux,
UNIX, Windows). You need to have real memory available for bufferpools.

However, if you use 32 bit DB2 on LUW, you are limited by your OS as to how
much memory can be allocated to DB2. This varies from about 1 GB to 1.75 GB
total (bufferpools plus other DB2 memory), but there are a few exceptions.

Nov 12 '05 #2

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

Similar topics

10
by: xixi | last post by:
hi, we are using db2 udb v8.1 on windows, normally i would use control center to change bufferpool size since i know the change will be effect immediately for version 8.1, so i right click...
5
by: Paul | last post by:
Hi, is there any way to know the content of the bufferpool : - space usage not present in snapshot - tables actually cached in and number of pages, same for index ... thx
3
by: Paul Samundar | last post by:
Hi All, Consider a scenario of (let's say) total of 8 MLNs. How can I change BP size (which is defined over all of these 8 MLNs) on one particular node (or subset of nodes). I understand that...
1
by: Christian Berg | last post by:
Hi, I have got a problem with resizing the bufferpool of a DB2 v.8.2 instance. The DB2 runs on an AIX 5.x platform. Problem is that an "ALTER BUFFERPOOL ..." command is not persistent if...
3
by: dotyet | last post by:
Hi Everyone, I am in a very strange situation, and am looking for suggestions to tackle it. I have a 10 gig database on 64-bit windows 2003 running platform. The database has about 5 gigs of...
9
by: aczapran | last post by:
Everything I read on DB2 indicates that the bufferpool is a pool of database pages used to speed up database access. It is controlled by us, when we specify how many pages we would like to have...
3
by: Gregor =?UTF-8?B?S292YcSN?= | last post by:
Hi! Is it possible to alter tablespace so that you don't connect to the database? The problem I have is this. I got a DB backup from a machine with 16 Gb of RAM. There was a bufferpool set to...
3
by: Mark A | last post by:
<dcruncher4@aim.comwrote in message news:fuevgh02ug6@drn.newsguy.com... I would try these: db2set DB2_USE_ALTERNATE_PAGE_CLEANING=ON (this will override CHNGPGS_THRESH) db2set...
3
by: dunleav1 | last post by:
In 9.1 and 9.5 (Linux 64 bit) when a buffer pool is set to self- tuning, how are blocks configured in respect to blocked vs non-blocked when self-tuning is set to on? (ie) I have one bufferpool...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
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...

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.