There is not enough memory to allocate the bufferpools. This error occurs when db2 tries to connect to the db to apply the logs. The bufferpool size it's trying to allocate is what's stored in the backup image (bp allocations you have in prod). You can use DB2_OVERRIDE_BPF registry variable to override the size of you bufferpools if rollforward continues to fail. You should also adjust the size of your bufferpools after rollforward completes and unset the variable.
You can use DB2_OVERRIDE_BPF registry variable to override the size of you bufferpools if rollforward continues to fail.
No, won't work (been there). We've had the same problem lately. Can only be solved to ensure that the hardware configuration is exactly the same as the source computer. In our case we had to change the "boot.ini" with the /3G switch. The DB2_OVERRIDE_BPF does not kick-in during rollforeward.
Sorry, could not reply earlier... What I believe is happening during rollforward is that db2 tries to connect to the db and finds that there is not enough memory to allocate prod-size bufferpools (this is what's in the image) so it tries to connect using hidden bufferpools. Hidden bufferpools are small (I think 16 pages), 16 pages is not enough for rollforward to complete and so it fails with sql1218n. What DB2_OVERRIDE_BPF will do is override the bufferpool sizes stored in the backup image and also the hidden ones so rollforward will use the size specified with DB2_OVERRIDE_BPF. Usually, setting DB _OVERRIDE_BPF to somewhere between 1000-2000 should be enough (instance needs to be restarted).
I had a discussion with IBM support rep yesteday around 3:00pm. The result of discussion was that I started to believe that our machine previously used this variable and I never had this rollforward problem since I was hired.
Recently when I attempted UPGRADE, I had a problem with upgrade, I could not rollforward, I dropped the instance and reinstalled 8.2 afresh. This variable might have been unset ( no way to confirm this.). Yesterday I started PMR with IBM and I got answer after I had already resolved this via current post; IBM called me around 3:00pm. I let IBM rep say whole thing to ensure that what I was doing was right.
They told us to start with a value of 1000 and try going up in steps till it succeeds. He also said that this variable is for this particular scenario.