IBM Support

Using WebSphere InterChange Server V4.3.0.6 with DB2 V9

Question & Answer


Question

What changes are required on my system to use WebSphere InterChange Server V4.3.0.6 with DB2 V9?

Answer

When you use DB2 V9 or later on AIX or Solaris platforms, the DB2 driver cannot be found because the library path changed. You must manually update the CWSharedEnv.sh file on AIX and Solaris platforms, as follows (the modifications are marked in bold.)

DB2 V9.1 FP 5


if [ "${OS}" = "AIX" ]
then
LIBPATH=${JRE_BIN}:${JRE_LIB}:${CROSSWORLDS}/lib:${CROSSWORLDS}/bin:${JRE_BIN}/classic:${MQ_LIB}:${DB2_HOME}/lib32:${WREQUIRED}:$LIBPATH
export LIBPATH
LIBPATH_JAVA="-Djava.library.path=${LIBPATH}"
elif [ "${OS}" = "SOLARIS" ]
then
LD_LIBRARY_PATH=${JRE_BIN}:${JRE_LIB}:${CROSSWORLDS}/lib:${JRE_LIB}/sparc:${MQ_LIB}:${DB2_HOME}/lib32:${WREQUIRED}:$LD_LIBRARY_PATH
export LD_LIBRARY_PATH
LIBPATH_JAVA="-Djava.library.path=${LD_LIBRARY_PATH}"
fi


DB2 V9.5 FP 1

/********* change part 1 *********/
#DB2_LIB=${DB2_HOME}/java
DB2_DRIVER=${DB2_HOME}/java/db2java.zip
CWCLASSES=${WLICENSE}:${CORECW}:${DATAHANDLERS}:${DATADIRECT}:${DATAMANAGER}:${ITLM}:${JAVAMAIL}:${WEBSERVICES_JARS}:${DB2_DRIVER}
/******** end of change part 1 *****/
/********* change part 2 *********/
if [ "${OS}" = "AIX" ]
then
LIBPATH=${JRE_BIN}:${JRE_LIB}:${CROSSWORLDS}/lib:${CROSSWORLDS}/bin:${JRE_BIN}/classic:${MQ_LIB}:${DB2_HOME}/lib32:${WREQUIRED}:$LIBPATH
export LIBPATH
LIBPATH_JAVA="-Djava.library.path=${LIBPATH}"
elif [ "${OS}" = "SOLARIS" ]
then
LD_LIBRARY_PATH=${JRE_BIN}:${JRE_LIB}:${CROSSWORLDS}/lib:${JRE_LIB}/sparc:${MQ_LIB}:${DB2_HOME}/lib32:${WREQUIRED}:$LD_LIBRARY_PATH
export LD_LIBRARY_PATH
LIBPATH_JAVA="-Djava.library.path=${LD_LIBRARY_PATH}"
fi
/******** end of change part 2 *****/

[{"Product":{"code":"SSBTEG","label":"WebSphere InterChange Server"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"--","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF027","label":"Solaris"}],"Version":"4.3.0.6","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

Modified date:
23 June 2018

UID

swg21404492