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

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