跨平台restore问题
win64位db29.5机器的镜像重定向到一台linux64位db29.7机器,报错如下:
[db2inst1@wl01 programs]$ db2 "restore db hyl3 from /tmp/programs into l3td redirect generate script restore.l3td without rolling forward"
SQL2570N An attempt to restore on target OS "Linux-x86-64" from a backup
created on source OS "NT-32" failed due to the incompatibility of operating
systems or an incorrect specification of the restore command. Reason-code:
"1".
在linux64位机器上执行db2level结果如下:
[db2inst1@wl01 programs]$ db2level
DB21085I Instance "db2inst1" uses "64" bits and DB2 code release "SQL09075"
with level identifier "08060107".
Informational tokens are "DB2 v9.7.0.5", "s111017", "IP23292", and Fix Pack
"5".
Product is installed at "/opt/ibm/db2/V9.7".
在win64位机器上执行db2level结果如下:
C:Program Files (x86)IBMSQLLIBBIN>db2level
DB21085I 实例 "DB2" 使用 "32" 位和 DB2 代码发行版 "SQL09057"，级别标识为
"06080107"。
参考标记为 "DB2 v9.5.700.579"、"s101129" 和 "IP23137"，修订包为 "7"。
产品使用 DB2 副本名 "DB2COPY1" 安装在 "C:PROGRA~2IBMSQLLIB" 中。
这样能restore吗?
[db2inst1@wl01 programs]$ db2 "restore db hyl3 from /tmp/programs into l3td redirect generate script restore.l3td without rolling forward"
SQL2570N An attempt to restore on target OS "Linux-x86-64" from a backup
created on source OS "NT-32" failed due to the incompatibility of operating
systems or an incorrect specification of the restore command. Reason-code:
"1".
在linux64位机器上执行db2level结果如下:
[db2inst1@wl01 programs]$ db2level
DB21085I Instance "db2inst1" uses "64" bits and DB2 code release "SQL09075"
with level identifier "08060107".
Informational tokens are "DB2 v9.7.0.5", "s111017", "IP23292", and Fix Pack
"5".
Product is installed at "/opt/ibm/db2/V9.7".
在win64位机器上执行db2level结果如下:
C:Program Files (x86)IBMSQLLIBBIN>db2level
DB21085I 实例 "DB2" 使用 "32" 位和 DB2 代码发行版 "SQL09057"，级别标识为
"06080107"。
参考标记为 "DB2 v9.5.700.579"、"s101129" 和 "IP23137"，修订包为 "7"。
产品使用 DB2 副本名 "DB2COPY1" 安装在 "C:PROGRA~2IBMSQLLIB" 中。
这样能restore吗?
8同行回答
回复 5# xu5762173
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 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-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® EM64T little endian
32-bit Linux on x86 little endian
只要endian 一样 ，就可以restore收起
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 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-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® EM64T little endian
32-bit Linux on x86 little endian
只要endian 一样 ，就可以restore收起
浏览1513