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:

Alias: PS_TRN
Database: PSFTTRN

I want it to be:
Alias: PSFTTRN
Database: PSFTTRN

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?

Thank you.

CC

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?

The backup image filename is PS_TRN.0.db2inst1.NODE0000.CATN0000.20100804010119 .001.

CC

Then you are issuing an incorrect command. It should be