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

DBI pureFeat™ Web Performance Suite for IBM® DB2® LUW

  • Database Performance Analytics, Tuning, Monitoring, and Trending Solution
  • Provides a major breakthrough in performance analysis and change management
  • Finds, advises, and fixes issues related to database health and performance
  • Knows what changed, when it changed, and how the changes impacted performance
  • Comprehensive history combined with realtime analysis of performance trends

Product Resources

Compare DBI's product with IBM and Quest

Compare our Notification systems to the IBM DB2 Health Monitor


Dashboards

  • Overview of all databases monitored by the system
  • View best, worst, and average database scores
  • Comparative performance charts and metrics
  • Individual database dashboards with dynamic date ranges
  • Database charts for all metrics that affect performance
Overview

Summary statistics

  • Statistics for over 3500 metrics with threshold warnings
  • Summaries by Users, Apps, Statements, Bufferpools, Tablespaces etc.
  • Support for all types of databases, Simple, pureScale, DPF, etc.
  • Powerful search, filtering, sorting, moving and fixing columns
  • Grouping of similar metrics for easier comparisons and viewing
Overview

Responsiveness

  • Response Time Analysis and SLA Attainment Analysis
  • Monitoring of all transaction times, time distributions, and SLAs
  • Reports transactions times inside vs. outside of the database
  • Determines the resource bottlenecks for CPU, I/O, Locks, Sorts, etc.
  • Showing database availability for different cumulative time periods
Overview

Trend Charts

  • Chart metrics for a time period to spot any trends
  • Group similar metrics and compare them side by side
  • View database changes on the same timeline and add user changes
  • Pan and zoom to get high level views of trends
  • Navigate from the chart to the statistics to pin point a single issue
Overview

Advice

  • Perform a complete health check for the entire database
  • Identify database issues and provide actionable recommendations
  • Scan the database and report on objects that need attention
  • Report on tables and indexes that need reorg or have stale statistics
  • Provide automated index recommendations for problematic statements
Overview

SQL Workbench

  • SQL tuner with the ability to format and run the monitored statements
  • Display a searchable explain plan in both tree and graphical formats
  • Provide index recommendations with percentage of performance gains
  • Ability to create new virtual indexes and test them for improvements
  • Test indexes against all statements in a workload for degradation
Overview

Real Time

  • A live dashboard to view real time key metrics that affect performance
  • Charts with drill-downs to show details of the state of the database
  • Summarizes the data by Connections, Applications, Statements, etc.
  • View database contentions and locks with the ability to release them
  • Finds problems, poor performance, or inefficiencies in the database
Overview

Notifications

  • Advanced Lights-Out, flexible, and customizable alerting Solution
  • Monitors databases 24x7 and sends notifications for performance issues
  • Provides notifications in a variety of ways (email, traps, SNMP, etc.)
  • Over 200 rules out of the box with the ability to create custom ones
  • Ability to suppresses duplicate notifications to minimize the noise
Overview