Team with the best
Db2® LUW Performance Tools
company in the World

A History of Innovation in Database Performance Improvment

When we do a root cause analysis on DBI's successes, the most fundamental contributing factor is innovation. DBI's founder, Scott Hayes, invented SQL statement concentration in the year 2000 as documented by U.S. Patent #6,772,411. Scott was first to talk about automating DB2 UDB tuning in his 1997 IDUG presentation "Tune DB2 Universal Server while you Fish, Golf...", and in DB2 V9.1 the Self Tuning Memory Manager (STMM) was introduced in 2006. The Db2 Statement Concentrator (STMT_CONC) was introduced to DB2 in V9.7, and a unique statement identifier was added to DB2 V10.5 FP3. DBI pureFeat began automatically tracking configuration and index changes way back in 2008, and in 2012 IBM added a Change History Event Monitor to DB2 V10.1. Having data is one thing, and presenting it in meaningful ways is yet another. DBI pureFeat excels in performance information presentation, and DBI is widely appreciated for its ease of use. Now since most tool vendors will readily claim that their toolset is easy to use, we need to take a closer look and you can decide for yourself during your own evaluations.

From Problems to TRUSTED Solutions in Five Mouse Clicks, or Less!

What are the problems?

Is a performance issue a database problem, or not? If it is, what is the bottleneck? Where is time being spent? What are the SQL statements causing the time spent? Which SQL are the heaviest CPU and I/O consumers that are weighing down the database and degrading performance? A well stated problem is a half solved problem. You can't fix something until you know what needs to be fixed! Sometimes problems are small, latent, or hidden, yet quietly waiting to cause a performance disaster --- we politely call these "opportunities for improvement". DBI can show you the real root cause problems, based on aggregated relative weight analysis, or opportunities, in just one or two mouse clicks. We'll illustrate in the short video clip just below...



Scott Hayes talked about root cause problem isolation at IDUG in 2014 during his tech session "DB2 LUW Sage Performance Advice". If you missed this presentation and would like to learn more, watch a replay of The DB2Night Show Episode #142.

NEXT Button TRUSTWORTHY Solutions

Quick Links

DBI pureFeat™ Performance Suite for IBM® DB2® LUW includes:


Recommended DBI Partner Solutions

QuickSelect® by AlignOps Got DB2® on z/OS? Our partner, AlignOps LLC, provides a unique in-memory SQL workload accelerator. Learn how to slash the cost of repetitive SQL, and improve workload performance by visiting http://www.optimizedatabase.com

Compare Tools for IBM® DB2® LUW

Compare DBI's Integrated Suite of DB2 Performance Analysis, Tuning, Trending, and Alerting tools with IBM OPM and Quest.
IBM DB2 LUW Tools Comparison
Compare Brother-Hawk to the IBM DB2 LUW Health Monitor!