情况是在执行存储过程时候报错,返回SQLCODE -5704
数据库STMM设置ON,数据库内存设置成自动。
服务器内存是8G
日志如下:
2012-06-13-00.18.32.160096+480 E337789886A643 LEVEL: Warning
PID : 581796 TID : 14683 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-14495 APPID: *LOCAL.DB2.120517235510
AUTHID : DBREAD
EDUID : 14683 EDUNAME: db2stmm (DATAIRSS) 0
FUNCTION: DB2 UDB, Self tuning memory manager, stmmCheckIfFreeMemoryIsEnoughForSizeIncr, probe:663
MESSAGE : ZRC=0xFFFFEC49=-5047
DATA #1 : String, 144 bytes
There is not enough free memory for size increase. Free memory in pages: Physical memory = 0, Instance memory = 767897, Database memory = 221328
2012-06-13-00.18.32.160533+480 I337790530A634 LEVEL: Error
PID : 581796 TID : 14683 PROC : db2sysc 0
INSTANCE: db2admin NODE : 000 DB : DATAIRSS
APPHDL : 0-14495 APPID: *LOCAL.DB2.120517235510
AUTHID : DBREAD
EDUID : 14683 EDUNAME: db2stmm (DATAIRSS) 0
FUNCTION: DB2 UDB, Self tuning memory manager, stmmUpdateDBConfig, probe:275
MESSAGE : ZRC=0x82AE00A7=-2102525785=STMM_CONFIG_UPDATE_FAILED
"An attempted configuration update failed"
DATA #1 : String, 75 bytes
Error updating parameter Sheapthres_shr, updateValue = 711, sqlcode = -5047
收起