468,310 Members | 1,430 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,310 developers. It's quick & easy.

Can't rollforward due to large bufferpool size

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

Nov 24 '05 #1
3 5908

"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
Nov 24 '05 #2
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
Nov 24 '05 #3
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


Nov 25 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Jagdip Singh | last post: by
2 posts views Thread by shenanwei | last post: by
20 posts views Thread by Hemant Shah | last post: by
1 post views Thread by Raja Shekar | last post: by
reply views Thread by Ian | last post: by
reply views Thread by NPC403 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.