Backup and restore operations between different operating systems and hardware platforms

Db2® database systems support some backup, restore, and rollforward operations between different operating systems and hardware platforms.

The supported platforms for Db2 backup, restore, and rollforward operations can be grouped into one of three families:
  • Big-endian Linux® and UNIX
  • Little-endian Linux and UNIX
  • Windows

A database backup from one platform family can only be restored and rolled forward to a system within the same platform family. If the backup is compressed or encrypted, the decompression or decryption library that is stored in the backup image cannot be loaded on the target system. This restriction is due to the differing CPU architectures of the source and target systems. To avoid this situation, specify a library to use. For example, if the backup was taken using the default Db2 compression library on a Linux on AMD64 system and you wish to restore on a Linux on IBM Power Systems for Little Endian system, use the command db2 RESTORE DB MYDB COMRLIB libdb2compr.so.

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 1. Endianness of supported Linux and UNIX operating systems Db2 supports
Platforms Support Restrictions Endianness
AIX®   Big endian
HP on IA64 Only supported for Db2 version 10.5 images or lower Big endian
Solaris SPARC Only supported for Db2 version 10.5 images or lower Big endian
Linux on zSeries   Big endian
Linux on IBM® Power Systems Only supported for Db2 version 10.5 images or lower Big endian
Linux on IBM Power Systems for Little Endian   Little endian
Linux on IA-64   Little endian
Linux on AMD64 and Intel EM64T   Little endian
32-bit Linux on x86 Only supported for Db2 version 10.5 images or lower Little endian
Note: A backup from a newer version of Db2 cannot be restored into an earlier version of Db2. A backup from an earlier version of Db2 can be restored into a later version of Db2 (an UPGRADE operation will be triggered automatically at the end of the restore operation to update the database to the current version). For example, you cannot restore a Db2 Version 10.5 backup into a Db2 Version 10.1 database system. However, you can restore a Db2 Version 10.1 backup into a Db2 Version 10.5 database system (please see Planning to upgrade Db2 servers for pre-requisites and tasks required to achieve successful upgrades). A Rollforward operation through recovery log files that were generated on an earlier version of Db2 is not supported. Please see Recovering Through a Database Upgrade for more details on recovering through database upgrade operations. Please see Compatibility between DB2 for LUW Version 11.1 Mod-Packs and Fix-Packs for details of backup, restore, and rollforward support through modification packs.
Note: You can restore a database from a backup image that was taken on a 32-bit level into a 64-bit level, but not reversibly. The Db2 backup and restore utilities should be used to back up and restore your databases. Moving a file set from one machine to another is not recommended as this can 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:
  • The db2move command
  • The export command followed by the import or the load command
Note: Database configuration parameters are set to their defaults if the values in the backup are outside of the allowable range for the environment in which the database is being restored.