Prev: Filesystem configuration on HP UX for DB2
Next: SQL4020N Resolution for IBM DB2 Version 9.1
From: michalp on 21 Apr 2010 08:08
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
From: The Boss on 21 Apr 2010 19:18
michalp wrote:
> 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

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


 | 
Pages: 1
Prev: Filesystem configuration on HP UX for DB2
Next: SQL4020N Resolution for IBM DB2 Version 9.1