473,216 Members | 1,675 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,216 software developers and data experts.

Communication error SQL30081N ?

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 CLI application:

[IBM][CLI Driver][DB2] 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
error code(s): "*", "*", "0". SQLSTATE=08001

The hostlog reports:

DSNL027I # SERVER DISTRIBUTED AGENT WITH 447
LUWID=GA8C2002.DC63.D10E28211500=47952
THREAD-INFO=xxx
RECEIVED ABEND=0C4
FOR REASON=00000000
DSNL028I # GA8C2002.DC63.D10E28211500=47952 448
ACCESSING DATA FOR
LOCATION xxx
IPADDR xxx
And a DRDA trace on the client (db2drdat):

1802 DB2 fnc_data gateway_drda_ar sqljcsend (1.35.10.80)
pid 29626; tid 6429; node 0; cpid 188; sec 1075460255; nsec 79806729;
tpoint 177

SEND BUFFER: EXCSQLIMM RQSDSS (ASCII) (EBCDIC)
0 1 2 3 4 5 6 7 8 9 A B C D E F 0123456789ABCDEF 0123456789ABCDEF
0000 004ED05100010048 200A00442113C4E2 .N.Q...H ..D!...
..+}...........DS
0010 D5E3404040404040 4040404040404040 ..@@@@@@@@@@@@@@ NT

0020 D5E4D3D3C9C44040 4040404040404040 ......@@@@@@@@@@ NULLID

0030 4040E2D8D3D3C6F0 F0F0404040404040 @@........@@@@@@
SQLLF000
0040 4040404068414463 516144500041180A @@@@hADcQaDP.A..
....../.&....
0050 D003000118042414 000017FC43524541 ......$.....CREA
}...............
.....
<snip>
.....
1840 2929207C7C202727 2727207C7C202729 )) || '''' || ')
....@@......@@...
1850 2729293B20454E44 ')); END ......+.

1815 DB2 fnc_data gateway_drda_ar sqljcrecv (1.35.10.81)
pid 29626; tid 6429; node 0; cpid 188; sec 1075460255; nsec 228765463;
tpoint 181

COMMUNICATIONS ERROR RECEIVING

RECEIVE FUNCTION RC = 54
SEVERITY = 8
PROTOCOL USED = TCP/IP
API USED = SOCKETS
FUNCTION = recv
ERRNO = *
Can someone tell me why the communication is lost, or how to get more
information about the reason of the communication lost.

By the way: my assumtion was that create trigger statements are
transactional requests in db2, but after the above communication error,
the trigger was generated on the os/390 site. Is there a parameter on
the client site to avoid auto commit on connection lost?

Thanks
Andreas Lederer
Nov 12 '05 #1
1 8537
Open a PMR. Abend 0C4 looks like you've found a bug.

"alederer" <al******@gmx.at> wrote in message
news:40******@e-post.inode.at...
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 CLI application:

[IBM][CLI Driver][DB2] 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
error code(s): "*", "*", "0". SQLSTATE=08001

The hostlog reports:

DSNL027I # SERVER DISTRIBUTED AGENT WITH 447
LUWID=GA8C2002.DC63.D10E28211500=47952
THREAD-INFO=xxx
RECEIVED ABEND=0C4
FOR REASON=00000000
DSNL028I # GA8C2002.DC63.D10E28211500=47952 448
ACCESSING DATA FOR
LOCATION xxx
IPADDR xxx
And a DRDA trace on the client (db2drdat):

1802 DB2 fnc_data gateway_drda_ar sqljcsend (1.35.10.80)
pid 29626; tid 6429; node 0; cpid 188; sec 1075460255; nsec 79806729;
tpoint 177

SEND BUFFER: EXCSQLIMM RQSDSS (ASCII) (EBCDIC)
0 1 2 3 4 5 6 7 8 9 A B C D E F 0123456789ABCDEF 0123456789ABCDEF
0000 004ED05100010048 200A00442113C4E2 .N.Q...H ..D!...
.+}...........DS
0010 D5E3404040404040 4040404040404040 ..@@@@@@@@@@@@@@ NT

0020 D5E4D3D3C9C44040 4040404040404040 ......@@@@@@@@@@ NULLID

0030 4040E2D8D3D3C6F0 F0F0404040404040 @@........@@@@@@
SQLLF000
0040 4040404068414463 516144500041180A @@@@hADcQaDP.A..
...../.&....
0050 D003000118042414 000017FC43524541 ......$.....CREA
}...............
....
<snip>
....
1840 2929207C7C202727 2727207C7C202729 )) || '''' || ')
...@@......@@...
1850 2729293B20454E44 ')); END ......+.

1815 DB2 fnc_data gateway_drda_ar sqljcrecv (1.35.10.81)
pid 29626; tid 6429; node 0; cpid 188; sec 1075460255; nsec 228765463;
tpoint 181

COMMUNICATIONS ERROR RECEIVING

RECEIVE FUNCTION RC = 54
SEVERITY = 8
PROTOCOL USED = TCP/IP
API USED = SOCKETS
FUNCTION = recv
ERRNO = *
Can someone tell me why the communication is lost, or how to get more
information about the reason of the communication lost.

By the way: my assumtion was that create trigger statements are
transactional requests in db2, but after the above communication error,
the trigger was generated on the os/390 site. Is there a parameter on
the client site to avoid auto commit on connection lost?

Thanks
Andreas Lederer

Nov 12 '05 #2

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

Similar topics

1
by: xixi | last post by:
i have catalog a remote database on my local db2 server, but now the remote database server with same machine name but the ip address changed, so i remove the old one, and try to catalog again...
3
by: Tim Reynolds | last post by:
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...
3
by: Laura | last post by:
I've just installed the DB2 Run-time client in a Solaris machine. Then I finnish the installation configuring the connection: 1. machine catalog was OK: ========================== $ db2 catalog...
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...
4
by: Ralf Gross | last post by:
Hi, I installed DB2 V8.1 with fixpak 10, created a new database and can connect to the database. $ db2 connect to mkstest Database Connection Information Database server =...
7
by: Ina Schmitz | last post by:
Hi NG, I wanted to reset the database (manager) configuration with RESET DATABASE CONFIGURATION and RESET DATABASE MANAGER CONFIGURATION After doing this, I rebooted server and client and...
1
by: sraghav | last post by:
Hi, I have a remote server.. From client machine did catalog tcip and catalog database on the remote databse. I am unable to do a test connection from client. Getting the following error,...
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: dimeuleh | last post by:
I am new to DB2 but I am currently doing a small project which involves two normal windows xp workstations both using DB2 Express C. I keep getting the SQL30081N error. I have researched why...
1
isladogs
by: isladogs | last post by:
The next online meeting of the Access Europe User Group will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, Mike...
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: 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...
2
by: jimatqsi | last post by:
The boss wants the word "CONFIDENTIAL" overlaying certain reports. He wants it large, slanted across the page, on every page, very light gray, outlined letters, not block letters. I thought Word Art...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
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...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...
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"....

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.