IBM Support

How To Recover from an SQL30081N Error Message

Troubleshooting


Problem

11041 - A database error occurred while attempting to open table EDIENU32.EDIVTSIS, ODBC return code is: -1. Description: SQL30081N A communication error has been detected. Communication protocol being used: "TCP/IP". Communication API being used: "SOCKETS". Location where the error was detected: "". Communication function detecting the error: "recv". Protocol specific e . Internal Codes: State:40003,Native:-30001,Origin:[IBM][CLI Driver][DB2]

Cause

Client generated an interrupt

Resolving The Problem

The SQL30081N message was resolved by deselecting one of the DB2 connect default settings. When using Configuration Assistant on DB2 to configure the Database Connection to your host database:

For DB2 Connect 7.2 users:
Uncheck the 'Disconnect if client generates an interrupt (INTERRUPT
ENABLED)' box within the Host or AS/400 options tab.

For DB2 Connect 8.1 or later users:
Uncheck the 'Disconnect if client generates an interrupt (INTERRUPT
ENABLED)' box within the DCS Options tab. To modify this option you may need to check the box for Configure DCS options.

For DB2 Connect 9.1 users:

Add the following parameter to db2cli.ini under the [common] section:

QueryTimeoutInterval=0

This will disable DB2 from checking if a Query has timed out.

For more information on this setting please refer to the following in the Information Center:

QueryTimeoutInterval

[{"Product":{"code":"SSFKTZ","label":"WebSphere Data Interchange"},"Business Unit":{"code":"BU012","label":"WCE"},"Component":"WDI 3.2 for z\/OS","Platform":[{"code":"PF033","label":"Windows"},{"code":"PF035","label":"z\/OS"}],"Version":"3.2;3.2.1;3.3","Edition":""}]

Document Information

Modified date:
16 June 2018

UID

swg21220244