Solved

JDBC Multitable Consumer for DB2 Database

  • 11 November 2021
  • 4 replies
  • 294 views

Hi Team,

 

In our team we are planning to use JDBC Multitable Consumer for DB2 database to implement CDC ,does JDBC Multitable Consumer works for DB2 or is there any other origin that supports DB2 connectivity.

 

Thanks,

Rani!

icon

Best answer by Dimas Cabré i Chacón 11 November 2021, 12:14

View original

4 replies

Userlevel 2
Badge

JDBC Multitable origin supports DB2, as it relies on standard JDBC.

JDBC Multitable origin supports DB2, as it relies on standard JDBC.

@Dimas Cabré i Chacón  - What are the required libraries that need to be installed on data collectors so that we can read data from DB2 tables. Appreciate any guidance. Thanks.

Userlevel 2
Badge

You would only need to add proprietary IBM DB2 JDBC drivers (https://www.ibm.com/support/pages/db2-jdbc-driver-versions-and-downloads). Please choose db2jcc4.jar as Data Collector runs on Java 8. JDBC drivers are usually back-compatible. Thus, you can either pick driver for your specific IBM DB2 version, or the latest version. In some situations you might need additional IBM jar files, but normally this is not necessary. If you encounter any issue related to missing classes, you should check IBM’s official documentation for additional potentially missing JARs.

You would only need to add proprietary IBM DB2 JDBC drivers (https://www.ibm.com/support/pages/db2-jdbc-driver-versions-and-downloads). Please choose db2jcc4.jar as Data Collector runs on Java 8. JDBC drivers are usually back-compatible. Thus, you can either pick driver for your specific IBM DB2 version, or the latest version. In some situations you might need additional IBM jar files, but normally this is not necessary. If you encounter any issue related to missing classes, you should check IBM’s official documentation for additional potentially missing JARs.

 

Thanks Dimas for your prompt response. Will check it out.

Reply