IBM Support

DB2 client applications fail with SQL30081 rc=32 or rc=73 when communicating with a DB2 server on AIX, and IBM AIX TCP Traffic Regulation has been enabled

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

IBM AIX TCP Traffic Regulation

[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Connectivity - DRDA","Platform":[{"code":"PF002","label":"AIX"}],"Version":"10.1;10.5;9.5;9.7;9.8","Edition":"Advanced Enterprise Server;Advanced Workgroup Server;Enterprise Server;Express;Express-C;Personal;Workgroup Server","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 June 2018

UID

swg21673820

Page Feedback