pls check db2diag.log firstly to find the Error
weiruan85 发表于 2013-3-15 09:35
首先谢谢大家的帮助,我举一个实际的例子来说明一下吧,今天我在应用日志中找到:03-15 09:49:29,041 [WebContainer : 30] ERROR [com.xxx.framework.actions.FlowAction:73] - ERROR_EXCP :
com.ibm.db2.jcc.b.pm: 2. SQLCODE=-911, SQLSTATE=40001, DRIVER=3.50.152
at com.ibm.db2.jcc.b.wc.a(wc.java:568)
at com.ibm.db2.jcc.b.wc.a(wc.java:57)
at com.ibm.db2.jcc.b.wc.a(wc.java:126)
at com.ibm.db2.jcc.b.jk.b(jk.java:3578)
at com.ibm.db2.jcc.t4.eb.h(eb.java:266)
at com.ibm.db2.jcc.t4.eb.a(eb.java:227)
at com.ibm.db2.jcc.t4.eb.c(eb.java:31)
at com.ibm.db2.jcc.t4.u.a(u.java:32)
at com.ibm.db2.jcc.t4.j.Xb(j.java:245)
at com.ibm.db2.jcc.b.jk.X(jk.java:3412)
at com.ibm.db2.jcc.t4.d.g(d.java:1837)
at com.ibm.db2.jcc.b.bc.a(bc.java:207)
at com.ibm.db2.jcc.b.jk.c(jk.java:296)
at com.ibm.db2.jcc.b.jk.next(jk.java:258)
报错时应用日志打印的时间点是03-15 09:49:29,041,根据这个时间点到db2diag日志中查找
C:\>db2diag -t 2013-03-15-09.40:2013-03-15-10
2013-03-15-09.40.13.829000+480 I554065H497 LEVEL: Warning
PID : 3768 TID : 5920 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : YYYY
APPHDL : 0-8 APPID: *LOCAL.DB2.130312095744
AUTHID : YYYY
EDUID : 5920 EDUNAME: db2stmm (YYYY)
FUNCTION: DB2 UDB, Self tuning memory manager, stmmEnforceMinSizeConstraints, pr
obe:2255
MESSAGE : Unable to find donor to satisfy minSize constraint
2013-03-15-09.43.13.827000+480 I554564H497 LEVEL: Warning
PID : 3768 TID : 5920 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : YYYY
APPHDL : 0-8 APPID: *LOCAL.DB2.130312095744
AUTHID : YYYY
EDUID : 5920 EDUNAME: db2stmm (YYYY)
FUNCTION: DB2 UDB, Self tuning memory manager, stmmEnforceMinSizeConstraints, pr
obe:2255
MESSAGE : Unable to find donor to satisfy minSize constraint
2013-03-15-09.46.13.825000+480 I555063H497 LEVEL: Warning
PID : 3768 TID : 5920 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : YYYY
APPHDL : 0-8 APPID: *LOCAL.DB2.130312095744
AUTHID : YYYY
EDUID : 5920 EDUNAME: db2stmm (YYYY)
FUNCTION: DB2 UDB, Self tuning memory manager, stmmEnforceMinSizeConstraints, pr
obe:2255
MESSAGE : Unable to find donor to satisfy minSize constraint
2013-03-15-09.49.13.822000+480 I555562H497 LEVEL: Warning
PID : 3768 TID : 5920 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : YYYY
APPHDL : 0-8 APPID: *LOCAL.DB2.130312095744
AUTHID : YYYY
EDUID : 5920 EDUNAME: db2stmm (YYYY)
FUNCTION: DB2 UDB, Self tuning memory manager, stmmEnforceMinSizeConstraints, pr
obe:2255
MESSAGE : Unable to find donor to satisfy minSize constraint
2013-03-15-09.52.13.820000+480 I556061H497 LEVEL: Warning
PID : 3768 TID : 5920 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : YYYY
APPHDL : 0-8 APPID: *LOCAL.DB2.130312095744
AUTHID : YYYY
EDUID : 5920 EDUNAME: db2stmm (YYYY)
FUNCTION: DB2 UDB, Self tuning memory manager, stmmEnforceMinSizeConstraints, pr
obe:2255
MESSAGE : Unable to find donor to satisfy minSize constraint
2013-03-15-09.55.13.818000+480 I556560H497 LEVEL: Warning
PID : 3768 TID : 5920 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : YYYY
APPHDL : 0-8 APPID: *LOCAL.DB2.130312095744
AUTHID : YYYY
EDUID : 5920 EDUNAME: db2stmm (YYYY)
FUNCTION: DB2 UDB, Self tuning memory manager, stmmEnforceMinSizeConstraints, pr
obe:2255
MESSAGE : Unable to find donor to satisfy minSize constraint
2013-03-15-09.58.13.815000+480 I557059H497 LEVEL: Warning
PID : 3768 TID : 5920 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : YYYY
APPHDL : 0-8 APPID: *LOCAL.DB2.130312095744
AUTHID : YYYY
EDUID : 5920 EDUNAME: db2stmm (YYYY)
FUNCTION: DB2 UDB, Self tuning memory manager, stmmEnforceMinSizeConstraints, pr
obe:2255
MESSAGE : Unable to find donor to satisfy minSize constraint
从数据库日志可以看出,这条-911信息根本没有记录在db2diag日志中。所以无法根据“com.ibm.db2.jcc.b.pm: 2. SQLCODE=-911, SQLSTATE=40001, DRIVER=3.50.152”知道这是locktimeout还是deadlock。
收起