
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
- 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.
- 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
-
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.
-
Open the following file in a text editor:
WC_installdir/bin/setenv.sh
WC_installdir/bin/setenv.bat
- Change all occurrences of the string /IBM/db2/V10.5 to /IBM/db2/V11.1.
Open WC_installdir/bin/wcnonroot.sh file in a text editor.
Change DBDIR=/IBM/db2/V10.5 to DBDIR=/IBM/db2/V11.1.
-
Modify the environment variable DB2_JDBC_DRIVER_PATH in the WebSphere
Application Server administrative console.
-
Update the DB2 JDBC native library path.
The 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
Set 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