Ignite for DB2 is the one monitoring solution that identifies, analyzes and resolves all of the performance problems affecting applications and users depending on DB2 LUW databases.
Ignite doesn’t just show health metrics, it correlates the most important performance data to build a complete picture of DB2 database performance for the DBA, Developer and DBA manager. Response time, queries, sessions and server resources, are all analyzed by Ignite Performance Intelligence to show both historical and real-time conditions affecting database applications.
Response Time Analysis
Ignite applies Response Time analysis techniques to DB2 database performance management. Ignite measures time associated with each tiny operation – or Wait Event - and uses it to expose delays in end user service. This is the most important indicator, since it shows applications waiting on DB2 to respond.
But Ignite does not stop there. It gathers real time session data, server resource levels, and query information. It analyzes historical trends of response time over 4 different dimensions – such as wait event, program or partition. Then Ignite correlates the data to lead the DBA through the most important problems and solutions.
Ignite 8 is the biggest expansion ever for Ignite, creating a complete DB2 LUW performance solution. Now Ignite goes beyond response time to correlate real time session activity and server health. And now Ignite identifies the most important problems and leads the DBA or developer right to the solution.
Current and Historical Dashboards
Ignite 8 adds two new dashboards for instant viewing and analysis of each DB2 instance. The Current Dashboard highlights real time problems, updated in seconds. The Trend Dashboard identifies Top Problems found over months, weeks and days. Performance Intelligence ties it all together to correlate the symptoms and give the complete performance picture for each instance.
Top Problems
Top Problems in Ignite 8 informs the DBA of the most serious performance issues needing attention. Rather than look for clues and guess at which statistic is most important, Top Problems captures the expertise of Confio’s best DBAs to uncover urgent issues impacting performance.
The Top Problems analysis is based on Ignite Performance Intelligence. Top Problems finds trends and correlates events found hidden in the Performance Data Warehouse, then places alarms on each dashboard to make it obvious where to focus attention.
Real Time Sessions
Ignite 8 captures and displays real time session information, allowing DBAs to act instantly on critical performance issues. With session counts on the dashboard, and a detailed view of Locking and Blocking conditions, DBAs have real time information needed to respond to user calls. From the Ignite home screen, DBAs are in control, able to view recent queries or kill an offending session.
Server Health Resources
New in Ignite are Server Health Resource statistics to give DBAs a complete view of server operation. From the Ignite dashboard, DBAs can see CPU, memory, disk, sessions and license compliance and can set alarms. A customizable dashboard lets users choose from 11+ different metrics to display. Only Ignite correlates server health stats with response time, query, and problem reports.
Agentless Monitoring
Ignite for DB2 performance monitors DB2 databases without installing any software on the production systems. The Igniter Suite is built on a three tier architecture, with software installed only in the middle tier. DBAs, developers and managers access the solution from their browser. The Ignite PI application is installed on any server, with the Performance Data Warehouse installed in a SQL Server or Oracle test or development system. Ignite’s agentless probes reach across the network from PI to the monitored databases – DB2 ASE (12.5.0.3 and higher) as well as other vendors – and pull performance statistics back to the Data Warehouse.
No Load on Production Systems
Using the agentless architecture, Ignite for DB2 performance places less than 1% load on the monitored servers. For production use in the most sensitive environments, Ignite gives continuous Performance Intelligence without impacting the target system. When it is time to upgrade Ignite to access new features, all the change takes place on the Performance Data Warehouse, with nothing to change on the Client or Monitored servers. Ignite is self contained with its own captive web server, so all you need is a non-dedicated SQL Server or Oracle instance to house the Performance Data Warehouse.
