Jun 29, 2023 3:39:04 AM
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
Update db2dsdriver.cfg is located in the <DB2 installation directory>/cfg directoryUpdate 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.
Restart the Qlik Replicate services
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.