The DB2Night Show #14: Crunching the Numbers and DB2 STMM


Posted by Scott on March 12, 2010, 5:09 pm
in DB2 LUW ( The DB2Night Show)

In our 14th show, show host Scott Hayes, IBM DB2 GOLD Consultant and Information Management Champion, performed a deep dive into analyzing DB2 Snapshot numbers for a production DB2/Linux 9.7 database located in the UK. This database had STMM turned on, so we did a tangential LIVE demonstration on DB2's Self Tuning Memory Manager. Discover the real truths. Our findings might surprise or shock you...
In our 14th show, show host Scott Hayes, IBM DB2 GOLD Consultant and Information Management Champion, performed a deep dive into analyzing DB2 Snapshot numbers for a production DB2/Linux 9.7 database located in the UK. This database had STMM turned on, so we did a tangential LIVE demonstration on DB2's Self Tuning Memory Manager. Discover the real truths. Our findings might surprise or shock you...


To download a recorded replay of Episode #14, right click on the link below and choose "Save As..."

Episode 14, 2010 Mar 12, Crunching the Snapshot Numbers on DB2 9.7 and STMM Demonstration


The DB2Night Show™ now has a LinkedIn Group. The group is an open group. Join to receive LinkedIn group updates including future shows and replay information, and, if you like, start some discussions about the show! Join The DB2Night Show LinkedIn Group!


Thanks for watching!


Our Shameless Marketing Moment


Too many organizations around the globe suffer from HARDWARE ADDICTION. Hardware upgrades are an extremely costly bandage, often ineffective, and frequently unnecessary. At one customer site, we reduced the number of pSeries CPUs required from 56 down to 28 in 45 minutes.


Database vendors claim that their databases are capable of self tuning, but watch this episode and you will see the full truths revealed. If your "automatically tuned" database fails to meet performance expectations, your same vendor will be delighted to sell you upgraded hardware or On Demand CPUs.


Further validating that databases are not capable of achieving performance optimization at minimal cost on their own, the database vendors also sell extra cost performance analysis tools. One of DBI's customers reported to DBI that said database vendor's performance tool took over a month to install, required several calls to Germany, frequently crashed, and added some 20% overhead to their system. Ah yes --- well, that is to be expected --- these nice folks are in the hardware business and they license their database and tools according to the installed processor capacity.


Stop letting the fox watch your hen house



Contact DBI and find out how our DB2 LUW Performance Solutions can truly help you optimize performance and lower IT costs.

Post from : http://www.dbisoftware.com/blog/db2nightshow.php
Printed from : http://www.dbisoftware.com/blog/db2nightshow.php?id=189