Hi Sireesh,
The error SQL2542N means No match for a database image file was found based
on the source database alias and timestamp provided.
You have to check the following things:
1. Check to make sure you gave the correct backed up location.
2. If there is more than one backup image in the same directory, the "TAKEN
AT" parameter requires the timestamp for the backup. The timestamp can be
exactly as it was displayed after the completion of a successful backup,
that is, the format yyyymmddhhnnss. If this parameter is not specified when
using ADSM, the latest the backup image is used for restoration.
- Narayan
-----Original Message-----
From: Sireesh Chandra M, STC Chennai [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 27, 2001 8:04 AM
To: [EMAIL PROTECTED]
Subject: DB2EUG: Restore database to new
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.
=====
To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
