电信运营商Db2

db2 报错,还请大家帮忙看看,是什么问题?

2018-04-13-04.13.19.714197+480 I11261525E551 LEVEL: InfoPID : 24670 TID : 140699471177472 PROC : db2sysc 0INSTANCE: db2inst2 NODE : 000 DB : EBLPDBAPPHDL : 0-53 APPID: *LOCAL.DB2.18...显示全部

2018-04-13-04.13.19.714197+480 I11261525E551 LEVEL: Info
PID : 24670 TID : 140699471177472 PROC : db2sysc 0
INSTANCE: db2inst2 NODE : 000 DB : EBLPDB
APPHDL : 0-53 APPID: *LOCAL.DB2.180412003200
AUTHID : DB2INST2 HOSTNAME: xtptdb
EDUID : 82 EDUNAME: db2stmm (EBLPDB) 0
FUNCTION: DB2 UDB, buffer pool services, sqlbAlterBufferPoolAct, probe:90
MESSAGE : Altering bufferpool "IBMDEFAULTBP" From: "22379" <automatic> To:

      "17931" <automatic>

2018-04-13-04.13.19.738040+480 E11262077E743 LEVEL: Warning
PID : 24670 TID : 140699471177472 PROC : db2sysc 0
INSTANCE: db2inst2 NODE : 000 DB : EBLPDB
APPHDL : 0-53 APPID: *LOCAL.DB2.180412003200
AUTHID : DB2INST2 HOSTNAME: xtptdb
EDUID : 82 EDUNAME: db2stmm (EBLPDB) 0
FUNCTION: DB2 UDB, Self tuning memory manager, stmmCheckIfFreeMemoryIsEnoughForSizeIncrease, probe:702
MESSAGE : ZRC=0xFFFFEC49=-5047

      SQL5047C  Insufficient memory to execute this function.

DATA #1 : String, 139 bytes
There is not enough free memory for size increase. Free memory in pages: Physical memory = 0, Instance memory = 3536, Database memory = 368

2018-04-13-04.13.19.739022+480 I11262821E664 LEVEL: Error
PID : 24670 TID : 140699471177472 PROC : db2sysc 0
INSTANCE: db2inst2 NODE : 000 DB : EBLPDB
APPHDL : 0-53 APPID: *LOCAL.DB2.180412003200
AUTHID : DB2INST2 HOSTNAME: xtptdb
EDUID : 82 EDUNAME: db2stmm (EBLPDB) 0
FUNCTION: DB2 UDB, Self tuning memory manager, stmmUpdateDBConfig, probe:304
MESSAGE : ZRC=0x82AE00A7=-2102525785=STMM_CONFIG_UPDATE_FAILED

      "An attempted configuration update failed"

DATA #1 : String, 71 bytes
Error updating parameter Locklist, updateValue = 15744, sqlcode = -5047

2018-04-13-04.16.22.404195+480 I11263486E551 LEVEL: Info
PID : 24670

部分日志,最近db2 发生了一次crash,系统环境是linux db2版本是10.5

还请大家帮忙看看可能是什么原因

附件是完整的日志信息

附件:

附件图标db2diag.txt (11.5 MB)

收起
参与15

查看其它 2 个回答lcydb2的回答

lcydb2lcydb2系统运维工程师inspur

内存不足

系统集成 · 2018-04-17
浏览4281
  • elan  elan
    好的,谢谢啦,数据库开启了STMM,是不是也有这个原因
    2018-04-17

回答者

lcydb2
系统运维工程师inspur

lcydb2 最近回答过的问题

回答状态

  • 发布时间:2018-04-17
  • 关注会员:4 人
  • 回答浏览:4281
  • X社区推广