Restore between Platforms

[graju80]

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??

[yrayanki]

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