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