TCP/IP Error in db2diag.log on DB2 UDB for AIX V7.1 Fixpack 2a

Peter Horner

TCP/IP Error in db2diag.log on DB2 UDB for AIX V7.1 Fixpack 2a
Hi List

I get the following error in the db2diag.log.

2001-12-17-10.16.57.703355 Instance:ondemand
Node:000PID:66376(db2tcpcm) Appid:nonecommon_communication
sqlcctcpconnmgr_child Probe:105 DIA3208E Error encountered in TCP/IP
protocol support. TCP/IP function "accept". Socket was "48". Errno was
"76".

We are running DB2 UDB for AIX V7.1.
We recently migrated from V5.2 to V7.1 and applied Fixpack 2a.
This TCP/IP Problem never occured on V5.2.

I also get this TCP/IP errors in db2diag.log on the AIX box when I connect
with my (Windows NT) Control Center to this database !

Is anybody able to give me a hint what kind of problem this is ?

Thank you !
Peter

-----------------------------------------------------------------------------------

Peter Horner, ISDD
Bank Julius Baer & Co. Ltd.
Hohlstrasse 602, CH-8010 Zurich, Switzerland
Telephone +41 (1) 437 44 04, Fax +41 (1) 437 44 75
www.juliusbaer.com
-----------------------------------------------------------------------------------
























































*****Disclaimer*****
This message is for the addressee only and may contain confidential or
privileged information. You must delete and not use it if you are not the
intended recipient. It may not be secure or error-free. All e-mail
communications to and from the Julius Baer Group may be monitored.
Processing of incoming e-mails cannot be guaranteed. Any views expressed in
this message are those of the individual sender. This message is for
information purposes only. All liability of the Julius Baer Group and its
entities for any damages resulting from e-mail use is excluded. US persons
are kindly requested to read the important legal information presented
after clicking here: http://www.juliusbaer.com/maildisclaimer



Fabrizio Napolitano

Re: TCP/IP Error in db2diag.log on DB2 UDB for AIX V7.1 Fixpack 2 a
(in response to Peter Horner)
Hi there,

It's an error due to a AIX bug handling TCP communication, there is already
a APAR for it ( NB is a AIX APAR not a DB2) but I don't remember which one
is. Try to look in the IBM website.

Fabrizio

-----Original Message-----
From: Peter Horner
To: [login to unmask email]
Sent: 17/12/01 13.10
Subject: TCP/IP Error in db2diag.log on DB2 UDB for AIX V7.1 Fixpack 2a

Hi List

I get the following error in the db2diag.log.

2001-12-17-10.16.57.703355 Instance:ondemand
Node:000PID:66376(db2tcpcm) Appid:nonecommon_communication
sqlcctcpconnmgr_child Probe:105 DIA3208E Error encountered in TCP/IP
protocol support. TCP/IP function "accept". Socket was "48". Errno was
"76".

We are running DB2 UDB for AIX V7.1.
We recently migrated from V5.2 to V7.1 and applied Fixpack 2a.
This TCP/IP Problem never occured on V5.2.

I also get this TCP/IP errors in db2diag.log on the AIX box when I
connect
with my (Windows NT) Control Center to this database !

Is anybody able to give me a hint what kind of problem this is ?

Thank you !
Peter

------------------------------------------------------------------------
-----------

Peter Horner, ISDD
Bank Julius Baer & Co. Ltd.
Hohlstrasse 602, CH-8010 Zurich, Switzerland
Telephone +41 (1) 437 44 04, Fax +41 (1) 437 44 75
www.juliusbaer.com
------------------------------------------------------------------------
-----------
























































*****Disclaimer*****
This message is for the addressee only and may contain confidential or
privileged information. You must delete and not use it if you are not
the
intended recipient. It may not be secure or error-free. All e-mail
communications to and from the Julius Baer Group may be monitored.
Processing of incoming e-mails cannot be guaranteed. Any views expressed
in
this message are those of the individual sender. This message is for
information purposes only. All liability of the Julius Baer Group and
its
entities for any damages resulting from e-mail use is excluded. US
persons
are kindly requested to read the important legal information presented
after clicking here: http://www.juliusbaer.com/maildisclaimer



the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list
can



Pierre Evans

Re: TCP/IP Error in db2diag.log on DB2 UDB for AIX V7.1 Fixpack 2a
(in response to Fabrizio Napolitano)
Peter,
I had that problem with UDB v7.2 immediately after upgrading from v6.1-
It's a known bug,with a simple solution.
It has something to do with UDB expecting to communicate with AIX on
several tcpip ports, but aix doesnt support it.
To fix it, set the DB2TCPCONNMGRS variable to 1,stop & start the database
and the problem goes away.
For a more detailed description, you'll probably have to open a PMR.
---------------------------------------------------------------------------------------------------------

Pierre Evans
Database Administrator, Data Warehouse Operations
Autozone
123 South Front St, (901) 495-7851
Memphis TN 38103 Fax (901) 495-8300
[login to unmask email]




Peter Horner
<[login to unmask email] To: [login to unmask email]
SBAER.COM> cc:
Sent by: DB2 Data Subject: TCP/IP Error in db2diag.log on DB2
Base Discussion UDB for AIX V7.1 Fixpack 2a
List
<[login to unmask email]>


12/17/01 06:10 AM
Please respond to
DB2 Data Base
Discussion List






Hi List

I get the following error in the db2diag.log.

2001-12-17-10.16.57.703355 Instance:ondemand
Node:000PID:66376(db2tcpcm) Appid:nonecommon_communication
sqlcctcpconnmgr_child Probe:105 DIA3208E Error encountered in TCP/IP
protocol support. TCP/IP function "accept". Socket was "48". Errno was
"76".

We are running DB2 UDB for AIX V7.1.
We recently migrated from V5.2 to V7.1 and applied Fixpack 2a.
This TCP/IP Problem never occured on V5.2.

I also get this TCP/IP errors in db2diag.log on the AIX box when I connect
with my (Windows NT) Control Center to this database !

Is anybody able to give me a hint what kind of problem this is ?

Thank you !
Peter

-----------------------------------------------------------------------------------


Peter Horner, ISDD
Bank Julius Baer & Co. Ltd.
Hohlstrasse 602, CH-8010 Zurich, Switzerland
Telephone +41 (1) 437 44 04, Fax +41 (1) 437 44 75
www.juliusbaer.com
-----------------------------------------------------------------------------------

























































*****Disclaimer*****
This message is for the addressee only and may contain confidential or
privileged information. You must delete and not use it if you are not the
intended recipient. It may not be secure or error-free. All e-mail
communications to and from the Julius Baer Group may be monitored.
Processing of incoming e-mails cannot be guaranteed. Any views expressed in
this message are those of the individual sender. This message is for
information purposes only. All liability of the Julius Baer Group and its
entities for any damages resulting from e-mail use is excluded. US persons
are kindly requested to read the important legal information presented
after clicking here: http://www.juliusbaer.com/maildisclaimer








------------------------------------------------------------------------
The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged
material. Any review, retransmission, dissemination or other use of, or
taking of any action in reliance upon, this information by persons or
entities other than the intended recipient is prohibited. If you received
this in error, please contact the sender and delete the material from any
computer.