Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2007
    Posts
    265

    Unanswered: 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.

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    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.

  3. #3
    Join Date
    Nov 2007
    Posts
    265
    thanks! will try that out..

  4. #4
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •