Dear All,

We encounter the following error with DB2, which will hang the web server (Sun Java web server). Any advise about what the problem is? Is it an issue with DB2, or MS Windows Server 2003, or the web server?

TIA.

------------------------------------------------------------------
2007-01-09-09.45.28.765000 InstanceB2 Node:000
PID:2680(webservd.exe) TID:456 Appid:*LOCAL.DB2.070109021916
common_communication sqlcctcpconnr Probe:101
DIA3202C The TCP/IP call "connect" returned an errno="10048".

try manuel connect from client (as) to db2 from command window and see complete sqlcode/retcode
according the message something todo with ip/port
see message and codes/2 for description of 10048

I saw the explanation for error 10048 in db2 manual. Don't quite understand. It is something to do with the application, the configuration of DB2, or the network connectivity?


WSAEADDRINUSE (10048): Address already in use. Only one usage of each socket address (protocol/IP address/port) is normally permitted. This error occurs if an application attempts to bind() a socket to an IP address/port that has already been used for an existing socket, or a socket that wasn't closed properly, or one that is still in the process of closing.

So, did you do the manuel connect ? and the result ?

yeap. no problem with manual connection.