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

DB2 Incremental BackUP / Restore problem from one machine to another

P: 2
Hi All,

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 on
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.
Alos 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.

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
Mar 21 '06 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.