Restore between Platforms

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • graju80
    New Member
    • May 2007
    • 5
    #1

    Restore between Platforms

    Hello Gurus, Question..
    I tried to restore a backup AIX's DB2 db in Linux's DB2 same version and fixpack... but get error saying...



    SQL2570N A database cannot be restore on a platform that does not match the platform on which the backup image was created


    Is there a better or alternate ways to do this??
    Tags: None
    • yrayanki
      New Member
      • Nov 2006
      • 6
      #2
      Backup and restore operations between different operating systems and hardware platforms

      DB2(R) database systems support some backup and restore operations between different operating systems and hardware platforms.

      The supported platforms for DB2 backup and restore operations can be grouped into one of three families:

      * Big-endian Linux(R) and UNIX(R)
      * Little-endian Linux and UNIX
      * Windows(R)

      A database backup from one platform family can be restored on any system within the same platform family. For Windows operating systems, you can restore a database created on DB2 UDB V8 on a DB2 Version 9 database system. For Linux and UNIX operating systems, as long as the endianness (big endian or little endian) of the backup and restore platforms is the same, you can restore backups that were produced on DB2 UDB V8 on DB2 Version 9.

      The following table shows each of the Linux and UNIX platforms DB2 supports and indicates whether the platforms are big endian or little endian:
      Table 36. Endianness of supported Linux and UNIX operating systems DB2 supports Platform Endianness
      AIX(R) big endian
      HP-UX big endian
      HP on IPF big endian
      Solaris Operating environment big endian
      Linux on zSeries big endian
      Linux on Power PC big endian
      Linux on IA-64 little endian
      Linux on AMD64 and Intel(R) EM64T little endian
      32-bit Linux on x86 little endian

      The target system must have the same (or later) version of the DB2 database product as the source system. You cannot restore a backup created on one version of the database product to a system running an earlier version of the database product. For example, you can restore a V8 backup on a V9 database system, but you cannot restore a V9 backup on a V8 database system.

      In situations where certain backup and restore combinations are not allowed,
      * db2move commandyou can move tables between DB2 databases using other methods:

      * Export utility followed by the import or the load utilities

        Comment

        Previous template Next
        Working...