Upgrading from IBM Db2 11.1 to IBM Db2 11.5.7 in Windows environment

To complete an upgrade from IBM® Db2® 11.1 to IBM Db2 11.5.7, 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.1 to Db2® 11.5.7 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. In Windows Explorer, go to the following directory: 
    C:\Db2_11.5.7_download_directory\SERVER_DEC\image
    Where Db2_11.5.7_download_directory is where you downloaded the Db2 installation files.
  8. Double-click the setup.exe file.
  9. On the Db2 Setup Launchpad navigation tree view, click Install a Product.
  10. On the Install a Product page, in the Db2 11.5.7 Server Editions section, click Work with Existing.
  11. In the Work with an Existing Db2 Copy window, select the Db2 copy for Db2 11.1.
  12. Click Launch Db2 Setup wizard.
  13. On the Warning window about upgrading Db2, click OK.
  14. In the Db2 Setup wizard, complete the following steps:
    1. On the Welcome page, click Next.
    2. On the Software License Agreement page, review and accept the license agreement, and click Next.
    3. On the Select the installation type page, select Typical and click Next.
    4. On the Select the installation, response file creation, or both page, keep the default selection and click Next.
    5. On the Installation folder page, click Next.
    6. On the Set the Db2 copy name page, click Next.
    7. On the Set user information for the default Db2 instance page, enter the correct user name and password values for the existing Db2 11.1 installation, and click Next.
    8. On the Enable operating system security for Db2 objects page, ensure that the settings and values are correct for the existing Db2 11.1 installation, and click Next.
    9. If the Warning window about existing group names is displayed, click OK.
    10. On the Start copying files and create response file page, click Finish.
    11. If Warning windows are displayed about a restart that is required to complete the setup, click OK.
    12. On the Setup is complete page, click Finish.
    13. In the Db2 First Steps page, click Do not create profile.
    14. Close the Db2 First Steps window.
  15. Apply the standard IBM Db2 license to activate Db2 and remove the trial license.
    • IBM Db2 Advanced Workgroup Server Edition license is no more available for latest db2 versions.
  16. In a Db2 command window, run the following command to upgrade the IBM Spectrum Control database to Db2 11.5.7: 
    db2 UPGRADE DATABASE database USER user_name USING password
    where database is the name of the IBM Spectrum Control database (usually TPCDB), user_name is the user who owns the Db2 instance where the database is located (usually db2admin), and password is the password that is associated with that user name.
  17. In a Db2 command window, run the following command to upgrade the Cognos Analytics (if installed) database to Db2 11.5.7: 
    db2 UPGRADE DATABASE database USER user_name USING password
    Where database is the name of the Cognos Analyticsdatabase (usually CM), user_name is the user who owns the Db2 instance where the database is located (typically db2admin), and password is the password that is associated with that user name. You might encounter the following message when you upgrade the Cognos Analytics database to Db2 11.5.7: 
    SQL0954C Not enough storage is available in the application heap to process the statement.
  18. Restart your computer and ensure that all of the Windows services for the IBM Spectrum Control servers, including Cognos Analytics are started.