Update: DB2 v11.1 FP5 to FP6
Files to require
- v11.1.4fp6_aix64_universal_fixpack.tar.gz ---> For AIX
- v11.1.4fp6_linuxx64_universal_fixpack.tar.gz ---> For Linux
- v11.1.4fp6_ntx64_rtcl.exe ---> For Windows Client
FixPack 更新程序
1. 確認目前安裝的 FixPack 與路徑
# su - root
# /opt/IBM/db2/V11.1/install/db2ls
Install Path Level Fix Pack Special Install Number Install Date Installer UID
---------------------------------------------------------------------------------------------------------------------
/opt/IBM/db2/V11.1 11.1.4.5 5 Sun Sep 26 03:57:30 2021 EDT 0
2. 解開 FixPack 6
# gunzip -dc v11.1.4fp6_aix64_universal_fixpack.tar.gz |tar -xf -
3. 將 FixPack 6 安裝至另個路徑
# cd <FixPack6_path>/universal
# ./installFixPack -b /opt/IBM/db2/V11.1 -p /opt/IBM/db2/V11.1_2 -y -l /tmp/db2fp6.out
4. 再確認目前安裝的 FixPack 與路徑
# /opt/IBM/db2/V11.1/install/db2ls
Install Path Level Fix Pack Special Install Number Install Date Installer UID
---------------------------------------------------------------------------------------------------------------------
/opt/IBM/db2/V11.1 11.1.4.5 5 Sun Sep 26 03:57:30 2021 EDT 0
/opt/IBM/db2/V11.1_2 11.1.4.6 6 Sun Sep 26 04:30:09 2021 EDT 0
5. 停止 db2 instance
# su - instance_user
# db2stop
6. 更新 db2 instance
# su - root
# cd /opt/IBM/db2/V11.1_2/instance
# ./db2iupdt instance_user
7. 確認 db2 instance 狀況
# su - instance_user
# db2level
# db2licm -l
# db2start
8. Update the system catalog objects (只需再 Primary DB 執行)
# su - instance_user
# db2updv111 -d database_name
9. Binding bind files after installing fix packs (只需再 Primary DB 執行)
# su - instance_user
# db2 connect to database_name
# cd sqllib/bnd
# db2 BIND db2schema.bnd BLOCKING ALL GRANT PUBLIC SQLERROR CONTINUE
# db2 BIND @db2ubind.lst BLOCKING ALL GRANT PUBLIC ACTION ADD
# db2 BIND @db2cli.lst BLOCKING ALL GRANT PUBLIC ACTION ADD
Optional: Validate the installation
# su - root
# cd /opt/IBM/db2/V11.1_2/bin/
# ./db2val -o
DBI1379I The db2val command is running. This can take several minutes.
DBI1335I Installation file validation for the DB2 copy installed at
/opt/IBM/db2/V11.1_2 was successful.
DBI1343I The db2val command completed successfully. For details, see
the log file /tmp/db2val-211005_172717.log.