Skip to main content

Official Support Articles

Search or browse our knowledge base to find answers to your questions ranging from account questions to troubleshooting error messages. The content is curated and updated by our global Support team

Announcements
Have an amazing Qlik Success Story? Share it at QlikWorld! Submit Proposal

Qlik Replicate connection error to R4Z SqlState: 08001 NativeError: -30081 Message SQL30081N

cancel
Showing results for 
Search instead for 
Did you mean: 
Bill_Steinagle
Support
Support

Qlik Replicate connection error to R4Z SqlState: 08001 NativeError: -30081 Message SQL30081N

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

Labels (1)
Version history
Last update:
‎2022-10-05 08:30 PM
Updated by: