Qlik zOS Endpoint connection

PriQlikDBA — Wed, 26 Aug 2026 20:57:07 GMT

Getting below error when trying to connect to DB2 zOS directly within the endpoint connection using Use connection properties

SYS-E-HTTPFAIL, Cannot connect to DB2 zOS Server.
SYS,GENERAL_EXCEPTION,Cannot connect to DB2 zOS Server,RetCode: SQL_ERROR SqlState: HY000 NativeError: -1042 Message: [IBM][CLI Driver] SQL1042C An unexpected system error occurred. SQLSTATE=58004

Use Connection properties

Server (system) lpar7

Port 5031

Location L7DB2I

Provider IBM DB2 ODBC DRIVER

Re: Qlik zOS Endpoint connection

DesmondWOO — Fri, 28 Aug 2026 10:00:44 GMT

Hi @PriQlikDBA ,

SQL1042C (SQLSTATE 58004) points to an initialization failure in the local IBM DB2 CLI/ODBC driver before the database connection can be established. I'd like to check:

1. What is the Qlik Replicate version?

2. Is it a new connection setup or an existing one?

3. What is the ODBC driver version?

4. Can you test the connection using db2cli?

Regards,
Desmond

topic Qlik zOS Endpoint connection in Qlik Replicate

Qlik zOS Endpoint connection

Re: Qlik zOS Endpoint connection