473,847 Members | 1,482 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Bufferpool size Problem

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
the database is stopped with the db2stop and restarted with the
db2start command.

The bufferpool which I try to resize is the IBMDEFAULTBP.

Another problem that occurs is that all DB instances use the same
large bufferpoolsize when allocating memory although their size is set
to default value (1000 pages - IBMDEFAULTBP).

I once set that value of IBMDEFAULTBTP to 131072 and now every
Bufferpool on that DB2 instance seems to use that value despite the
actual setting of the DB-instances.

I see no way on how to change the value of the bufferpool and this
leads the AIX to crash if many instances are activated because all the
memory is allocated.

Hope someone can help me ...

Greetings
Christian Berg
Nov 12 '05 #1
1 6552
> Problem is that an "ALTER BUFFERPOOL ..." command is not persistent if
the database is stopped with the db2stop and restarted with the
db2start command.
That is most assuredly not the case. First of all, ALTER BUFFERPOOL is
an SQL statement, not a command. Are you sure that are committing the
ALTER BUFFERPOOL statement?

In fact, the only way that I can duplicate this behavior is if I issue
an ALTER BUFFERPOOL statement, not commit it, and then do a 'db2stop
force' in another window. In that case, the transaction gets rolled
back, and the bufferpool remains at its original size.
Another problem that occurs is that all DB instances use the same
large bufferpoolsize when allocating memory although their size is set
to default value (1000 pages - IBMDEFAULTBP).

I once set that value of IBMDEFAULTBTP to 131072 and now every
Bufferpool on that DB2 instance seems to use that value despite the
actual setting of the DB-instances.


Err. Thats not right either. Bufferpools are (by definition)
database-local objects.

Changing the size of IBMDEFAULTBP via ALTER BUFFERPOOL will have zero
effect on the size of any other database on the instance. Even if you
were changing the BUFFPAGE database configuration parameter to change
the size of the bufferpool, that still wouldnt have an effect on other
db's in the instance.

jsoh
Nov 12 '05 #2

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

Similar topics

4
3684
by: Yoyoma | last post by:
Hello, I have a client running db2 udb 7.2 workgroup , FP10a on a Windows 200 server with 4GB of memory. The database is 25GB big, but from that maybe 50% is current data. My issue is that we are noticing that DB2 is only using about 100-150mb of RAM on the server. This is a productrion machine with 50-75 of transactions a minute on the database. Now flaming me about using W2k as the OS, we have running similar testes on SUSE 9 with...
10
12959
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 bufferpool, do alter, change the size (to a smaller one), after that , i use the configuration parameter to check the bufferpool size, it still show the old value, i close the control center and reopen , still the same, so is that i must stop the...
5
2400
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
6243
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 bufferpool. It's a DB2 UDB 8.2 FP9a database. I am trying to restore an online backup image of this database on a
1
5540
by: Raja Shekar | last post by:
HI Every body , I would like to know whether is it mandatory to give Tablespace page size and Bufferpool page size equal..? i also heard like while creating tablespace if pages size of tablespace and bufferpool , the statement itself will fail ...why i'm asking is if we chose a different page size ( ofcourse less than bufferpool page size ) only it shoud affect the performance of db2 .. Thanks in Advance Raja Shekar
3
5246
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 use 10 Gb of RAM. Now I have to put it on a machine with only 8 Gb of RAM. The restore is OK, but I'd like to decrease that bufferpool to only use 4 Gb. Best regards,
3
5030
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 DB2_SKIPINSERTED=ON (this will reduce lock contention on inserts) db2 update db cfg for test using NUM_IOCLEANERS 8 db2 update db cfg for test using LOGBUFSZ 256 db2 update db cfg for test using DBHEAP 2000 (unless it already at least
3
7935
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 that is 16k that the IBMDEFAULTBP is shared between all tablespaces. The data tablespace has prefetch automatic set to on.
0
4435
by: dot.yet | last post by:
Hi Everyone, environment: DB2 9.5 WSE with FP 2a Solaris 10 u5 - 64-bit SMP - 2 Quad CPUS - total 8 cores 16 GB RAM SAMPLE database Solaris Containers
0
9889
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9732
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10652
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
9487
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7886
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
7058
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5723
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5914
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
3
3166
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.