471,863 Members | 1,552 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,863 software developers and data experts.

DB2 Incremental BackUP / Restore problem from one machine to another

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
0 4025

Post your reply

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

Similar topics

3 posts views Thread by apple | last post: by
9 posts views Thread by gabe101 | last post: by
2 posts views Thread by rdemyan via AccessMonster.com | last post: by
3 posts views Thread by Jurgen Haan | last post: by
3 posts views Thread by aka | last post: by
NeoPa
reply views Thread by NeoPa | last post: by
reply views Thread by YellowAndGreen | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.