Skip to Content
0
Former Member
Aug 24, 2009 at 02:57 PM

Unexpected minimum value for SHEAPTHRES_SHR

72 Views

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.

Pl advise.

Thanks.