DB2 server 在链接数增多的情况下 就会报错 如下:
04:47:24 com.mchange.v2.c3p0.impl.NewPooledConnection@5850b563 invalidated by Exception.
com.ibm.db2.jcc.am.DisconnectNonTransientConnectionException: [jcc][t4][2030][11211][3.61.86] A communication error occurred during operations on the connection's underlying socket, socket input stream,
or socket output stream. Error location: T4Agent.sendRequest() - flush (-1). Message: Broken pipe. ERRORCODE=-4499, SQLSTATE=08001
at com.ibm.db2.jcc.am.ed.a(ed.java:319)
at com.ibm.db2.jcc.t4.a.a(a.java:461)
at com.ibm.db2.jcc.t4.a.a(a.java:456)
at com.ibm.db2.jcc.t4.a.C(a.java:397)
at com.ibm.db2.jcc.t4.a.r(a.java:354)
at com.ibm.db2.jcc.am.o.a(o.java:204)
at com.ibm.db2.jcc.am.in.wc(in.java:3182)
at com.ibm.db2.jcc.am.in.c(in.java:771)
at com.ibm.db2.jcc.am.in.setNull(in.java:736)
......................
......................
04:47:24 04:47:24 CONNECTION ERROR OCCURRED!
04:47:24 CONNECTION ERROR OCCURRED!
04:47:24 04:47:24 A ConnectionTest has failed, reporting that all previously acquired Connections are likely invalid. The pool will be reset.
04:47:24 A ConnectionTest has failed, reporting that all previously acquired Connections are likely invalid. The pool will be reset.
04:47:24 04:47:24 trace com.mchange.v2.resourcepool.BasicResourcePool@66d6ecf1 [managed: 19, unused: 18, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@3f52ce26)
但是 : dbm 的配置信息中的设置是没有限制的:
Max number of coordinating agents (MAX_COORDAGENTS) = AUTOMATIC(250)
Max number of client connections (MAX_CONNECTIONS) = AUTOMATIC(1000)
查看其他报错帖子 有可能是:TCP/IP服务名称和 /etc/services中定义的db2服务名称不一致,导致连接不上
check 本地tcp/ip 设置和 /etc/services 文件的配置 :
TCP/IP Service name (SVCENAME) = db2c_db2inst1
db2c_db2inst1 50000/tcp
DB2_HADR_1 55001/tcp
DB2_HADR_2 55002/tcp
DB2_db2inst1 60000/tcp
DB2_db2inst1_1 60001/tcp
DB2_db2inst1_2 60002/tcp
DB2_db2inst1_END 60003/tcp
并没有不一致的情况
那位高手遇到过这类情况 请指点下哦
收起