473,606 Members | 3,100 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

DB2 Incremental BackUP / Restore problem from one machine to another

2 New Member
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 4287

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

Similar topics

1
3469
by: Jimmy Chen | last post by:
Recently I've done a db2 backup and restore/recovery, but the process for recovering the database was different than what I thought to be. here is what I did: DB2 is set in online mode - backup - * backup db2 in full * insert record
3
3147
by: apple | last post by:
UDB v8 fp 6a on AIX 5.1.0.0 Below is a manual incremental recover from compressed backup datasets. With external compress backup datasets, can it be coded to do an automatic incremental recover? The manual incremental recover works just fine, but having trouble getting the automatic incremental recover to work. Thanks for your help # INCREMENTAL BACKUP
5
5428
by: Anurag | last post by:
Hello, I wish to find out the restore method for database that have been incrementally backed up and in the scenario where just the delta has been backed up. For example sake, let us assume the following 2 scenarios: (1) Delta Backup of database "delta_db" Full offline backup of database "delta_db" is taken on Dec 15 and then offline delta backup is taken every day till Dec 19. If "delta_db" crashes on Dec 20, what steps do I follow...
6
3665
by: Raj | last post by:
How can we do an online restore of a tablespace using the incremental backup's? we are on a partitioned database... Also, how could we use backup copy made by the load (using the copy to option in load) to revover the tablespace? Thanks, Raj
9
2875
by: gabe101 | last post by:
I've searched enough to know that this ability probably doesn't exist in our current setup, thus the reason I'm coming to the community now. When doing a database backup in Enterprise Manager (SQL Server 2000 sp4), is there a priority level setting so that I can put less load on the CPU? Our small office uses one server for everything and when I do a 12:00 pm full backup of our live DB, the server slows to a crawl for about 4 or 5...
2
2976
by: rdemyan via AccessMonster.com | last post by:
For some of my really important tables, I have backup tables in the backend file. The idea is that if a user accidentally screws up data, they can go to a form and restore from the backup table (as opposed to having to use a backup copy of the back-end). In the past, for the table backup operation, I was simply deleting all of the data from the table backup and then using an append query of data from the main table. To restore, I was...
3
2838
by: Jurgen Haan | last post by:
Hi all. Yesterday we decided to switch from full online nightly backups to the following schema: sun: full online mon-sat: incremental online. Important to note; we don't use deltas. Well it seems to work.
3
2616
by: aka | last post by:
Hi, I'm actually working on the migration of a DB2 unicode db (V8.2 FP 15) from a Sunfire machine with SunOS (64 bit, Big-endian) to an AIX 5.3 (64-bit, Big-endian) server located in US. The target server has DB2 V8.2 FP 15 installed and instance name and filesystem user groups rights an so on are all identical. From the manuals I see that a crossplatform backup-restore should be supported between the two systems. I did a full offline...
1
1837
by: lhemski | last post by:
Guys, im using dB2 Version 9. I perform all the re-configuration of database parameter for incremental backup. I perform initial full backup and after adding some records, i perform incremental delta backup. Now, my problem is i already restore the full backup on different server/computer. But, the incremental delta backup cant be restored. For all the expert here, kindly guide me step by step how to perform incremental restoration. This will be...
0
7978
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
8461
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
8448
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
8317
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
5987
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
4010
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2454
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
1
1572
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
1313
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.