DB2 temporary BP override

Question posted by: bwmiller16@gmail.com (Guest) on January 23rd, 2008 02:35 PM

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?

Quote | Subscribe