场景:高并发数据查询操作 版本信息: DB2 10.5.2
硬件: CPU128C,256G
症状:运行异常,生成FODC文件,内存溢出,数据库宕机
日志:
LEVEL: Warning
PID : 10944700 TID : 3600 PROC : db2sysc 3
INSTANCE: NODE : 003 DB :
APPHDL : 0-111 APPID:
AUTHID : HOSTNAME:
EDUID : 3600 EDUNAME: db2agntp (node) 3
FUNCTION: DB2 UDB, Self tuning memory manager, stmmActivateTuningIfNecessary, probe:30
MESSAGE : ZRC=0x02AE009F=44957855=STMM_TUNING_ACTIVATION_NOT_NECESSARY
"STMM activation not necessary"
DATA #1 : String, 232 bytes
The current database has not been activated and as a result, the self tuning memory feature is not available. To allow for the enablement of the self tuning memory feature, activate the database using the ACTIVATE DATABASE command.
收起