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

Comparing DB2 LUW Performance Tools

Feature/Capability DBI
Performance
Tools
IBM
OPM
Quest/
DELL
Exploits US Patented SQL Workload Analysis to compress SQL statement workloads and aggregate total and relative costs for each statement so that the DBA can find the statements that are truly the most harmful to performance and database efficiency. Box Checked Box Unchecked Box Unchecked
Industry Breakthrough! Provides the ability to compare database and SQL workload performance, side by side, for two different timeframes! Now, after upgrading DB2, applying a fixpack, or implementing an application change, you can discover exactly where performance improved or degraded, and by how much! In just TWO mouse clicks! Box Checked Box Unchecked Box Unchecked
Industry Breakthrough! For any specified time period, provides the capability to summarize the application programs and users that were executing in the database with total, average, and relative costs, plus provides drill downs to the SQL executed by programs and users. Box Checked Box Unchecked Box Unchecked
Industry Breakthrough! Given any SQL statement in a workload, provides the ability to reverse engineer which Users or Programs executed the statement within a specific timeframe of interest along with total costs, relative costs, and averages. Box Checked Box Unchecked Box Unchecked
Industry Breakthrough! Provides recommendations for optimal use of Solid State Disk (SSD) in just two mouse clicks! Box Checked Box Unchecked Box Unchecked
Provides a Database Score, like a credit score, for each database and database partition to make it easy to compare and triage which databases need the most urgent help, and which partitions suffer from load imbalance and skew. Box Checked Box Unchecked Box Unchecked
Supports DB2 9 pureXML by providing XDA performance metrics in addition to relational metrics, and is able to process xQuery statements in context alongside regular SQL statements. Box Checked Box Unchecked Box Unchecked
Provides the ability to store and save several months or years of database, partition, bufferpool, tablespace, and statement performance, along with configuration history, over a light weight network connection into a relatively small storage footprint. Box Checked Box Unchecked Box Unchecked
Provides performance trend charts for key metrics over any captured historical time period along with integrated significant change events plotted on the performance graphs. With this capability, the DBA team can visually see, compare, and verify the performance consequences of configuration changes, memory changes, STMM memory changes, registry variable changes, index changes and more. Chart drill downs show the DBA details of the tracked changes. If you want to have confidence that a change actually improved performance, or if you want to trust STMM to optimize memory performance, this capability is essential! Box Checked Box Unchecked Box Unchecked
Provides the ability to graph the performance of any individual statement, dyanmic or STATIC, over time with correlated change events plotted on the graphs. Now you can see if the performance of a statement is improving or degrading, and verify that changes have contributed to improved performance. Box Checked Box Unchecked Box Unchecked
Provides the ability to attach "Sticky Note" follow up flags to statements within a workload. Sticky note follow up flags provide a scratch pad for team members to take electronic notes and collaborate. Box Checked Box Unchecked Box Unchecked
Provides the capability to easily find all SQL statements driving I/O to a given table, even if the SQL references view names, views on views, aliases or STATIC SQL. This ability is critically important because the IBM Design Advisor makes recommendations at the TABLE level (indexes, MDC, MQT, partitioning keys) and optimized results are achieved by giving the IBM Design Advisor a WORKLOAD of the most costly statements accessing a table. Box Checked Box Unchecked Box Unchecked
For a given statement, provides integrated workflows to Explain and DB2 Advisor utilities. (To be fair, we thought we should give the other guys some check marks). Box Checked Box Checked Box Checked
Provides basic DB2 performance metrics such as bufferpool, catalog cache, and package cache hit ratios, log space utilization. Bufferpool hit ratios are folly! Read the blog post on bufferpool folly... Box Checked Box Checked Box Checked
Provides genuinely helpful performance metrics such as Index Read Efficiency (IREF), Asynchronous Pages Read per Request (APPR), Cost metrics useful for detecting scans ( TBRRTX, BPLITX), and integrates OS statistics such as CPU busy%, Paging, and Memory alongside DB2 performance metrics. Box Checked Box Unchecked Box Unchecked
Provides the ability to measure average database transaction response times for any selected time period along with graphically showing how much time is spent inside DB2 and out, where the inside database time goes (what resource is the bottleneck), and Service Level Agreement attainment counts and percentages. At last, DBAs and their managers have a means to determine if a performance problem is a database problem or not, and, if so, quickly isolate and cure the problems! Read the blog post on Performance Accountability... Box Checked Box Unchecked Box Unchecked
Provides basic DB2 alert capability on par with the DB2 Health Monitor. Box Checked Box Checked Box Checked
Provides the industry's most advanced lights out alert capability on real-time and near real-time computed metrics, and allows you to create an alert rule based on any performance, availability, or business data. Alerts can be sent via email, SMS text page, or SNMP Trap alerts to central consoles such as IBM Tivolia. By advanced alerts, we mean the ability to send an alert if, for example, any one SQL statement uses more than 50% of the CPU during the prior 30 minutes, or if during the prior 60 minutes fewer than 95% of transactions completed within the defined target SLA. Box Checked Box Unchecked Box Unchecked
Provides a fancy (eye-candy) capability to generate and benchmark query re-writes. Since the DB2 optimizer brilliantly re-writes SQL, we have to ask the question - isn't re-writing re-written SQL redundant? And, if you are running a packaged vendor application, can you really modify their SQL? Box Unchecked Box Unchecked Box Checked
Stores DB2 LUW performance data in an ORACLE database. Box Unchecked Box Unchecked Box Checked
Recently acquired by hardware company that aspires to become a company focused on Data Centers, various stock transactions being contemplated, focus and future of DB2 tools at this company uncertain since DELL has tight alliance partnerships with Oracle and Microsoft. Box Unchecked Box Unchecked Box Checked
Ready for IBM DB2 LUW V10.5 BLU. Generally ready on Day 1 to support new DB2 LUW releases and versions. Box Checked Box Checked Box Checked
Estimated Installation Time 60-90 Minutes Days Hours
Overhead. With IBM Optim Performance Manager, plan on adding CPUs to monitored server just to offset its very high overhead. ~1-3% ~20-35% ~10-20%

DB2 Performance Tools Comparison

DBI Check Mark

Most DBI customers achieve 30-90% CPU utilization reductions and measurably improved response times within just a few hours of using DBI's suite of integrated performance tools for DB2 LUW!

No other solution provider can help you cut IT costs and simultaneously improve business performance like DBI can! This is the ultimate difference!
The integrated suite of DBI DB2 LUW Performance Solutions includes: Brother-Panther® :: SQL Workload Analysis & Tuning, Performance Trends, and monitoring and analysis for all aspects of database and partition performance.

Brother-Thoroughbred® :: Advanced Transaction Time Analysis, Inside & Outside DB2 Time, and SLA attainments. Brother-Hawk™ :: The industry's most advanced Lights-Out alerting capability for proactive problem prevention and rapid identification of database performance and availability issues.

Brother-Eagle® :: Real-time performance monitoring of "What's happening right now?!?!?!" presented in a unique stock ticker format that doesn't waste the DBA's entire screen - complete with drill downs to details (Enterprise Edition only) and expert tuning advice.