Update: DB2 v11.1 FP5 to FP6

Files to require
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 安裝至另個路徑

./installFixPack -b <current-installation-dir> -p <install-FP-dir> -y -l /tmp/db2fp.out

# 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.



Revision #3
Created 13 May 2022 08:16:45 by Admin
Updated 1 August 2022 07:43:47 by Admin