Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2009
    Posts
    23

    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:

    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

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    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?

  3. #3
    Join Date
    Apr 2009
    Posts
    23

    Changing Alias Name and trying to restore backup

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

    CC

  4. #4
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Then you are issuing an incorrect command. It should be
    Code:
    restore db PS_TRN from . taken at 20100804010119 into PSFTTRN

Posting Permissions

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