By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,287 Members | 1,309 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,287 IT Pros & Developers. It's quick & easy.

db2 backup issue on windows

P: n/a
I had a database on windows2000, it was a trial version. The license
got expired, so I took a full database backup. I reinstalled DB2 on my
machine. Now I am trying to restore the database from my backup file. I
am getting the error:

SQL2542N No match for a database image file was found based on
the source database alias "<database-alias>" and
timestamp "<timestamp>" provided.

I am giving the correct path for the restore.
Can someone please help me.

Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
ni************@yahoo.com wrote:
I had a database on windows2000, it was a trial version. The license
got expired, so I took a full database backup. I reinstalled DB2 on my
machine. Now I am trying to restore the database from my backup file. I
am getting the error:

SQL2542N No match for a database image file was found based on
the source database alias "<database-alias>" and
timestamp "<timestamp>" provided.

I am giving the correct path for the restore.
Can someone please help me.

Did you create the same instance to this backup?

cu,

indika
Nov 12 '05 #2

P: n/a
Say your image is backed up to the following path. It HAS to be there in
that path:
X:\BACKUPS\dbname.0\instname\node0000\catn0000\YYM MDD
The filename will be HHMMSS.001
Your restore command should be:
db2 restore database dbname from X:\backups taken at YYMMDDHHMMSS

If that was the only backup taken on that day then the YYMMDD should be
sufficient

I've done this quite a few times and it works.
HTH, Pierre.
--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
<ni************@yahoo.com> a écrit dans le message de news:
11*********************@g14g2000cwa.googlegroups.c om...
I had a database on windows2000, it was a trial version. The license
got expired, so I took a full database backup. I reinstalled DB2 on my
machine. Now I am trying to restore the database from my backup file. I
am getting the error:

SQL2542N No match for a database image file was found based on
the source database alias "<database-alias>" and
timestamp "<timestamp>" provided.

I am giving the correct path for the restore.
Can someone please help me.


Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.