It looks like you have the Self Tuning Memory Manager set to on for this
instance/database and its trying to find a candidate to lower memory use
to give back to the system, but cant do it quite yet.

Do you want to turn it off ? or cap it ?






"quigleyd" <db2udbdba-ezmlmshield-x43996303.[Email address protected]
05/31/2007 09:18 AM

To
"LazyDBA Discussion" <[Email address protected]
cc

Subject
Unable to find donor to satisfy minSize constraint







I'm getting the following message in my diag.log, i'm on v9 fixpak 1, My
db
slows down when this starts, any ideals on how I can figure out which parm
is
causing the issue.

2007-05-31-09.16.08.708879-240 I28675386A433 LEVEL: Warning
PID : 1032272 TID : 1 PROC : db2stmm (P0E) 0
INSTANCE: db2p0e NODE : 000 DB : P0E
APPHDL : 0-42 APPID: *LOCAL.db2p0e.070521174842
AUTHID : SAPR3
FUNCTION: DB2 UDB, Self tuning memory manager,
stmmEnforceMinSizeConstraints,
probe:2156
MESSAGE : Unable to find donor to satisfy minSize constraint





----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.

----- End forwarded message -----




----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



DB2 & UDB email list listserv db2-l LazyDBA home page