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.