Hi.. I use db2 udb v9.5 on AIX platform. now i need to shift the db to a windows box. is it possible to take a db back up from the AIX platform and restore the same on the windows platform?
-
-
DB2 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 and UNIX
* Little-endian Linux and UNIX
* Windows
Platform - Endianness
=============== ===
AIX® big endian
HP on IA64 big endian
Solaris x64 little endian
Solaris SPARC big endian
Linux on zSeries® big endian
Linux on pSeries® big endian
Linux on IA-64 little endian
Linux on AMD64 and Intel® EM64T little endian
32-bit Linux on x86 little endian
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 Universal Database(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 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 DB2 UDB V8 backup on a DB2 V9 database system, but you cannot restore a DB2 V9 backup on a DB2 UDB V8 database system.
You can restore a database from a backup image taken on a 32–bit level into a 64–bit level, but not vice versa. The DB2 backup and restore utilities should be used to backup and restore your databases. Moving a fileset from one machine to another is not recommended as this may compromise the integrity of the database.
In situations where certain backup and restore combinations are not allowed, you can move tables between DB2 databases using other methods:
* db2move command
* Export utility followed by the import or the load utilities
Thanks,
Shashank Kharche, IBM.
DB2 for Linux, Unix & Windows -Information Management Software
Comment