Results 1 to 7 of 7
  1. #1
    Join Date
    Mar 2009
    Posts
    11

    Unanswered: backup - restore on cross platforms

    Hi guys,

    I just wanted to know whether we can take a backup in Windows and then restore the image in Linux.
    Windows XP with DB2 V 8.2
    Linux with DB2 V9.1

    Thanks in advance.

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    No, you can't. Use db2look and db2move.
    ---
    "It does not work" is not a valid problem statement.

  3. #3
    Join Date
    Mar 2009
    Posts
    11
    thanks ...Nick.

  4. #4
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    Have a look at the manual for the BACKUP and RESTORE commands. It describes which combinations are possible. (As Nick says, your's isn't.)
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  5. #5
    Join Date
    Jan 2009
    Location
    Zoetermeer, Holland
    Posts
    746
    Quote Originally Posted by n_i View Post
    No, you can't. Use db2look and db2move.
    Yes we can.
    Make an offline non-compressed backup on windows and do a redirected restore on linux. Should work if they both use the same CPU architecture.

  6. #6
    Join Date
    Jul 2006
    Location
    Pune , India
    Posts
    433
    Have you yourself tested this up ....as i have read in a number of articles about db2look/move approach for this case.

    Backup and restore operations between different operating systems and hardware platforms
    Rahul Singh
    Certified DB2 9 DBA / Application Developer

  7. #7
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    No, you can't. Restoring a backup taken on DB2 V8 for Windows on a Linux V9.1 system won't work because DB2 V9.1 doesn't support that: Backup and restore operations between different operating systems and hardware platforms And this hasn't changed yet in more recent DB2 versions as Rahul mentioned.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

Posting Permissions

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