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)