Upgrading from IBM Db2 11.5.8 to IBM Db2 11.5.9 in Linux or AIX environment

To complete an upgrade from IBM® Db2® 11.5.8 to IBM Db2 11.5.9 in Linux or AIX environment, stop the IBM Spectrum Control servers before you begin the upgrade.

About this task

You can upgrade to the latest version of Db2 that IBM Spectrum® Control supports before you install the latest version of IBM Spectrum Control.

Important: The following steps are an example of one way to upgrade from Db2 11.5.8 to Db2 11.5.9 in an AIX® or Linux® environment.

Procedure

Stop all IBM Spectrum Control servers, including IBM Cognos Analytics if installed.
Switch user to the Db2 instance owner (usually db2inst1) by using command su - db2inst1.
From a command shell, run the following commands to force all users or applications to disconnect from Db2:
```
db2 force application all
```
```
db2 terminate
```
From a command shell, run the following command to ensure that no applications are accessing Db2:
```
db2 list applications
```
Create a directory to backup the database.
For example: /tmp/db2_backup
From a command shell, run the following command:
```
 db2 BACKUP DATABASE database to /tmp/db2_backup
```
where database is the name of the IBM Spectrum Control database (usually TPCDB). If the Cognos Analytics database is installed (usually CM), make a similar backup of that database.
From a command shell, run the following command:
```
db2stop
```
Switch user back to root by using commnd su - root.
Extract the downloaded DB2 v11.5.9 fixpack in a directory. For example, /root/download. From the shell command, run the installfixpack from Db2 11.5.9 extracted directory.
Accept the license agreement.
Enter the full path of base installation directory of db2 11.5.8. For example: /opt/ibm/db2/V11.5.
Select No when prompted for "Do you want to choose a different installation directory for the fix pack"
Wait for the installation process to complete successfully.
Start the Db2 installer.
On the Db2 Setup Launchpad, click Work with Existing in the navigation tree view.
Select the Db2 installation path entered in the step 10.
Select the version as Db2 version 11.5.9.0 server Edition and click Next.
Select the installation type and proceed by clicking Next.
Select Configure new function for an existing Db2 instance, select the instance name, and click next.
Select Install Db2 server edition on this computer and save the settings in a response file. Specify the response file location.
Verify and confirm the summary section for installation location and instance name, then click finish.
Switch user to the Db2 instance owner (usually db2inst1) by running command su - db2inst1. Execute the db2level command to verify the new Db2 version.
From a command shell, run the following command:
```
db2start
```
Switch user back to root.
Start all of the IBM Spectrum Control servers, including Cognos Analytics (if you installed it on your system).