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

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

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

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

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

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

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

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

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