# 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<br></br># /opt/IBM/db2/V11.1/install/db2ls<br></br><br></br>Install Path                       Level   Fix Pack   Special Install Number   Install Date                  Installer UID<br></br>---------------------------------------------------------------------------------------------------------------------<br></br>/opt/IBM/db2/V11.1               11.1.4.5        5                            Sun Sep 26 03:57:30 2021 EDT             0<br></br>
```

2\. 解開 FixPack 6

```
# gunzip -dc v11.1.4fp6_aix64_universal_fixpack.tar.gz |tar -xf -
```

3\. 將 FixPack 6 安裝至另個路徑

./installFixPack -b &lt;current-installation-dir&gt; -p &lt;install-FP-dir&gt; -y -l /tmp/db2fp.out

```
# cd  <FixPack6_path>/universal<br></br># ./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<br></br><br></br>Install Path                       Level   Fix Pack   Special Install Number   Install Date                  Installer UID<br></br>---------------------------------------------------------------------------------------------------------------------<br></br>/opt/IBM/db2/V11.1               11.1.4.5        5                            Sun Sep 26 03:57:30 2021 EDT             0<br></br>/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<br></br># db2stop
```

6\. 更新 db2 instance

```
# su - root<br></br># cd /opt/IBM/db2/V11.1_2/instance<br></br># ./db2iupdt instance_user
```

7\. 確認 db2 instance 狀況

```
# su - instance_user<br></br># db2level<br></br># db2licm -l<br></br><br></br># db2start
```

8\. Update the system catalog objects (只需再 Primary DB 執行)

```
# su - instance_user<br></br># db2updv111 -d  database_name
```

9\. Binding bind files after installing fix packs (只需再 Primary DB 執行)

```
# su - instance_user<br></br># db2 connect to  database_name<br></br><br></br># cd  sqllib/bnd<br></br># db2 BIND db2schema.bnd BLOCKING ALL GRANT PUBLIC SQLERROR CONTINUE <br></br># db2 BIND @db2ubind.lst BLOCKING ALL GRANT PUBLIC ACTION ADD <br></br># db2 BIND @db2cli.lst BLOCKING ALL GRANT PUBLIC ACTION ADD 
```

##### Optional: Validate the installation

```
# su - root<br></br># cd /opt/IBM/db2/V11.1_2/bin/<br></br># ./db2val -o<br></br><br></br>DBI1379I  The db2val command is running. This can take several minutes.<br></br><br></br>DBI1335I  Installation file validation for the DB2 copy installed at<br></br>      /opt/IBM/db2/V11.1_2 was successful.<br></br><br></br>DBI1343I  The db2val command completed successfully. For details, see<br></br>      the log file /tmp/db2val-211005_172717.log.
```