These days I was working on IBM DB2 database for windows with my .Net Application.
Now, it was required to backup database created on one machine to the other machine. I was also able to do it once. But now it is always giving me error while doing restore from other machine.
It gives me this Error:
SQL2542N No match for a database image file was found based onAlos I have give correct date and time stamp of which the backup is created. I don’t know what is the problem as I am new to DB2 and haven’t worked on it ever before.
the source database alias "DBTemp" and timestamp
"20060201172348" provided.
Explanation:
The backup image file filename consists of a database alias and a
timestamp component. A filename is constructed from the source
database alias and timestamp parameters provided in the Database
Restore call. No filename existed in the source directory that
matched based on the source database alias and timestamp
provided. If this error was received from an automatic
incremental restore then a required image was not found based on
the timestamp and location in the database history.
User Response:
Ensure that the database backup image resides on the media
source. Resubmit the operation by specifying a correct timestamp
to result in a match.
If this error was received from an automatic incremental restore,
check the database history for the corresponding backup entry
and verify that the location listed matches the actual location
of the backup image. Either update the database history and
retry the operation to result in a match or issue a RESTORE
INCREMENTAL ABORT command to cleanup any resources that may have
been created during processing.
I think it’s a problem of incremental backup. How can I set incremental backup off such that
Any DB2 DBA or any else may help me. Thanks guys.
- Prerak V. Shah