Hi All -
The environment: Aix 5.2 with DB2 8 FP 14 all 64bit).
The situation is that another company is hosting our databases and
management has decided to move these databases in-house.
Now, the hosting company has a large (40gb memory) server with very
large bufferpools defined. Our environment has only 8gb memory. The
larger environment really isn't necessary since the DB here isn't all
that large and 40gb is really overkill to the max.
When we copy the database to our local environment and restore we have
no problems. However when we connect locally to the restored DB then
DB2 tries to use the hosting company's databases' bufferpool sizes as
they are currently defined. AIX finally throws-up with page swap
file errors since it just can't handle these huge bufferpools.
It seems like a chicken-egg thing. We'd like to define reasonable
local BP sizes tailored to our environment but can't since we can't
connect; we can't connect because the BP sizes are too large for our
8gb server to handle.
The hosting company refuses to change their BP sizes (which is one
reason we will be bringing these databases in-house).
Anybody have any thoughts?
4  2344 
On Jan 23, 3:31*pm, bwmille...@gmail.com wrote:
Hi All -
The environment: Aix 5.2 with DB2 8 FP 14 all 64bit).
The situation is that another company is hosting our databases and
management has decided to move these databases in-house.
Now, the hosting company has a large (40gb memory) server with very
large bufferpools defined. *Our environment has only 8gb memory. * The
larger environment really isn't necessary since the DB here isn't all
that large and 40gb is really overkill to the max.
When we copy the database to our local environment and restore we have
no problems. *However when we connect locally to the restored DB then
DB2 tries to use the hosting company's databases' bufferpool sizes as
they are currently defined. * AIX finally throws-up with page swap
file errors since it just can't handle these huge bufferpools.
It seems like a chicken-egg thing. *We'd like to define reasonable
local BP sizes tailored to our environment but can't since we can't
connect; *we can't connect because the BP sizes are too large for our
8gb server to handle.
The hosting company refuses to change their BP sizes (which is one
reason we will be bringing these databases in-house).
Anybody have any thoughts?
Hi,
perhpas this link can help you to overrides the size of the oversized
bufferpool: http://www-1.ibm.com/support/docview...=utf-8&lang=en
Best regards,
Joachim
On Jan 23, 10:00*am, joachim.c.muel...@googlemail.com wrote:
On Jan 23, 3:31*pm, bwmille...@gmail.com wrote:
Hi All -
The environment: Aix 5.2 with DB2 8 FP 14 all 64bit).
The situation is that another company is hosting our databases and
management has decided to move these databases in-house.
Now, the hosting company has a large (40gb memory) server with very
large bufferpools defined. *Our environment has only 8gb memory. * The
larger environment really isn't necessary since the DB here isn't all
that large and 40gb is really overkill to the max.
When we copy the database to our local environment and restore we have
no problems. *However when we connect locally to the restored DB then
DB2 tries to use the hosting company's databases' bufferpool sizes as
they are currently defined. * AIX finally throws-up with page swap
file errors since it just can't handle these huge bufferpools.
It seems like a chicken-egg thing. *We'd like to define reasonable
local BP sizes tailored to our environment but can't since we can't
connect; *we can't connect because the BP sizes are too large for our
8gb server to handle.
The hosting company refuses to change their BP sizes (which is one
reason we will be bringing these databases in-house).
Anybody have any thoughts?
Hi,
perhpas this link can help you to overrides the size of the oversized
bufferpool:
http://www-1.ibm.com/support/docview...SSEPGG&q1=DB2_...
Best regards,
Joachim- Hide quoted text -
- Show quoted text -
Hi Joachim -
Fabulous! We're going to give this a try and I'll post the results
here...
Thank You very much!
-B
On Jan 23, 10:13*am, bwmille...@gmail.com wrote:
On Jan 23, 10:00*am, joachim.c.muel...@googlemail.com wrote:
On Jan 23, 3:31*pm, bwmille...@gmail.com wrote:
Hi All -
The environment: Aix 5.2 with DB2 8 FP 14 all 64bit).
The situation is that another company is hosting our databases and
management has decided to move these databases in-house.
Now, the hosting company has a large (40gb memory) server with very
large bufferpools defined. *Our environment has only 8gb memory. *The
larger environment really isn't necessary since the DB here isn't all
that large and 40gb is really overkill to the max.
When we copy the database to our local environment and restore we have
no problems. *However when we connect locally to the restored DB then
DB2 tries to use the hosting company's databases' bufferpool sizes as
they are currently defined. * AIX finally throws-up with page swap
file errors since it just can't handle these huge bufferpools.
It seems like a chicken-egg thing. *We'd like to define reasonable
local BP sizes tailored to our environment but can't since we can't
connect; *we can't connect because the BP sizes are too large for our
8gb server to handle.
The hosting company refuses to change their BP sizes (which is one
reason we will be bringing these databases in-house).
Anybody have any thoughts?
Hi,
perhpas this link can help you to overrides the size of the oversized
bufferpool:
http://www-1.ibm.com/support/docview...SSEPGG&q1=DB2_...
Best regards,
Joachim- Hide quoted text -
- Show quoted text -
Hi Joachim -
Fabulous! *We're going to give this a try and I'll post the results
here...
Thank You very much!
-B- Hide quoted text -
- Show quoted text -
All -
Thanks to Joachim and his reply we were able to do exactly what we
wanted with this DB2 registry variable...it worked great.
-B bw********@gmail.com wrote:
All -
Thanks to Joachim and his reply we were able to do exactly what we
wanted with this DB2 registry variable...it worked great.
-B
I know the doc that Joachim mentions it describes this, but make sure
that you alter the bufferpools to have a reasonable size and then unset
DB2_OVERRIDE_BPF. It's not meant to be left on permanently. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Kai-Uwe Bux |
last post by:
Hi folks,
I have trouble writing a class, derving from stringstream, that collects
item and once it's done will write them to std::cout in one go. It works
fine except when I use it as a...
|
by: White Wolf |
last post by:
Hi,
I would like to double check how long a temporary returned by a function
lives?
Suppose I have an instance of a class type C, which has a member function
returning some sort of...
|
by: randi_clausen |
last post by:
Using SQL against a DB2 table the 'with' key word is used to
dynamically create a temporary table with an SQL statement that is
retained for the duration of that SQL statement.
What is the...
|
by: Stoyan |
last post by:
Hi All,
I don't understand very well this part of MSDN:
"Derived classes that override GetHashCode must also override Equals to
guarantee that two objects considered equal have the same hash code;...
|
by: Adriano Coser |
last post by:
Hello.
After I converted my .net code to the new VC2005 syntax I started to get
C4490 on my ExpandableObjectConverter subclass overrides. The GetProperties
method is no longer called by the...
|
by: localhost |
last post by:
I want to determine within my code-behind only the location of the
current tem directory for ym ASP.NET files. For example, the latest
web app build on my system shows:
...
|
by: Marcel Hug |
last post by:
Hi NG !
I'm new in C# and I'm reading a book about the fundamentals and concepts.
In the chapter Methods it's written to use virtual, if i would like to
override the method in a subclass. This...
|
by: RainBow |
last post by:
I understand that a compiler synthesises a default constructor if none
is provided by the user ( of course depending on the situation if
synthesis of such c'tor is actually needed in the program...
|
by: Klaas Vantournhout |
last post by:
Hi all,
I was wondering if it is possible if you can check in a function if one
of the arguments is temporary.
What I mean is the following. A is a class, foo is a function returning
a class...
|
by: Juha Nieminen |
last post by:
Let's assume we have a class like this:
//---------------------------------------------------------
#include <iostream>
class MyClass
{
public:
MyClass() { std::cout << "constructor\n"; }...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
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$) {
}
...
|
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...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
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...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
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...
| |
