Topic
  • 1 reply
  • Latest Post - ‏2008-04-09T15:59:46Z by SystemAdmin
SystemAdmin
SystemAdmin
17917 Posts

Pinned topic REDIRECT RESTORE Error - SQL0902C - ReasonCode '2'

‏2008-04-03T17:20:19Z |
Group,

I'm performing a redirect restore between Solaris 10 servers. My system and DB2 information:

System information:
Solaris 10, SPARC processor (both source and target)

DB2 Information:
Source: DB2 V8.2 ESE FP15
Target: DB2 V8.2 ESE FP7

I'm trying to restore DB2 backup taken on 64bit instance of DB2 FP15 to 32bit instance of DB2 FP7. Before I was performing restore from different bit level, it worked. Here is the Restore statement which I use for restore:

restore database rosbase from '/export/home/uwu5d1/backup/rosbase' taken at 20080328153011 to '/export/home/uwu5d1/rosbase/data' into rose redirect COMPRLIB
/export/home/uwu5d1/sqllib/lib/libdb2compr.so without rolling forward without prompting

SQL0902C A system error (reason code = "2") occurred. Subsequent SQL
statements cannot be processed. SQLSTATE=58005.
becas of which set tablespace containers stopped. When I look into db2diag.log I can see the following error messages:

2008-04-03-21.55.59.684771+330 I3864534C404 LEVEL: Error
PID : 17032 TID : 1 PROC : db2agent (ROSE) 0
INSTANCE: uwu5d1 NODE : 000 DB : ROSE
APPHDL : 0-259 APPID: *LOCAL.uwu5d1.080403162601
FUNCTION: DB2 UDB, buffer pool services, sqlbReadBufferPoolTable, probe:900
MESSAGE : Buffer Pool Headers do not match. Rebuilding.

2008-04-03-20.25.53.479961+330 I3832351C383 LEVEL: Event
PID : 21397 TID : 1 PROC : db2agent (instance) 0
INSTANCE: uwu5d1 NODE : 000
APPHDL : 0-222 APPID: *LOCAL.uwu5d1.080403145552
FUNCTION: DB2 UDB, config/install, sqlfLogUpdateCfgParam, probe:20
CHANGE : CFG DB AMSITCH: "Util_heap_sz" From: "5000" To: "131072"
2008-04-03-20.25.55.798182+330 I3834487C324 LEVEL: Warning
PID : 15505 TID : 1 PROC : db2med.15485.0 0
INSTANCE: uwu5d1 NODE : 000
FUNCTION: DB2 UDB, database utilities, sqluMCReadMediaHeaderFromDevice, probe:139
MESSAGE : Transfer buffer size was changed from 0 to 1048576
2008-04-03-20.25.55.799403+330 I3834812C378 LEVEL: Warning
PID : 15485 TID : 1 PROC : db2agent (ROSE) 0
INSTANCE: uwu5d1 NODE : 000 DB : ROSE
APPHDL : 0-223 APPID: *LOCAL.uwu5d1.080403145554
FUNCTION: DB2 UDB, database utilities, sqludmhv, probe:110
MESSAGE : Performing a Cross Platform Restore
2008-04-03-20.25.55.799759+330 I3835191C421 LEVEL: Warning
PID : 15485 TID : 1 PROC : db2agent (ROSE) 0
INSTANCE: uwu5d1 NODE : 000 DB : ROSE
APPHDL : 0-223 APPID: *LOCAL.uwu5d1.080403145554
FUNCTION: DB2 UDB, database utilities, sqludPrintStartingMsg, probe:1
DATA #1 : String, 51 bytes
Starting a full database restore.
Agent PID: 15485

2008-04-03-20.25.56.561899+330 I3835613C388 LEVEL: Warning
PID : 15503 TID : 1 PROC : db2bm.15485.0 0
INSTANCE: uwu5d1 NODE : 000
FUNCTION: DB2 UDB, database utilities, sqludProcessHistoryFile, probe:24
DATA #1 : String, 107 bytes
An empty database history has been detected.
The database history will be overwritten by the backup image.
2008-04-03-20.25.56.906082+330 I3836002C385 LEVEL: Error
PID : 15503 TID : 1 PROC : db2bm.15485.0 0
INSTANCE: uwu5d1 NODE : 000
FUNCTION: DB2 UDB, buffer pool services, sqlbReadPoolOneFile, probe:920
RETCODE : ZRC=0x87020002=-2029912062=SQLB_BPSE "Debug logic error detected"
DIA8501C A buffer pool logic error has occurred.

2008-04-03-20.25.56.908147+330 I3836388C385 LEVEL: Error
PID : 15503 TID : 1 PROC : db2bm.15485.0 0
INSTANCE: uwu5d1 NODE : 000
FUNCTION: DB2 UDB, buffer pool services, sqlbReadPoolOneFile, probe:920
RETCODE : ZRC=0x87020002=-2029912062=SQLB_BPSE "Debug logic error detected"
DIA8501C A buffer pool logic error has occurred.

2008-04-03-20.25.56.908534+330 I3837153C285 LEVEL: Error
PID : 15503 TID : 1 PROC : db2bm.15485.0 0
INSTANCE: uwu5d1 NODE : 000
FUNCTION: DB2 UDB, buffer pool services, sqlbReadPool, probe:920
MESSAGE : Error reading table space files

2008-04-03-20.25.57.103654+330 I3839314C361 LEVEL: Severe
PID : 15485 TID : 1 PROC : db2agent (ROSE) 0
INSTANCE: uwu5d1 NODE : 000 DB : ROSE
APPHDL : 0-223 APPID: *LOCAL.uwu5d1.080403145554
FUNCTION: DB2 UDB, database utilities, sqludrsa, probe:110
MESSAGE : Restore Terminated.
What is the Bufferpool logic error: 'DIA8501C A buffer pool logic error has occurred'?

Looking for some fast answers. Thanks in Advance.

VJ_DBA
  • SystemAdmin
    SystemAdmin
    17917 Posts

    Re: REDIRECT RESTORE Error - SQL0902C - ReasonCode '2'

    ‏2008-04-09T15:59:46Z  
    VJ, you may want to contact DB2 support to dig into this further. A couple of possibilities come to mind though. If 'rose' already exists on the target system, and you're intending to replace that entirely, then you may want to drop it first and allow RESTORE to recreate it. If you do that, keep a backup copy of all your existing logs and DB's of course. There are also some fairly significant enhancements between FP15 and FP7, so if you've taken advantage of some of the new features of DB2 in FP15 there is a chance that you may not be able to restore backwards to the older FP7.

    Hope that helps.
    Kelly Rodger