db2 backup issue on windows

[nishuverma2001@yahoo.com]

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.

[indika]

Re: db2 backup issue on windows

nishuverma2001@ yahoo.com wrote:[color=blue]
> 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.
>[/color]
Did you create the same instance to this backup?

cu,

indika

[Pierre Saint-Jacques]

Re: db2 backup issue on windows

Say your image is backed up to the following path. It HAS to be there in
that path:
X:\BACKUPS\dbna me.0\instname\n ode0000\catn000 0\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.
--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
<nishuverma2001 @yahoo.com> a écrit dans le message de news:
1117458825.4121 79.66920@g14g20 00...legro ups.com...[color=blue]
>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.
>[/color]