5 Messages
How to connect Collibra catalog to DB2 Z/OS Database
We have connection issue when we connect to the Db2 Z/OS database.
Error is: “image attached as well”
Server connection failed
Error during JDBC database connection: java.lang.AbstractMethodError: Receiver class com.ibm.db2.jcc.t4.f does not define or inherit an implementation of the resolved method ‘abstract java.sql.ResultSet getSchemas(java.lang.String, java.lang.String)’ of interface java.sql.DatabaseMetaData.
Notes:
- We use Linux jobserver
- I tried adding the license file in the Jobserver directory /collibra/spark/jars
- I also tried setting parameter useJDBC4ColumnNameAndLabelSemantics to “2”
- I can connect to the database outside of collibra with same credentials using JDBC version 3.69.24
Thanks
laurenzhiller
36 Messages
2 years ago
Hi @islam.wael,
we managed to connect succesfully to Db2 for z/OS. Maybe this article will help you: https://support.collibra.com/hc/en-us/articles/4403919857169-DB2-for-z-OS-connectivity
Best regards,
Laurenz
0
0
islamwael
5 Messages
2 years ago
@laurenz.hiller Thanks for replying Laurenz
Can you sent me or mention the JDBC driver version you are using? because it doesn’t seem that all versions are supported by Collibra
0
0
laurenzhiller
36 Messages
2 years ago
Hi @islam.wael,
we are using JDBC Driver Version 4.26.14 (and the according license file for z/OS) and Db2 for z/OS in V12 .
Best regards,
Laurenz
0
0
islamwael
5 Messages
2 years ago
Thanks @laurenz.hiller , I’m able to connect now… seems like the JDBC version was the main issue
I’m adding the extra steps I did, could be helpful for other users:
Regards,
Islam
0