If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > incremental restore error ( cross-platform)

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 06-02-11, 13:07
db2user24 db2user24 is offline
Registered User
 
Join Date: Nov 2007
Posts: 248
incremental restore error ( cross-platform)

Hi,

I'm restoring backup images from one OS ( 32-bit) to another ( 64-bit) and am using the compression library on the target OS to perform the restore...

I was able to successfully restore from the full backup image with this command ---


db2 restore db dbname from /DATA/backup taken at 20110501050002 logtarget /home/db2inst1/logs/ REPLACE EXISTING COMPRLIB /home/db2inst1/sqllib/lib/libdb2compr.so


But when I try to restore from an incremental, it fails... any idea why?


db2 restore db dbname incremental automatic from /DATA/backup taken at 20110602050003 logtarget /home/db2inst1/logs REPLACE EXISTING COMPRLIB /home/db2inst1/sqllib/lib/libdb2compr.so
SQL2570N A database cannot be restored on a platform that does not match the
platform on which the backup image was created.
Reply With Quote
  #2 (permalink)  
Old 06-02-11, 13:51
n_i n_i is offline
:-)
 
Join Date: Jun 2003
Location: Toronto, Canada
Posts: 4,449
I suspect that, since you chose automatic restore, the subordinate restore commands may be issued with the default compression library, which may not work. Try doing a manual restore, specifying the correct library each time.
Reply With Quote
  #3 (permalink)  
Old 06-02-11, 13:54
db2user24 db2user24 is offline
Registered User
 
Join Date: Nov 2007
Posts: 248
thanks! will try that out..
Reply With Quote
  #4 (permalink)  
Old 06-04-11, 07:55
db2girl db2girl is offline
∞∞∞∞∞∞
 
Join Date: Aug 2008
Location: Toronto, Canada
Posts: 1,816
Quote:
Originally Posted by db2user24 View Post

I'm restoring backup images from one OS ( 32-bit) to another ( 64-bit)

But when I try to restore from an incremental, it fails... any idea why?

"Incremental images and images only capturing differences from the time of the previous capture (called a "delta image") cannot be restored when there is a difference in operating systems or word size (32-bit or 64-bit)."

DB2 Universal Database
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On