运行带自定义函数的查询后,db2无法响应。
db2diag.log 的内容如下:
-----------------------------------------------------------------------
2010-05-19-23.27.59.606164+480 I1222391E567 LEVEL: Warning
PID : 5959 TID : 47458629445952PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : MISDB
APPHDL : 0-88 APPID: *LOCAL.db2inst1.100519142604
AUTHID : SXMIS
EDUID : 42 EDUNAME: db2agent (MISDB) 0
FUNCTION: DB2 UDB, Self tuning memory manager, stmmSimulateHJPackPartitions, probe:3505
DATA #1 : String, 107 bytes
Cannot continue - Estimated build size is 0.
Estimated build size= 0.00
Estimated probe size= 0.00
2010-05-19-23.27.59.606402+480 I1222959E567 LEVEL: Warning
PID : 5959 TID : 47458629445952PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : MISDB
APPHDL : 0-88 APPID: *LOCAL.db2inst1.100519142604
AUTHID : SXMIS
EDUID : 42 EDUNAME: db2agent (MISDB) 0
FUNCTION: DB2 UDB, Self tuning memory manager, stmmSimulateHJPackPartitions, probe:3505
DATA #1 : String, 107 bytes
Cannot continue - Estimated build size is 0.
Estimated build size= 0.00
Estimated probe size= 0.00
2010-05-19-23.27.59.606644+480 I1223527E567 LEVEL: Warning
PID : 5959 TID : 47458629445952PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : MISDB
APPHDL : 0-88 APPID: *LOCAL.db2inst1.100519142604
AUTHID : SXMIS
EDUID : 42 EDUNAME: db2agent (MISDB) 0
FUNCTION: DB2 UDB, Self tuning memory manager, stmmSimulateHJPackPartitions, probe:3505
DATA #1 : String, 107 bytes
Cannot continue - Estimated build size is 0.
Estimated build size= 0.00
Estimated probe size= 0.00
2010-05-19-23.29.46.767331+480 I1224095E488 LEVEL: Warning
PID : 5959 TID : 47458633640256PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : MISDB
APPHDL : 0-10 APPID: *LOCAL.DB2.100519141745
AUTHID : SXMIS
EDUID : 41 EDUNAME: db2stmm (MISDB) 0
FUNCTION: DB2 UDB, Self tuning memory manager, stmmEnforceMinSizeConstraints, probe:2358
MESSAGE : Unable to find donor to satisfy minSize constraint
2010-05-19-23.30.37.657381+480 I1224584E456 LEVEL: Warning
PID : 5957 TID : 47428111690048PROC : db2wdog 0
INSTANCE: db2inst1 NODE : 000
EDUID : 2 EDUNAME: db2wdog 0
FUNCTION: DB2 UDB, routine_infrastructure, sqlerKillAllFmps, probe:5
MESSAGE : Bringing down all db2fmp processes as part of db2stop
DATA #1 : Hexdump, 4 bytes
0x00002B22B7BFC470 : 0000 0000
----------------------------------------------------------------------------------------
添加新评论0 条评论