hi.

db2 udb v. 8.1.4 for windows

this is my problem:
after a shutdown of power, I restore my db, but, when I run the ROLLFORWARD command:

db2 => ROLLFORWARD DATABASE DWCORP TO END OF LOGS AND COMPLETE
SQL1218N There are no pages currently available in bufferpool "".
SQLSTATE=57011

and the state of my db is:
db2 => ROLLFORWARD DATABASE DWCORP

Rollforward Status

Input database alias = DWCORP
Number of nodes have returned status = 1

Node number = 0
Rollforward status = DB working
Next log file to be read = S0027181.LOG
Log files processed = S0027173.LOG - S0027177.LOG
Last committed transaction = 2004-04-28-12.05.04.000000


any idea?
TIA
Abel.

Did you try increasing the bufferpool size? What is size defined right now?

hi and thanks Marcus.

I can´t connect to db.

db2 => connect to dwcorp
SQL1117N A connection to or activation of database "DWCORP" cannot be made because of ROLL-FORWARD PENDING. SQLSTATE=57019


I can change the buffer pool size whitout connection?

Thanks.
Abel.

At this point, you should probably be calling support...

There is a parameter DB2_OVERRIDE_BPF that can be used in this case. What it does is tell DB2 to ignore the bufferpool file, which has the definitions for your bufferpools.

ie. db2set DB2_OVERRIDE_BPF=1000

(It's in pages - more documentation for it in the Admin Guide for Performance)

Don't forget to unset it once you're done!

This *may* work, I've never seen it used before a ROLLFORWARD to be perfectly honest, usually it's used when someone cannot connect because they set their Bufferpool ridiculously large.

THANKS

This work OK

Just wanted to say Thanks, since the post helped me during a restore.

Also wanted to add that the instance has to be stopped and started for the db2set to take effect.