[@more@]

為實現這個功能不是安裝正常的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".

參考資料

DB2 Fix Pack下載地址

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

進入要下載FixPack目錄後，Multiple Fix Pack要進入mtp目錄