Qlik Replicate using DB2 LUW Endpoint with SSL enabled in DB2

Bill_Steinagle — Mon, 16 Sep 2024 09:57:18 GMT

Qlik Replicate fails at testing a connection to a DB2 LUW Endpoint with SSL Enabled on DB2.

The error logged:

SYS-E-HTTPFAIL, Cannot connect to DB2 LUW Server.
SYS,GENERAL_EXCEPTION,Cannot connect to DB2 LUW Server,RetCode: SQL_ERROR SqlState: 08001 NativeError: -30081 Message: [IBM][CLI Driver] SQL30081N A communication error has been detected. Communication protocol being used: "SSL". Communication API being used: "SOCKETS". Location where the error was detected: "SOCKETS". Communication function detecting the error: "sqlccSSLSocketSetup". Protocol specific error code(s): "414", "*", "*". SQLSTATE=08001

To resolve the communication error has been detected error, verify the certificate is correctly installed and the Qlik Replicate Endpoint has been configured correctly.

Verify the certificate from DB2 LUW is installed on the Windows Server. To do so, open the Windows Certificate Store and verify if you can locate the certificate in the Trusted Root certificate store. If the certificates are not installed, rerun the installation.
1. Log in with the account running the services
2. Open the Windows certmgr app
3. Open the Current User certiciate store
4. Switch to Trusted Root Certificate Authorities and Certificates
Verify that the Qlik Replicate Endpoint has been configured correctly.
1. Open the DB2 LUW Endpoint in Qlik Replicate
2. Switch to the Advanced tab and open Internal parameters
3. Search for and set the following two Internal Parameters to enable SSL for this Endpoint:
  
  Parameter: additionalConnectionProperties
  Value: SSLClientKeystoredb=GSK_MS_CERTIFICATE_STORE
  
  Parameter: UseSSL
  Checked
  
  For more information about Internal Parameters, see Qlik Replicate: How to set Internal Parameters and what are they for?

article Qlik Replicate using DB2 LUW Endpoint with SSL enabled in DB2 in Official Support Articles

Qlik Replicate using DB2 LUW Endpoint with SSL enabled in DB2

Related Content

Environment