Hi Folks - We keep getting the following message every 30 seconds on our BI QA server.
2009-08-24-07.26.17.263989-240 E78429A607 LEVEL: Warning
PID : 930014 TID : 15425 PROC : db2sysc 0
INSTANCE: db2bq1 NODE : 000 DB : BQ1
APPHDL : 0-28423 APPID: *LOCAL.DB2.090808073504
AUTHID : DB2BQ1
EDUID : 15425 EDUNAME: db2stmm (BQ1) 0
FUNCTION: DB2 UDB, Self tuning memory manager, stmmComputeMinSHEAPTHRES, probe:836
MESSAGE : Unexpected minimum value for SHEAPTHRES_SHR - value automatically
corrected - 122423 - 2448 - 338887 - 9180 - 3 - 0 - 3.000000 -
1 - 31 - 271110 - 630
I am pretty sure this will have performance impact on the database as the database manager has to keep changing the SHEAPTHRES_SHR value every 30 seconds back to the correct value. Has any one seen this before? Turning off STMM is not an option. We do not want to hard code SHEAPTHRES_SHR value as the loads on BI are not-predictable in the environment.