Dear DB2 LUW Professionals,
We need your help to improve DB2 LUW. We just ran Episode #16 of The DB2Night Show™ with special guest Adam Storm, Software Developer, DB2 Kernel Development, IBM Toronto Lab. We talked about Autonomic Memory and STMM updates. Watch the Replay. The studio audience asked a few good questions, but a vigorous email discussion ensued after the show.
Long story short, STMM is either "ON" for a parameter or "OFF". It has a VERY LONG LEASH to grow and shrink memory pools. There are some people in the DB2 LUW community that have experienced performance degradation or problems with STMM (about 20 percent in our audience survey), and a number of professionals would be more interested in using STMM if it were possible to give STMM "a short leash" - that is, for each memory pool under STMM's control, be able to specify a minimum and maximum value range. By specifying a range, one could keep STMM from making a pool too small or excessively large.
Adam told us that ranges had been considered, but were dismissed in favor of ON/OFF (I guess that was easier to implement). He also told us that range limits for STMM could be implemented if there was enough interest within the DB2 LUW community in favor of range specification capability.
Here's where you can help. We've made it really easy. Just click this MAILTO:firstname.lastname@example.org?subject=I support STMM Min Max Value Ranges link, add some text to the body of your message (optional), then click your SEND button.
Read just a bit more...
[ more.. ]