WebSphere Commerce Version 8.0.1.0 or later

Upgrading runtime environments to use IBM Db2 Version 11.1

IBM Db2 Version 11.1 is only supported on WebSphere Commerce Version 8 Mod Pack 1 (8.0.1.0) or later. To use WebSphere Commerce on IBM Db2 Enterprise Server Edition Version 11.1.x, you must install WebSphere Commerce with IBM Db2 Version 10.5 first, and then create an instance on the Version 10.5 database. Only then can you upgrade your database to Version 11.1.x.

Note: IBM Db2 Version 11. includes new optimization and has different performance characteristics designed to support high load environments with high concurrency.

Before you begin

  1. Ensure that you have an existing WebSphere Commerce instance running on IBM Db2 Version 10.5.0.5 or a later 10.5 fix pack.
  2. Ensure that you are on WebSphere Commerce Version 8 Mod Pack 1 (8.0.1.0) or later. If you need to upgrade to a higher Mod Pack, see Installing maintenance package for WebSphere Commerce.

Procedure

  1. Upgrade your IBM Db2 database to Version 11.1 by following the steps in the IBM Db2 documentation.

    For information, see Installing IBM data server clients and drivers.

Update your existing WebSphere Commerce environment settings. WebSphere Commerce references the Db2 installation directory in its library path setting and JDBC driver classpath setting.
  1. Open the following file in a text editor:
    • LinuxAIXWC_installdir/bin/setenv.sh
    • WindowsWC_installdir/bin/setenv.bat
  2. Change all occurrences of the string /IBM/db2/V10.5 to /IBM/db2/V11.1.
  3. LinuxAIX Open WC_installdir/bin/wcnonroot.sh file in a text editor.
  4. LinuxAIX Change DBDIR=/IBM/db2/V10.5 to DBDIR=/IBM/db2/V11.1.
  5. Modify the environment variable DB2_JDBC_DRIVER_PATH in the WebSphere Application Server administrative console.
    1. Open the Administrative Console..
    2. Select Environment > WebSphere Variables > DB2_JDBC_DRIVER_PATH.
    3. Set the DB2_JDBC_DRIVER_PATH to the DB2 V11.1 path.
      For example, change the existing value from:

      /IBM/db2/V10.5/java

      to:

      /IBM/db2/V11.1/java

  6. Update the DB2 JDBC native library path.
    • LinuxAIXThe DB2 JDBC library path is set in the WebSphere Commerce non-root user's .profile and .bash_profile files. The library paths must be changed to point to the DB2 V11.1 path. For example, change the existing value from:

      LD_LIBRARY_PATH=/IBM/db2/V10.5/lib64

      to:

      LD_LIBRARY_PATH=/IBM/db2/V11.1/lib64

    • WindowsSet the DB2 JDBC library path in the Windows system environment variable PATH. Change the PATH setting to point to the DB2 V11.1 path.

      For example, change the existing value from:

      PATH=DB2_version_10.5_installdir/BIN

      to:

      PATH=DB2_version_11.1_installdir/BIN