Upgrading from IBM Db2 11.5.8 to IBM Db2 11.5.9 in Windows environment

To complete an upgrade from IBM® Db2® 11.5.8 to IBM Db2 11.5.9 in a windows environment, stop the IBM Spectrum Control servers before you begin the upgrade procedure.

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 on a Windows operating system.

Procedure

  1. Stop all of the Windows services for the IBM Spectrum Control servers, including IBM Cognos Analytics (if you installed it on your system).
  2. In a Db2 command window, run the following commands to force all users or applications to disconnect from Db2: 
    db2 force application all
db2 terminate
  3. In a Db2 command window, run the following command to ensure that no applications are accessing Db2: 
    db2 list applications
  4. Create a directory to back up the database.
    For example: C:\downloads\db2_backup
  5. In a Db2 command window, run the following command: 
    db2 BACKUP DATABASE database to C:\downloads\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.
  6. Stop all Db2 Windows services and exit Db2 in the Windows System Tray.
  7. Extract the downloaded DB2 11.5.9 image in a directory. For example, C:\Db2_11.5.9_download_directory\ .
  8. Double-click the setup.exe file to start the Db2 installer.
  9. On the Db2 Setup Launchpad navigation tree view, click Install a Product.
  10. On the Install a Product page, under Db2 11.5.9.0 Server Editions, click Work with Existing.
  11. In the Work with an Existing Db2 Copy window, select the Db2 copy for Db2 11.5.8 then click Launch Db2 Setup.
  12. On the warning window about upgrading Db2, click OK.
  13. In the Db2 Setup wizard, complete the following steps:
    1. Click Next on the Welcome page.
    2. Click Next on the Setup is complete page.
    3. On the Install Additional Products page, click Finish. You are prompted to restart the system. Choose the desired option.
  14. Restart your computer and ensure that all of the Windows services for the IBM Spectrum Control servers and Db2 services, including Cognos Analytics are started.
  15. After upgrading the Db2 version, open the Db2 command window and run the db2level command to confirm the updated Db2 version. Ensure that the command output displays the precise upgraded Db2 version.