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
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21220244