db2 backup issue on windows

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

nishuverma2001@yahoo.com - 30 May 2005 14:13 GMT

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.

Reply to this Message

indika - 30 May 2005 14:15 GMT

> 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
[quoted text clipped - 7 lines]
> 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

Reply to this Message

Pierre Saint-Jacques - 30 May 2005 16:03 GMT

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\YYMMDD
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.

Signature

Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515

>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
[quoted text clipped - 7 lines]
> I am giving the correct path for the restore.
> Can someone please help me.

Reply to this Message