Qlik Replicate connecting to DB2 z/OS fails with a Communication Link failure function detecting the error:
"selectForRecvTimeout". Protocol specific error code(s): "115", "*", "*". SQLSTATE=08001 SQL30081N.
Environment
Resolution
This error is an indication that the connection attempt by Qlik Replicate is being rejected by the DB2 for z/OS database server (subsystem). When a Task starts-up, it can create up to six (6) remote (DDF) connections to the Source DB2 environment.
On z/OS run the below system command:
-DIS DDF DETAIL
and check the output below as these are the Max Connections and Active Connections
DSNL090I DT=A CONDBAT= 400 MDBAT= 200
DSNL092I ADBAT= 45 QUEDBAT= 203 INADBAT= 0 CONQUED= 0
CONDBAT and MDBAT: These refer to two parameters, CONDBAT and MAXDBAT, in the Db2 subsystem's ZPARM module (think of the ZPARMs as Db2 for z/OS configuration parameters):
- CONDBAT - sets the maximum number of concurrent inbound DDF connections that are to be allowed.
- MAXDBAT - specifies the maximum number of database access threads (DBATs) that are allowed to be concurrently active
Cause
CONDBAT and MAXDBAT DB2 subsystem parameters were set too low for the concurrent Qlik Replicate Tasks running against this Db2 environment.
Related Content
https://www.ibm.com/docs/en/db2-for-zos/11?topic=commands-display-ddf-db2
