var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Changing Alias Name and trying to restore backup
I'm using DB2 9.1 LUW. I want to change the Alias name of a database to the database name. Here is what the old name was as of this morning:
I want it to be:
I dropped the database and re-created it and am trying to run the backup from last night. Which has the old PS_TRN alias.
Here is what I'm running:
db2 restore db psfttrn from . taken at 20100804010119 replace existing
Here is the error I'm getting:
SQL2542N No match for a database image file was found based on the source
database alias "PSFTTRN" and timestamp "20100804010119" provided.
Is there anything I can do to restore this new database with the PSFTTRN alias name?
First of all, you don't need to drop the database to change its alias. Re-cataloging the database with the desired alias would do the trick.
What is the backup image file name?
Changing Alias Name and trying to restore backup
The backup image filename is PS_TRN.0.db2inst1.NODE0000.CATN0000.20100804010119 .001.
Then you are issuing an incorrect command. It should be
restore db PS_TRN from . taken at 20100804010119 into PSFTTRN