var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
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.
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.