Our web application hits the following two exceptions randomly (once or
twice a day) while opening connection to db2. Does anyone has idea
about the cause of the exception. We are using connection pool to
connect to db2.
A little background:
WebSphere Server : version 6.0.2.9 on AIX
Database product name : DB2/AIX64
Database product version : SQL08025
JDBC driver name : IBM DB2 JDBC Universal Driver Architecture
JDBC driver version : 2.9.31
JDBC driver type : 4
---------------------------------------------------------------------------------------------------------------
java.lang.reflect.InvocationTargetException : Error opening socket to
server _server_name_/_server_ip_ on port _port_no_ with message : null
DB2ConnectionCorrelator: null
DSRA0010E: SQL State = null, Error Code = -4,499
DSRA0010E: SQL State = null, Error Code = -4,499
---------------------------------------------------------------------------------------------------------------
java.sql.SQLException: A communication error has been detected.
Communication protocol being used: T4Agent.sendRequest().
Communication API being used: OutputStream.flush().
Location where the error was detected: There is no process to read data
written to a pipe..
Communication function detecting the error: *.
Protocol specific error codes(s) TCP/IP SOCKETS
DB2ConnectionCorrelator: null
DSRA0010E: SQL State = null, Error Code = -4,499
DSRA0010E: SQL State = null, Error Code = -4,499
---------------------------------------------------------------------------------------------------------------
Any help appreciated!
I would start looking at your TCP/IP connection to that server. Base on
the error, it looks like AppServer looses TCP/IP connection to DB2
server.
oxg...@gmail.com 寫道: