Skip to main content
Product Release Webinar: Qlik Insider airing December 6! REGISTER TODAY!

Qlik Replicate: DB2 zOS connection error

No ratings
Showing results for 
Search instead for 
Did you mean: 

Qlik Replicate: DB2 zOS connection error

Last Update:

Jun 29, 2023 3:39:04 AM

Updated By:


A DB2 zOS connection fails with:

SYS-E-HTTPFAIL, Cannot connect to DB2 zOS Server.

SYS,GENERAL_EXCEPTION,Cannot connect to DB2 zOS Server,RetCode: SQL_ERROR SqlState: 08001 NativeError: -99999 Message: [IBM][CLI Driver] CLI0199E Invalid connection string attribute. SQLSTATE=08001



  1. Update db2dsdriver.cfg is located in the <DB2 installation directory>/cfg directory

    Update the database connection correctly and save them.

    odbcinst.ini is located in the /etc directory on Linux or the %SystemRoot%\system32 directory on Windows.

    Locate the corresponding DB2 ODBC driver and validate the driver's library path.

    Note: When opening the files to make changes, make sure you have opened them with administrative privileges. 

  2.  Restart the Qlik Replicate services

  3.  You can reach out to your system administrator to change the SECPORT which is located in the configuration files in the mainframe environment. Please update the correct SECPORT.



Labels (1)
Version history
Last update:
‎2023-06-29 06:39 AM
Updated by: