Results 1 to 7 of 7
  1. #1
    Join Date
    Apr 2009
    Posts
    2

    Unanswered: Restore not working.

    Two machines both Win XP and the very same level of db2 'DB2 v9.1.200.98'

    Backed up the BUSCONT database from one that works fine and want to put it on the other machine but keep getting this:

    C:\TMP>DB2 RESTORE DATABASE BUSCONT into BUSCONT
    SQL0902C A system error (reason code = "") occurred. Subsequent SQL
    statements cannot be processed. SQLSTATE=58005

    Please help. I'm pulling my hair out on this one.
    Attached Files Attached Files

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Your restore command is incomplete. DB2 needs to know what to restore. It needs to know where the image is located and which image to restore.

    Andy

  3. #3
    Join Date
    Apr 2009
    Posts
    2
    The restore command is fine. I'm doing it from the location where the backup is. The back and the new db names are both the same.

  4. #4
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    If the above restore command is the complete command you are issuing, then it is not fine. It does not tell DB2 where the image is located, nor does it tell it which image to restore.

    Andy

  5. #5
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    try the following command:
    DB2 RESTORE DATABASE BUSCONT on c: dbpath on c:

  6. #6
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    That still will not work. The OP still needs to tell the restore command where the image (USE, LOAD, FROM) and which image to restore (TAKEN AT). I was hoping that the OP would RTFM and learn it themselves instead of having it spelled out.

    Andy

  7. #7
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    You don't need to tell the location/timestamp of the image if the restore command is issued from the dir where the image is located and there is only one image for this db.

    Restore was complaining about D: being unavailable and this is most likely due to the source db/tablespaces having its automatic storage on D:

Posting Permissions

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