Troubleshooting
Problem
The MDM operational server (EBA) does not start in IBM® InfoSphere® Master Data Management (InfoSphere® MDM) deployments that use IBM® Db2® 11.5.
Note that the issue does not occur when IBM® Db2® 11.5.8 (which comes with DB2 JDBC Driver Version 4.32.28) is used with MDM.
Symptom
This issue also causes the following exception when you perform a connection test on the data sources DWLConfig, DWLCustomer, and MDM:
java.sql.SQLException: DSRA8102E: DataSource class cannot be used as two-phase: ClassCastException: com.ibm.db2.jcc.DB2XAConnection incompatible with java.sql.Connection
Environment
This issue occurs when InfoSphere® MDM is installed with IBM® Db2® 11.5 as the database.
Resolving The Problem
Until the fix is released to resolve this issue, complete the following steps:
- Download the IBM® Db2 11.1.x.x client that contains the JDBC libraries.
- Set the class path at the JDBC Providers for Physical and Virtual MDM to point to the location where the Db2® 11.1.x.x client is installed. Follow one of these approaches to modify the value:
- If you can use Db2® 11.1.x.x client libraries for all applications installed on WebSphere Application Server, set the value of the WebSphere Variable DB2_JDBC_DRIVER_PATH to <DB2_CLIENT_INSTALL_DIRECTORY>/java, where <DB2_CLIENT_INSTALL_DIRECTORY> is the directory to which you downloaded Db2® 11.1.x.x. Log in to the WebSphere Application Server Console, expand Environment, click WebSphere Variables, set the scope to the Node, and then modify the value for DB2_JDBC_DRIVER_PATH.
- If the Db2® 11.1.x.x client can be used only with the MDM application, log in to the WebSphere Application Server Console, expand Resources > JDBC, click JDBC Provider, open the Db2® Universal JDBC Driver Provider corresponding to the JDBC Provider for Virtual MDM, and provide the value for the class path as <DB2_CLIENT_INSTALL_DIRECTORY>/java, where <DB2_CLIENT_INSTALL_DIRECTORY> is the directory into which you downloaded Db2® 11.1.x.x. Complete the same steps for the JDBC Provider for Physical MDM.
- Alternatively, perform steps 1 and 2 using Db2® 11.5.8.0 client that comes with DB2 JDBC Driver Version 4.32.28.
- Synchronize the nodes and save.
- Restart the application servers.
Document Location
Worldwide
[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSWSR9","label":"IBM InfoSphere Master Data Management"},"ARM Category":[{"code":"a8m0z000000cvpMAAQ","label":"Database, JDBC, ODBC"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"12.0.0"}]
Was this topic helpful?
Document Information
Modified date:
25 May 2023
UID
ibm16430179