Can't rollforward due to large bufferpool size

[dotyet]

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
32-bit windows 2003 platform. The destination is also a DB2 UDB 8.2
FP9a database.

The restore command works fine, but while attempting the rolforward of
the sql logs, it complains about database falling short on bufferpool,
and then terminates the rollforward process. One close look at the
db2diag.log file, I noticed that db2 tried to start the database with
the hidden bufferpool. But, apparently, that hidden bufferpool was
pretty small to rollforward the logs and bring it online.

I cannot reduce the bufferpool size as the database cannot be connected
to.
I cannot connect to the database as it is in rollforward pending state.
I cannot rollforward the database, as it's not happy with the size of
the *hidden* bufferpool and terminates.

So, it's some sort of a deadlock situation I am facing.

Can anyone suggest any parameters or any registry variables or anything
at all, which can help me get through this situation. I cannot bring
down the bufferpool size of the production db and I cannot stop it for
an offline backup image. The only other option, I am looking at is to
attempt a restore on a spare 64-bt machine/db2instance and then reduce
the bufferpool and then take a backup and restore it on the 32-bit box.

Thanks & Regards,
dotyet

[Matt Emmerton]

"dotyet" <do****@yahoo.com> wrote in message
news:11**********************@g47g2000cwa.googlegr oups.com...

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
32-bit windows 2003 platform. The destination is also a DB2 UDB 8.2
FP9a database.

The restore command works fine, but while attempting the rolforward of
the sql logs, it complains about database falling short on bufferpool,
and then terminates the rollforward process. One close look at the
db2diag.log file, I noticed that db2 tried to start the database with
the hidden bufferpool. But, apparently, that hidden bufferpool was
pretty small to rollforward the logs and bring it online.

I cannot reduce the bufferpool size as the database cannot be connected
to.
I cannot connect to the database as it is in rollforward pending state.
I cannot rollforward the database, as it's not happy with the size of
the *hidden* bufferpool and terminates.

So, it's some sort of a deadlock situation I am facing.

Can anyone suggest any parameters or any registry variables or anything
at all, which can help me get through this situation. I cannot bring
down the bufferpool size of the production db and I cannot stop it for
an offline backup image. The only other option, I am looking at is to
attempt a restore on a spare 64-bt machine/db2instance and then reduce
the bufferpool and then take a backup and restore it on the 32-bit box.

http://publib.boulder.ibm.com/infoce...n/r0005665.htm

db2set DB2_OVERRIDE_BPF=50000

This will bring up all configured bufferpools using 50000 pages each. You
can choose a smaller/larger value that is suitable for your number of
bufferpools and available system memory. You can also configure each
bufferpool individually if you want (see the help text).

--
Matt Emmerton

[Gert van der Kooij]

In article <11**********************@g47g2000cwa.googlegroups .com>,
dotyet (do****@yahoo.com) says...

I cannot reduce the bufferpool size as the database cannot be connected
to.

Check the DB2_OVERRIDE_BPF variable. You can find it in the online
help at http://tinyurl.com/a3ngh

[dotyet]

thanks a tonne.. that definitely helped. rollforward is in progress
right now.

once again... thanks

rgds,
dotyet

Gert van der Kooij wrote:

In article <11**********************@g47g2000cwa.googlegroups .com>,
dotyet (do****@yahoo.com) says...

I cannot reduce the bufferpool size as the database cannot be connected
to.

Check the DB2_OVERRIDE_BPF variable. You can find it in the online
help at http://tinyurl.com/a3ngh