XCOMU3542E remote DB2 database- Drivers for the selected database are not found

Products

• XCOM Data Transport
• XCOM Data Transport - Linux PC

Issue/Introduction

These error are displayed when trying to configure a remote database for xcom:
 com.ibm.db2.jcc.DB2Driverjava.lang.ClassNotFoundException ExceptionMessage=[com.ibm.db2.jcc.DB2Driver]

 No suitable driver found for jdbc:db2://xx.xx.xxx.xx:50001/XCOMTRSTjava.sql.SQLException ExceptionMessage=[No suitable driver found for jdbc:db2://xx.xx.xxx.xx:50001/XCOMTRST]

Drivers for the selected database are not found.com.ca.xcom.standalone.base.util.DataSourceException ExceptionMessage=[Drivers for the selected database are not found.]

XCOMU3542E Error in getting Remote Systemcom.ca.xcom.standalone.base.util.DataSourceException ExceptionMessage=[com.ca.xcom.standalone.base.util.DataSourceException: Drivers for the selected database are not found.]

Environment

XCOM™ Data Transport® for Linux PC

Cause

ODBC was not installed

Resolution

Check the connectivity to the DB2 and that XCOMTRST database with a utility called ISQL to check that connection.

If you don't have the ODBC install it and check that you can connect outside of XCOM GUI to the database.