Results 1 to 6 of 6
  1. #1
    Join Date
    Aug 2009
    Posts
    5

    Unanswered: Problem in creating DB from backup

    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

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    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...
    ---
    "It does not work" is not a valid problem statement.

  3. #3
    Join Date
    Aug 2009
    Posts
    5
    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
    Attached Files Attached Files

  4. #4
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    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.
    ---
    "It does not work" is not a valid problem statement.

  5. #5
    Join Date
    Aug 2009
    Posts
    4
    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

  6. #6
    Join Date
    May 2005
    Location
    Bangalore, India
    Posts
    35
    "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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •