Troubleshoot DB2 Z/OS connectivity from Edge

Hi Community,

Wondering if anyone else has encountered the below error when trying to connect to mainframe DB2 z/OS from Edge (installed on-prem on a standalone RHEL8 linux server):
com.ibm.db2.jcc.am.DisconnectNonTransientConnectionException: [jcc][t4][2043][11550][4.26.14] Exception java.io.FileNotFoundException: Error opening socket to server server_name/ip_address on port 1,234 with message: /etc/pki/ca-trust/extracted/java/cacerts (No such file or directory).

I can connect locally to that DB from DBeaver and the ID with which Edge is installed does have access to the cacerts file plus the complete path. With Edge's complex architecture I might be missing something - any suggestions?

Thank you!

Responses

Accepted Solution

laurenzhiller1

23 Messages

•

1.9K Points

6 months ago

Hi @riteshmody ,

I have not tested this with Db2 z/OS, but to my knowledge Edge does not read certificates located in /etc/pki/ca-trust/extracted/java/cacerts. You can instead try uploading the required certificate via the corresponding property of the Db2 driver. You must set the type of the property to "File Upload".

Good luck,

Laurenz

2

0

riteshmody

18 Messages

•

805 Points

Thanks @laurenzhiller1 - that worked!

Like

Reply

6 months ago

U

user_9df0c9

2 Messages

•

800 Points

@riteshmody we are trying to connect to DB2 AS400iseries server using the Username and Password Connection Template and the following creds:

Username: abc

Password: xyz

DriverClass: com.ibm.as400.access.AS400JDBCDriver

Driver Jar: jt400.jar

String: jdbc:as400://Server:SecurePort/database

Error msg:

Test jdbc connection failed (SQL state: 08001, error code: -99999): SQLNonTransientConnectionException: The application requester cannot establish the connection. (Connection was dropped unexpectedly.)
com.collibra.edge.sdk.exceptions.JdbcConnectionException: Error occurred while connecting to 'jdbc:as400://server:secureport/database' with driver 'com.ibm.as400.access.AS400JDBCDriver'.

NB: The connection is successful if we do not add the port, so we use the connection string: 'jdbc:as400://server/database'

It has been suggested that for secure port connection we have to use SSL certificates.

We know that Edge does not read certificates located in /etc/pki/ca-trust/extracted/java/cacerts

The question is, how does this work? Do we upload the certificate file in the properties, and what is the SSL file version?

Like

Reply

2 months ago

0

Community

riteshmody

Troubleshoot DB2 Z/OS connectivity from Edge

laurenzhiller1

riteshmody

user_9df0c9

Related Tags

Related Conversations

Was this helpful?