TCP/IP DIA3208E Error
skyr
I'm am running db2 v7.1 (fixpack1) on a AIX system.
Websphere 3.5 is also in production on this machine and there are remote
connections from a Apache webserver.
My db2diag.log is constantly getting this error message:
2000-11-27-10.09.50.057576 Instance:db2inst1 Node:000
PID:20446(db2tcpcm) Appid:none
common_communication sqlcctcpconnmgr_child Probe:105
DIA3208E Error encountered in TCP/IP protocol support. TCP/IP function
"accept". Socket was "48". Errno was "76".
This error number on AIX means 'Socket not connected'
Can anyoun help me on this one??
TIA
Hordur Hardarson
sk...@isl.is
Gert van der Kooij
Maybe they want to use the same port?
Port 50000/50001 are used by default.
fabrizio napolitano
this is a note from comp.database.ibm-db2 I thought useful for you.
Fabrizio Napolitano
Hi,
this is from the TorontaLab:
Here is what I received from development on this error message:
The errors being logged are actually not causing any kind of DB2
problem, they are just annoying and waste a lot of diag.log space.
So, what do we do?
Have the customer: db2set DB2TCPCONNMGRS=1
This will set the number of connection managers to 1, which means all
connection requests will be funnelled through that one process.
NOTE: THIS WILL MEAN A DROP IN PERFORMANCE ON REMOTE CONNECTIONS IN
SYSTEMS WITH A LOT OF USERS AND/OR FREQUENT CONNECTS/DISCONNECTS.
Why does this error only show up in EEE and EE SMP boxes ?
Because, the default setting for this is based off of the square root
of the number of processors, rounded up. So, if you have 2-4
processors it will be rounded up to 2 by default.
.
Our TCP/IP developers are currently looking into this error to see how
it can be fixed.
got an information in PMR 29484,B036,C724 from another customer:
We have opened a apar related to defect#149857 , APAR IY15212.
The APAR description is:
APAR Identifier ...... IY15212 Last Changed ........ 00/12/13
DIA3208E MESSAGES ON MULTI-CPU AIX SERVERS RUNNING DB2 UDB V7.1
ERROR DESCRIPTION:
DB2 UDB v7.1 running on AIX with multiple CPUs spawns multiple
TCPIP Listeners. These extra listeners generate multiple
messages in the db2diag.log:
<DIA3208E> Error encountered in TCP/IP protocol support.
TCP/"accept". Socket was "48". Errno was "76".
-
There are no errors on the client, and no service impact beyond
the db2diag.log increasing in size.
LOCAL FIX:
db2set DB2TCPCONNMGRS=1
And last:
This APAR has been deferred to v8.
best regards
Joachim Mueller
<stro...@my-deja.com> schrieb im Newsbeitrag
news:956ir3$1tr$1...@nnrp1.deja.com...
> On my aix 4.3.3 I've installed db2 7.1.0.27 but into the file
> db2diag.log i have this error. What's happen?
> thanks
>
> 2001-01-25-12.57.33.695667 Instance:db2inst1 Node:000
> PID:17038(db2tcpcm) Appid:none
> common_communication sqlcctcpconnmgr_child Probe:105
> DIA3208E Error encountered in TCP/IP protocol support. TCP/IP function
> "accept". Socket was "48". Errno was "76".
>
>
> Sent via Deja.com
> http://www.deja.com/
skyr <sk...@isl.is> wrote in message 8vtdjo$p6q$1...@news.software.ibm.com...