I'm trying to restore a database and encountering the following problem :
SQL0902C A system error (reason code = "") occurred. Subsequent
SQL statements cannot be processed.
A system error occurred.
Record the message number (SQLCODE) and reason code in the message.
If trace was active, invoke the Independent Trace Facility at the
operating system command prompt. Then contact your technical service
representative with the following information:
- Problem description
- SQLCODE and embedded reason code
- SQLCA contents if possible
- Trace file if possible.
Federated system users: isolate the problem to the data source failing
the request (refer to the Troubleshooting Guide to determine which data
source is failing to process the SQL statement) and take the necessary
diagnostic steps for that data source. The problem determination
procedures for data sources vary, so refer to the applicable data source
this happen when using DB2 control center, but here is the equivalent statement :
RESTORE DATABASE TPCDB FROM "C:\downloads\DB2_backup" TAKEN AT 20110623142633 TO "C:" INTO TPCDB WITH 2 BUFFERS BUFFER 1024 PARALLELISM 1 WITHOUT PROMPTING;
which is computed with the DB2CC gui.
This is my db2 level on the windows system :
DB21085I Instance "DB2" uses "64" bits and DB2 code release "SQL09070" with
level identifier "08010107".
Informational tokens are "DB2 v18.104.22.1681", "s090521", "NTX6497", and Fix Pack
Product is installed at "C:\PROGRA~1\IBM\SQLLIB" with DB2 Copy Name "DB2COPY1".
db2diag.log looks like this :
2011-06-30-08.34.04.370000-300 E190875F454 LEVEL: Severe
PID : 1492 TID : 820 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
EDUID : 820 EDUNAME: db2bm.1252.0 (TPCDB) 0
FUNCTION: DB2 UDB, database utilities, sqludProcessSGRestore, probe:4178
MESSAGE : ZRC=0x87020002=-2029912062=SQLB_BPSE "Debug logic error detected"
DIA8501C A buffer pool logic error has occurred.
2011-06-30-08.34.04.386000-300 E191331F434 LEVEL: Severe
PID : 1492 TID : 1252 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : TPCDB
APPHDL : 0-215 APPID: *LOCAL.DB2.110630133404
AUTHID : SYSTEM
EDUID : 1252 EDUNAME: db2agent (TPCDB) 0
FUNCTION: DB2 UDB, database utilities, sqludrsa, probe:786
MESSAGE : Restore Terminated.
2011-06-30-08.34.04.542000-300 I191767F308 LEVEL: Error
PID : 3120 TID : 4664 PROC : db2dasstm.exe
INSTANCE: DB2 NODE : 000
EDUID : 4664
FUNCTION: DB2 Tools, DB2 administration server, handleRunCmd, probe:85
DATA #1 : signed integer, 4 bytes
Thanks in advance.