为实现这个功能不是安装正常的FixPaks，而需要安装alternate FixPaks (AFPs)

alternate FixPaks(AFPs)作为一份完整的DB2 UDB ESE拷贝，安装时不会覆盖原来的安装目录。新的安装目录在AIX上是/usr/opt/db2_08_FPn，在其他平台上是/opt/IBM/db2/V8.FPn(n代表FixPak的数目)。alternate FixPaks的安装没有图形界面。

安装alternate FixPaks后同样使用db2iupdt来更新实例。如果要把高Fixpak的实例降到低Fixpak需要用db2iupdt的-D选项

测试

OS: Suse Linux V9 32 bit 2.6 Kernel for Intel

DB2 V8.1.9

DB2 V8.1.12

解开alternate FixPaks 文件FP12_MI00155_ESE_MFP.tar为ese.mfp目录

执行db2install安装成功后

原来V8.1.9在/opt/IBM/db2/V8.1目录

现在V8.1.12在/opt/IBM/db2/V8.FP12目录

将现有实例db2inst1升级到V8.1.12

db2level查看原来实例

/home/db2inst1>db2level

DB21085I Instance "db2inst1" uses "32" bits and DB2 code release "SQL08022"

with level identifier "03030106".

Informational tokens are "DB2 v8.1.2.88", "s050422", "MI00117", and FixPak "9".

Product is installed at "/opt/IBM/db2/V8.1"

执行./db2iupdt把实例update到FP12

HenrySuse:/opt/IBM/db2/V8.FP12/instance # ./db2iupdt -e db2inst1

db2inst1

DBI1070I Program db2iupdt completed successfully.

db2level查看update后的实例

/opt/IBM/db2/V8.FP12/instance>db2level

DB21085I Instance "db2inst1" uses "32" bits and DB2 code release "SQL08025"

with level identifier "03060106".

Informational tokens are "DB2 v8.1.2.112", "s060429", "MI00155", and FixPak

"12".

Product is installed at "/opt/IBM/db2/V8.FP12".

执行./db2iupdt把实例downgrade到FP9

HenrySuse:/opt/IBM/db2/V8.1/instance # ./db2iupdt -D -e db2inst1

db2inst1

DBI1070I Program db2iupdt completed successfully.

db2level查看downgrade后的实例:

/opt/IBM/db2/V8.FP12/instance>db2level

DB21085I Instance "db2inst1" uses "32" bits and DB2 code release "SQL08022"

with level identifier "03030106".

Informational tokens are "DB2 v8.1.2.88", "s050422", "MI00117", and FixPak "9".

Product is installed at "/opt/IBM/db2/V8.1".

参考资料

Alternate DB2 UDB FixPaks on UNIX-based systems

DB2 Fix Pack下载地址

ftp://ftp.software.ibm.com/ps/products/db2/fixes/

ftp://ftp.software.ibm.com/ps/products/db2/fixes2/

进入要下载FixPack目录后，Multiple Fix Pack要进入mtp目录