Topic
2 replies Latest Post - ‏2011-07-02T06:04:02Z by Z-Company
tmhajas
tmhajas
3 Posts
ACCEPTED ANSWER

Pinned topic SQL0902C A system error (reason code = "") occurred

‏2011-06-30T13:51:56Z |
hi all,

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.

Explanation:

A system error occurred.

User response:

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
manuals.

sqlcode: -902

sqlstate: 58005

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 v9.7.0.441", "s090521", "NTX6497", and Fix Pack
"0".
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
-902

Thanks in advance.
Updated on 2011-07-02T06:04:02Z at 2011-07-02T06:04:02Z by Z-Company
  • tmhajas
    tmhajas
    3 Posts
    ACCEPTED ANSWER

    Re: SQL0902C A system error (reason code = "") occurred

    ‏2011-06-30T17:25:47Z  in response to tmhajas
    the source and target operating systems are :
    source : windows 2003
    target : windows 2008
    both same Db2 level as stated above

    In a different combination, where :
    source : windows 2008 with db2 9.5 fp 4
    target : windows 2008 with db2 9.7 GA
    it worked

    is there any limitation for OS support compatibility?
    • Z-Company
      Z-Company
      310 Posts
      ACCEPTED ANSWER

      Re: SQL0902C A system error (reason code = "") occurred

      ‏2011-07-02T06:04:02Z  in response to tmhajas
      1. check if db2 backup image is valid - with db2ckbkp command
      2. increase util heap

      if it fails call ibm support, they will tell you how to make trace file for them