Hi DBA's,
I am using DB2 UDB V6.1 on Windows NT 4.0 SP6a. I have a couple of databases to be dropped but i may need them in future. So I took a full offline backup of a database TEST and then dropped it. Now if I need to restore the database from the backup, how should i proceed??
I did the following:
1. Created again a database TEST and used 'RESTORE TO NEW' option and manually giving the backed up location. I got the error message SQL2542N.
2. I selected 'Restore' option and gave the information manually and still the same error message SQL2542N.
3. Used the option 'Create database from backup' and its not taking the alias saying that 'Alias "" is invalid' even though i gave a new alias name.
Can anyone throw light on how this problem can be dealt with. Only when I am able to restore the test database i can confidently proceed in dropping the other databases.
TIA
Sireesh.
