Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2002
    Posts
    4

    Question Unanswered: Restoring to a new database from tape on a different server

    I have taken an OFFLINE backup to tape of a database I want to create new on a different server. I use the following RESTORE Command using the information from the db2 list history backup command:

    db2 "restore database PUBLIC1D load /usr/lib/libnsrdb2.a taken at 20040225140836 to /opt/db2/ol1p into newdb2 redirect without rolling forward"

    I get the message:

    SQL2542N No match for a database image file was found based on the source database alias "PUBLIC1D" and timestamp "20040225140836" provided.

    Using this db alias and timestamp on the server where the backup was created I can restore this backup and replace the existing database. The tape is found.

    Do I need to do something to get the new server to look for this tape backup?

    Thanks for any help.

  2. #2
    Join Date
    Jun 2002
    Posts
    4

    Re: Restoring to a new database from tape on a different server

    In case it is helpful, I have DB2 V8 Fixpak 4 on AIX 5.2.

Posting Permissions

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