Qlik Replicate using DB2 LUW Endpoint with SSL enabled in DB2

[Bill_Steinagle]

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.

1. 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 
      
2. 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?

Related Content 

Configuring Secure Sockets Layer (SSL) support in a DB2 instance

Environment

Qlik Replicate