Hi,
I am trying to create DB from a backUp, but I am getting the following error.

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

I am not able to track the reason for this. Please help me in resolving this.
I am using DB2 9.5 . Note: even reinstallation of DB2 didnt worked

Thanks in advance
Kaushal

I'm afraid you'll need to provide a bit more information, e.g.
- what platform are you running on;
- where was the backup taken;
- the exact RESTORE command you're using;
- what is written to db2diag.log when this error happens...

Hi,
Thanks for the reply.
I have attached the log file here.
I am using windows XP, the database back up was taken in a remote system and was later copied to my local machine.
The command used to restore is given below:

RESTORE DATABASE APM9 FROM "C:\Originations\DB2BackUp" TAKEN AT 20090813052414 TO "C:" INTO APM9 WITH 2 BUFFERS BUFFER 1024 PARALLELISM 1 WITHOUT PROMPTING;

Kaushal

The most likely reason for the problem is that DB2 attempts to re-created the original tablespace containers but the disk or directory is missing. Check "redirected restore" in the manual.

Hi Kaushal,

you are using restoration command..

RESTORE DATABASE APM9 FROM "C:\Originations\DB2BackUp" TAKEN AT 20090813052414 TO "C:" INTO APM9 WITH 2 BUFFERS BUFFER 1024 PARALLELISM 1 WITHOUT PROMPTING;

may I know why you are using TO "C:" after timestamp in restoration command..!

may be command should be..

RESTORE DATABASE APM9 FROM "C:\Originations\DB2BackUp" TAKEN AT 20090813052414 INTO APM9 WITH 2 BUFFERS BUFFER 1024 PARALLELISM 1 WITHOUT PROMPTING;

Pavan

"TO C:" is needed when the database whose image is being used was using Automatic Storage Tablespaces.

Try Redirected restore. You cannot restore an image taken on a remote machine to the target machine without redirected restore unless the same container paths are available on target machine.