互联网服务

DB2 达到一定连接数时报错

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 o...显示全部
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


并没有不一致的情况

那位高手遇到过这类情况 请指点下哦收起
参与6

查看其它 4 个回答sunny_zhao0127的回答

sunny_zhao0127sunny_zhao0127数据库管理员C.H.Robinsion
结贴 发现license 过期了:dizzy:
互联网服务 · 2014-03-28
浏览1292

回答者

sunny_zhao0127
数据库管理员C.H.Robinsion
擅长领域: 数据库

sunny_zhao0127 最近回答过的问题

回答状态

  • 发布时间:2014-03-28
  • 关注会员:1 人
  • 回答浏览:1292
  • X社区推广