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
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 for Linux, UNIX, and Windows Version
9.5 on a DB2 Version 9.7 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 for Linux, UNIX, and Windows Version
9.5 on a DB2 Version 9.7 system.
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 supportsPlatform |
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 |
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 for Linux, UNIX, and Windows Version
9.5 backup on a DB2 Version
9.7 database system, but you cannot restore a DB2 Version 9.7 backup on a DB2 Version 9.5 database system.
Note: 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
Note: Database
configuration parameters will be set to their defaults if the values
in the backup are outside of the allowable range for the environment
the database is being restored on.