Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2011
    Posts
    5

    Unanswered: Restore on another Sever

    I am working with DB2 v9.1 windows, I have taken a backup of my database on the test server. I run the restore command below
    RESTORE DATABASE <A>
    FROM D:\BACKUP
    TAKEN AT timestamp
    INTO
    <B>
    WITHOUT ROLLING FROWARD
    WITHOUT PROMPTING

    this as expected it creates database <B> and loads the data from <A>

    I then asked for the backup dataset to be moved to another server "C" with the same environment. But when I run the above command i get the following error

    SQL0902C A system error (reason code = "") occurred. Subsequent SQL
    statements cannot be processed.


    can anyone help?..

  2. #2
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    db2diag.log will contain more information about why restore failed with sql0902c. It could be due to:
    https://www-304.ibm.com/support/docv...id=swg21396830

Posting Permissions

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