I am having this problem restoring backup image copy from instance1 to instance2. Both instances are on the same machine using the same DB2 copy, and both instances have the same database name but different database aliases. This restore is to setup my HADR test pair on my laptop. So I issue the following restore command:
>db2 RESTORE DATABASE GSDB FROM "C:\TEMP" TAKEN AT 20120909082454 WITH 2 BUFFERS BUFFER 1024 REPLACE HISTORY FILE PARALLELISM 1 WITHOUT PROMPTING
and I got the following error:
>SQL1005N The database alias "GSDB" already exists in either the local database directory or system database directory.
A db2 list DB directory shows that I don't have any database with alias GSDB. But I have three cataloged DBs with the same name of GSDB.
So, how can I restore this database while avoiding the "SQL1005N The database alias "GSDB" already exists" issue?
I'll appreciate any assistance on this issue.