Skip to Content
0
Former Member
Mar 29, 2011 at 08:03 AM

Homogenous System Copy: SQL1218N No pages currently available in bufferpool

518 Views

Hi experts,

I've some problems with a homogenous system copy during restoring the database. On the source system I've created a restore script with the command "brdb6brt -bm 2 -replace xxx=yyy" and I have copied this script to the target system. On the target system I've created a new database. The configurations are equal with our other databases, so it should work. Then I've run the restore script on the target system. I think the restore should be successfully, because on the command line appears the following message: "THE RESTORE PROCEDURE HAS NOW FINISHED SUCCESSFULLY"

However, the proplems occurs by running the rollforward: I've executed the command "db2 rollforward db yyy" and I've copied the essential logfile in the directory "/db2/yyy/log/log_dir/". Now, I've tried to run the command "db2 rollforward db yyy to end of logs and stop NORETRIEVE", but the following error appears:

SQL1218N  There are no pages currently available in bufferpool "".
SQLSTATE=57011

Here are some entries from db2diag.log:

2011-03-29-09.32.55.463640+120 I5177681A529       LEVEL: Error
PID     : 413792               TID  : 18035       PROC : db2sysc 0
INSTANCE: db2yyy               NODE : 000         DB   :yyy
APPHDL  : 0-314                APPID: *LOCAL.db2yyy.110329073157
AUTHID  : DB2yyy
EDUID   : 18035                EDUNAME: db2redom (yyy) 0
FUNCTION: DB2 UDB, recovery manager, sqlprProcDpsQEntry, probe:20
RETCODE : ZRC=0x071000E2=118489314=SQLPR_PR_PROC_DONE
"parallel recovery: error condition detected by some other agent."

2011-03-29-09.32.55.693361+120 I5179759A493       LEVEL: Error
PID     : 413792               TID  : 4113        PROC : db2sysc 0
INSTANCE: db2yyy               NODE : 000         DB   : yyy
APPHDL  : 0-314                APPID: *LOCAL.db2yyy.110329073157
AUTHID  : DB2yyy
EDUID   : 4113                 EDUNAME: db2agent (yyy) 0
FUNCTION: DB2 UDB, recovery manager, sqlpForwardRecovery, probe:1230
RETCODE : ZRC=0x8502002C=-2063466452=SQLB_BPFULL
          "no available buffer pool pages"

2011-03-29-09.32.55.694938+120 I5180725A496       LEVEL: Warning
PID     : 413792               TID  : 4113        PROC : db2sysc 0
INSTANCE: db2yyy               NODE : 000         DB   : yyy
APPHDL  : 0-314                APPID: *LOCAL.db2yyy.110329073157
AUTHID  : DB2yyy
EDUID   : 4113                 EDUNAME: db2agent (yyy) 0
FUNCTION: DB2 UDB, data protection services, sqlufrol, probe:8181
MESSAGE : The rollforward recovery phase completed with a return code of
          -2063466452

2011-03-29-09.32.55.794762+120 E5181222A463       LEVEL: Event
PID     : 413792               TID  : 4113        PROC : db2sysc 0
INSTANCE: db2yyy               NODE : 000         DB   : yyy
APPHDL  : 0-314                APPID: *LOCAL.db2yyy.110329073157
AUTHID  : DB2yyy
EDUID   : 4113                 EDUNAME: db2agent (idle) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::TermDbConnect, probe:2000
STOP    : DATABASE: yyy     : DEACTIVATED: NO

To solve the problem, I've increased the parameter DB2_OVERRIDE_BPF to 240.000 pages. I think it should be the right parameter. But it doesn't work.

Any idea?

Thanks and best regards

Max Power