shine
作者shine·2010-05-19 16:01
系统工程师·

DB2 UDB, Self tuning memory manager, stmmEnforceMinSizeConstraints

字数 4958阅读 3560评论 0赞 0
运行带自定义函数的查询后,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

添加新评论0 条评论

Ctrl+Enter 发表

相关文章

相关问题

X社区推广