Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2010
    Posts
    40

    Unanswered: Backup and restore AS400 DB on Windows.

    Can I take a backup of DB2 DB on AS400 and restore it on Windows server?
    There should be a way but how difficult is that?

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    No, you cannot backup from anything and restore to windows. It has to do with the way windows works with directories. It also has to to with the little/big endian thing. Look in the manual for the limitations from backup from one OS and restore to another. You only option is db2move.

    Andy

  3. #3
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    The issue is more than different OS's. DB2 for iSeries (AS400) is a different product and backup files are not compatible with DB2 for Linux, UNIX, Windows.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  4. #4
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    And I am not even sure if they call it db backup on as400
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

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