473,230 Members | 1,880 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,230 software developers and data experts.

ERROR [40003] [IBM][CLI Driver] SQL30081N A communication error has been detected. Communic

I support a .Net application running on a SERVER accessing MF Db2
data. Occasionally, we have some type of connection problem that we
have been unable to debug up to this point. We typically receive one
of these IBM.Data.DB2.DB2Exception messages:

ERROR [40003] [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: ‘138.83.176.1'. Communication function detecting the error:
‘recv'. Protocol specific error code(s): ‘10053', ‘*', ‘*'.
SQLSTATE=08001

This corresponds to some messages in the DB2 started task running on
the MF:

10.30.57 STC11095 DSNL511I -DB2C DSNLIENO TCP/IP CONVERSATION FAILED
866
866 TO LOCATION 112.64.103.172
866 IPADDR=112.64.103.172 PORT=2655
866 SOCKET=RECV RETURN CODE=1121 REASON
CODE=76650446
10.31.08 STC11095 DSNL511I -DB2C DSNLIENO TCP/IP CONVERSATION FAILED
032
032 TO LOCATION 112.64.103.172
032 IPADDR=112.64.103.172 PORT=3180
32 SOCKET=RECV RETURN CODE=1121 REASON CODE=76650446
Along with the Communication error exception, we typically also
receive some other exceptions during this time, mainly....

Inner Exception Type: IBM.Data.DB2.DB2Exception ;Inner Exception
Message: ERROR [08003] [IBM][CLI Driver] CLI0106E Connection is
closed. SQLSTATE=08003

So the communication problem (whatever it is) seems to manifest in the
first exception - Communication problem - and this must hose up some
of our connections so at that point, we begin to receive the
Connection is Closed message.

Our C# instansiates a DB2Connectin object and issues an open against
it. Then an executeNonQuery statement to run the SP. It is pretty
standard code and works nearly all the time. We think our problem is
load related - b/c we only encounter under productin load and more so
on our busiest servers.

Any help greatly appreciated.

Tim Reynolds
Verizon Data Services
Nov 12 '05 #1
3 43056
Hi -

some time ago I got similar communication errors in an earlier FP version
(FP9??) of UDB for Windows v7. After I installed the FP11, the problem was
resolved.

For my particular problem, it was actually the case that some UDB problems
caused out-of-memory situation, and hence caused the communication failed.
In other words, the communication errors did not show the root cause, and
actually it also spent me quite some time to identify the root cause
problem. So you may want to check if there are other errors besides the
communication errors.

aw
"Tim Reynolds" <ti**********@verizon.com> wrote in message
news:a5**************************@posting.google.c om...
I support a .Net application running on a SERVER accessing MF Db2
data. Occasionally, we have some type of connection problem that we
have been unable to debug up to this point. We typically receive one
of these IBM.Data.DB2.DB2Exception messages:

ERROR [40003] [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: '138.83.176.1'. Communication function detecting the error:
'recv'. Protocol specific error code(s): '10053', '*', '*'.
SQLSTATE=08001

This corresponds to some messages in the DB2 started task running on
the MF:

10.30.57 STC11095 DSNL511I -DB2C DSNLIENO TCP/IP CONVERSATION FAILED
866
866 TO LOCATION 112.64.103.172
866 IPADDR=112.64.103.172 PORT=2655
866 SOCKET=RECV RETURN CODE=1121 REASON
CODE=76650446
10.31.08 STC11095 DSNL511I -DB2C DSNLIENO TCP/IP CONVERSATION FAILED
032
032 TO LOCATION 112.64.103.172
032 IPADDR=112.64.103.172 PORT=3180
32 SOCKET=RECV RETURN CODE=1121 REASON CODE=76650446
Along with the Communication error exception, we typically also
receive some other exceptions during this time, mainly....

Inner Exception Type: IBM.Data.DB2.DB2Exception ;Inner Exception
Message: ERROR [08003] [IBM][CLI Driver] CLI0106E Connection is
closed. SQLSTATE=08003

So the communication problem (whatever it is) seems to manifest in the
first exception - Communication problem - and this must hose up some
of our connections so at that point, we begin to receive the
Connection is Closed message.

Our C# instansiates a DB2Connectin object and issues an open against
it. Then an executeNonQuery statement to run the SP. It is pretty
standard code and works nearly all the time. We think our problem is
load related - b/c we only encounter under productin load and more so
on our busiest servers.

Any help greatly appreciated.

Tim Reynolds
Verizon Data Services

Nov 12 '05 #2
I don't know if you ever resolved this, but we just had similar problem.
What version of DB2 are you on? We just upgraded to Db2 V7, with DB2
connect 8.1 and DB2 client 8.1.2. We also were in the middle of upgrading
DB2 Clint to Service pack 12. Well anyway, all went back to upgrade to
DB2 V7 on mainframe. We needed to increate IDACK from 30 to 50, MAXDBAT
from 64 to 200 and CONDAT from 64 to 200 and CTHREADS from 130 to 200.
This seemed to fix the issue.

Jul 13 '06 #3
michelles wrote:
I don't know if you ever resolved this, but we just had similar problem.
What version of DB2 are you on? We just upgraded to Db2 V7, with DB2
connect 8.1 and DB2 client 8.1.2. We also were in the middle of upgrading
DB2 Clint to Service pack 12. Well anyway, all went back to upgrade to
DB2 V7 on mainframe. We needed to increate IDACK from 30 to 50, MAXDBAT
from 64 to 200 and CONDAT from 64 to 200 and CTHREADS from 130 to 200.
This seemed to fix the issue.
We have been getting about 50 -30081's per day every since we switched
from SNA to TCP/IP four years ago. I have worked two different ETR's
with IBM with no success. If you figure yours out, I would like to
hear about it. (We have reviewed every mainframe/gateway/client
setting known to humanity. No changes have fixed this problem for more
than a month!) I am going to have -30081 etched on my grave...

(We run DB2 Client on Windows V8 fp 11, DB2 Connect Enterprise Edition
on Windows V8 fp 11, and DB2 for z/OS V7.)

Craig Wahlmeier

Jul 13 '06 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: alederer | last post by:
Hallo! I have the following situation: A db2 v6.1 client on AIX 4.3 (db2level reports U469703) and a OS/390 database version 6.1 . In some situations, I get the following error in my db2...
2
by: PA | last post by:
Hi All, Thanks for your attention..I appreciate that. -----Problem description -----------Start---------------------- Database : DB2 UDB 8.2 on Windows 2003 Client: VB6/ADO 2.7 on Windows...
1
by: Praveen | last post by:
Hi, I have installed WebSphere Portal on AIX and connected to DB2 on a remote machine, Getting the followin errors when trying to get the values from database thru applications installed on...
0
by: MenakaMeena | last post by:
When i try to execute my application based on swing that runs in eclipse platform, the frame is not opening when i login and i get the error (backend is DB2) Error code: 129 Cannot connect to...
0
by: jeethsu | last post by:
Hi, I have Java application running on Websphere Application Server 6.0 This application connects to Mainframe DB2 using CLI type 2 driver. The application uses websphere connection pool...
4
by: Pool | last post by:
I tried to connect DB2 (Sitting in Unix server at my client location) using Db2 connect V8. I am getting the following error message. I tried all the possible options BUt the error is same.. See each...
2
by: anujs | last post by:
Hi members, Please let me know how to solve the problem while initializing the DB2. the message is - IBM] SQL1032N No start database manager command was issued. SQLSTATE=57019.
5
by: bonymuscles | last post by:
Hi All, I am working for the first time on DB2. I have installed ver 7.2, and am using AIX version 5.2, and 5.3 for some DBs. I am getting this error "SQL30081N" for some of the databases. I...
2
by: globomike | last post by:
Hi, can anybody tell me what the reason code 18 means in combination with a SQL0902 error? It would be helpful to know details about the reason code but I could not find any details about that...
0
by: VivesProcSPL | last post by:
Obviously, one of the original purposes of SQL is to make data query processing easy. The language uses many English-like terms and syntax in an effort to make it easy to learn, particularly for...
3
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 3 Jan 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). For other local times, please check World Time Buddy In...
0
by: jianzs | last post by:
Introduction Cloud-native applications are conventionally identified as those designed and nurtured on cloud infrastructure. Such applications, rooted in cloud technologies, skillfully benefit from...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.