Toad World® Forums

Db2 Monitoring

Hi all,

I checked logs.Sometimes it shows this error.What is the issue and how we can resolve? please help me out.

AUTHID : APP_USER HOSTNAME: UPCDCDDMB01

EDUID : 12003 EDUNAME: db2agent (UPCMBDB) 0

FUNCTION: DB2 UDB, Self tuning memory manager, stmmSimulateSortMerge, probe:3355

MESSAGE : ZRC=0x87AE0165=-2018639515=STMM_SEVERE_ERROR

“Severe error encountered in self tuning memory manager”

DATA #1 : String, 91 bytes

ERROR simulation of real configuration has failed - not reporting benefit for this operator

2017-02-27-15.39.51.884502+330 I288755625E709 LEVEL: Warning

PID : 4431 TID : 47011483084544 PROC : db2sysc 0

INSTANCE: db2inst1 NODE : 000 DB : UPCMBDB

APPHDL : 0-36663 APPID: 10.1.1.21.49426.170305100814

AUTHID : APP_USER HOSTNAME: UPCDCDDMB01

EDUID : 7659 EDUNAME: db2agent (UPCMBDB) 0

FUNCTION: DB2 UDB, Self tuning memory manager, stmmSimulateSortMerge, probe:3355

MESSAGE : ZRC=0x87AE0165=-2018639515=STMM_SEVERE_ERROR

“Severe error encountered in self tuning memory manager”

DATA #1 : String, 91 bytes

ERROR simulation of real configuration has failed - not reporting benefit for this operator

2017-02-27-15.40.34.263479+330 I288756335E709 LEVEL: Warning

PID : 4431 TID : 47013009811200 PROC : db2sysc 0

INSTANCE: db2inst1 NODE : 000 DB : UPCMBDB

APPHDL : 0-45651 APPID: 10.1.1.25.43103.170305120813

AUTHID : APP_USER HOSTNAME: UPCDCDDMB01

EDUID : 12031 EDUNAME: db2agent (UPCMBDB) 0

FUNCTION: DB2 UDB, Self tuning memory manager, stmmSimulateSortMerge, probe:3355

MESSAGE : ZRC=0x87AE0165=-2018639515=STMM_SEVERE_ERROR

“Severe error encountered in self tuning memory manager”

DATA #1 : String, 91 bytes

ERROR simulation of real configuration has failed - not reporting benefit for this operator

2017-02-27-15.41.21.620961+330 I288757045E709 LEVEL: Warning

PID : 4431 TID : 46912841443072 PROC : db2sysc 0

INSTANCE: db2inst1 NODE : 000 DB : UPCMBDB

APPHDL : 0-46753 APPID: 10.1.1.25.43243.170305120906

AUTHID : APP_USER HOSTNAME: UPCDCDDMB01

EDUID : 12033 EDUNAME: db2agent (UPCMBDB) 0

FUNCTION: DB2 UDB, Self tuning memory manager, stmmSimulateSortMerge, probe:3355

MESSAGE : ZRC=0x87AE0165=-2018639515=STMM_SEVERE_ERROR

“Severe error encountered in self tuning memory manager”

DATA #1 : String, 91 bytes

ERROR simulation of real configuration has failed - not reporting benefit for this operator

[db2inst1@UPCDCDDMB01 db2dump]$

Deepshika,

This warning message is stating that one of the STMM parameters could not be adjusted for some reason. STMM was either trying to increase one of the parameters but the memory was not available or STMM was trying to decrease one of the parameters but for some reason could not.

The STMM log should provide you with more information. It is located in /sqllib/db2dump/stmmlog. Look to see what parameter was trying to be adjusted during the timestamp in the db2diag.log.

Also make sure all of the STMM parameters are set to AUTOMATIC including all of the bufferpools.

If all else fails then open a PMR with IBM.

Thanks,

Eric Sheridan