var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Drop & Restore
I am using DB2 v9.1 windows, I want drop database <a> and do a restore database <a> from a backup dataset for database <b>.
I get the following error
SQL30061N The database alias or database name "<a> " was not
found at the remote node.
The only command I am issuing is a RESTORE
Last edited by IsaarAhmed; 07-08-11 at 05:15.
Are you issuing any commands that cause this error?
Visit the new-look IDUG Website
, register to gain access to the excellent content.
Please share the command you are using
What I want to do is backup database <b> on server B and restore as database <a> on server A, database <a> already exists. what I did is
1. Backup database <b> on server B and copy the backup to server A.
2. DROP database <a>
RESTORE DATABASE database <b>
TAKEN AT timestamp
DBPATH ON D:\
INTO database <a>
NEWLOGPATH log path
WITHOUT ROLLING FORWARD
I get the error above however if I change the INTO line to
'INTO database <c>' a databse name that does not exists on server A it works fine....
Did step #2 (drop db) complete successfully or generated some error/warning?
What's the output from:
db2 list db directory
db2 list db directory on d: