Troubleshooting
Problem
When IBM AIX TCP Traffic Regulation has been enabled, DB2 client applications may receive errors on connections and other server requests, such as SQL30081 rc=32 or rc=73.
Symptom
DB2 client applications fail with communication errors such as:
[IBM][CLI Driver] SQL30081N A communication error has been detected.
Communication protocol being used: "TCP/IP". Communication API being
used: "SOCKETS". Location where the error was detected: "192.168.1.110".
Communication function detecting the error: "send". Protocol specific
error code(s): "32", "*", "0". SQLSTATE=08001
or
[IBM][CLI Driver] SQL30081N A communication error has been detected.
Communication protocol being used: "TCP/IP". Communication API being
used: "SOCKETS". Location where the error was detected: "192.168.1.110".
Communication function detecting the error: "recv". Protocol specific
error code(s): "73", "*", "0". SQLSTATE=08001
Cause
The AIX systems administrator may have enabled IBM AIX TCP Traffic Regulation, which provides kernel-level TCP Denial-of-Service (DoS) attack mitigation. This feature may have also been enabled by running the AIXpert tool and selecting a high security mode.
The parameter is tcptr_enable =1.
Environment
AIX 6.1 and higher.
Diagnosing The Problem
The parameter enabling IBM AIX TCP Traffic Regulation is tcptr_enable, which by default is set to off (0). The setting can be checked with the no -a command:
# no -o tcptr_enable
tcptr_enable = 1
The policies in effect can be viewed by issuing the tcptr -show command:
# tcptr -show
TCP Traffic Regulation Policies:
StartPort=39044 EndPort=39044 MaxPool=16 Div=1 Used=7
Note that the TCP/IP port that DB2 is listening on is defined by the SVCENAME database manager configuration parameter. Any policy covering that port may be imposing limits on remote DB2 connections.
Resolving The Problem
If TCP traffic regulation is enabled, consult with the systems administrator to determine more appropriate settings.
Related Information
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21673820