Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Communication error - db2diag.log

724 views
Skip to first unread message

michalp

unread,
Apr 21, 2010, 8:08:33 AM4/21/10
to
The following is my environment:
Solaris 10 SPARC
DB2 V9.7 FP1
JDK ( 1.4.2_23-b01)
SAP Netweaver 2004s (ABAP+JAVA Stack)

Anyone here know what is the error message in db2diag.log file below
mean?

2010-04-21-13.11.46.636334+120 I92733A429 LEVEL: Error
PID : 2395 TID : 9 PROC : db2sysc 0
INSTANCE: db2bwp NODE : 000
EDUID : 9 EDUNAME: db2tcpcm 0
FUNCTION: DB2 UDB, common communication, sqlcctcpconnmgr_child, probe:
155
MESSAGE : DIA3208E Error encountered in TCP/IP protocol support. TCP/
IP
function "close". Socket was "4". Errno was "9".


2010-04-21-13.11.46.703577+120 I94608A329 LEVEL: Error
PID : 2399 TID : 1 PROC : db2acd 0
INSTANCE: db2bwp NODE : 000
EDUID : 1 EDUNAME: db2acd 0
FUNCTION: DB2 UDB, common communication, sqlccipcdarihandshake, probe:
3
RETCODE : ZRC=0x83000024=-2097151964


2010-04-21-13.11.46.703604+120 I95558A337 LEVEL: Error
PID : 2751 TID : 1 PROC : db2fmp (C) 0
INSTANCE: db2bwp NODE : 000
EDUID : 1 EDUNAME: db2fmp (C) 0
FUNCTION: DB2 UDB, common communication, sqlccipcdarihandshake, probe:
3
RETCODE : ZRC=0x83000024=-2097151964

Thanks in advance,
MichalP

The Boss

unread,
Apr 21, 2010, 7:18:47 PM4/21/10
to

If you encounter this while stopping the instance with db2stop, you probably
can ignore it.
Your instance probably has more than 1 db2tcpcm process, and after db2stop
is issued, these processes simultaneously will try to close the same socket.
Only one of them will succeed, the other(s) will fail as the socket is
already closed and will write a DIA3208E message to db2diag.log

You may check the setting of variable DB2TCPCONNMGRS and set it to 1 (using
db2set), this should stop the DIA3208E messages.

HTH

--
Jeroen


0 new messages