DIA8501C A buffer pool logic error has occurred.

tobiwwwan · #1 (**permalink**) 09-24-08, 10:16

Hi,

I have the following problem when restoring a db into another user on the same server:

Step 1:
as User db2inst1

Code:

db2 backup db dbalt to /backup/db2inst1

Step 2:
als User db2inst3

Code:

db2 restore db dbalt from /backup/db2inst1 taken at 20080924154957 dbpath on /data/db2inst3 into dbneu newlogpath /log/db2inst3 redirect without rolling forward

Output:

Code:

SQL0902C  A system error (reason code = "") occurred.  Subsequent SQL
statements cannot be processed.  SQLSTATE=58005

db2diag.log:

Code:

2008-09-24-16.00.40.831132+120 E232905A446        LEVEL: Severe
PID     : 651328               TID  : 4169        PROC : db2sysc 0
INSTANCE: db2inst3             NODE : 000
EDUID   : 4169                 EDUNAME: db2bm.2113.0 (PVA_ASO) 0
FUNCTION: DB2 UDB, database utilities, sqludProcessSGRestore, probe:4111
MESSAGE : ZRC=0x87020002=-2029912062=SQLB_BPSE "Debug logic error detected"
          DIA8501C A buffer pool logic error has occurred.

2008-09-24-16.00.40.831394+120 E233352A447        LEVEL: Severe
PID     : 651328               TID  : 4169        PROC : db2sysc 0
INSTANCE: db2inst3             NODE : 000
EDUID   : 4169                 EDUNAME: db2bm.2113.0 (PVA_ASO) 0
FUNCTION: DB2 UDB, database utilities, sqludbuf, probe:713
DATA #1 : Sqlcode, PD_TYPE_SQLCODE, 4 bytes
-2044
DATA #2 : Hexdump, 8 bytes
0x00000001106E0298 : FFFF F804 0000 0002                        ........

2008-09-24-16.00.40.841644+120 E233800A432        LEVEL: Severe
PID     : 651328               TID  : 2113        PROC : db2sysc 0
INSTANCE: db2inst3             NODE : 000         DB   : PVA_ASO
APPHDL  : 0-15                 APPID: *LOCAL.db2inst3.080924140039
AUTHID  : DB2INST3
EDUID   : 2113                 EDUNAME: db2agent (PVA_ASO) 0
FUNCTION: DB2 UDB, database utilities, sqludrsa, probe:781
MESSAGE : Restore Terminated.

For your information:
db2level

Code:

DB21085I  Instance "db2inst3" uses "64" bits and DB2 code release "SQL09050"
with level identifier "03010107".
Informational tokens are "DB2 v9.5.0.0", "s071001", "AIX6495", and Fix Pack
"0".
Product is installed at "/db2/product/9.5".

How can I solve the problem?

Thanks for your help!

Marcus_A · #2 (**permalink**) 09-24-08, 22:38

For ZRC errors, you need to call IBM support. But they will probably ask you to put on FP2 as a first step. You have the intial release of a DB2 version (9.5) with a brand new memory management system.