Qlik zOS Endpoint connection

[PriQlikDBA]

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

[DesmondWOO]

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