Take Control of IBM DB2 Monitoring by Performance Monitoring

Applications Manager DB2 Server Monitoring capability helps database administrators (DBAs) monitor the availability and performance of production databases. It is an agentless database monitoring software that provides out-of-the-box performance metrics for ensuring the IBM DB2 database server runs efficiently.

The database monitoring tool provides a web client that helps you to visualize the network of DB2 Servers. It provides in-depth monitoring data that helps you make educated decisions about usage patterns, plan capacity and alert you of impending problems. The Root Cause analysis window helps the operations team to troubleshoot performance problems quickly. Additionally the grouping capability helps you to group your databases based on the business process supported and helps the operations team to prioritize alerts as they are received.

Some of the components that are monitored in DB2 database are:

• Connection Statistics
• Agents Statistics
• DB Information
• Transaction Statistics
• Cache Performance
• Buffer Statistics
• TableSpace Status

Monitor Custom IBM DB2 Database Queries

Additionally, Applications Manager also provides the ability to monitor any SQL Query of an IBM DB2 Database by using the Database Query Monitoring capability. With this, a DBA can monitor additional performance metrics, monitor custom database tables and even monitor and expose Business Metrics to Line of Business Managers.

Download and try the fully functional product version to know more about the DB2 database monitoring capability.

DB2 Monitoring Capabilities

• Out-of-the-box monitoring of DB2 availability and performance.
• Monitors performance statistics such as connection statistics, agent statistics etc. Alerts can be configured for these parameters.
• Based on the thresholds configured, notifications and alerts are generated. Actions are executed automatically based on configurations.
• Performance graphs and reports are available instantly. Reports can be grouped and displayed based on availability, health, and connection time.
• Delivers both historical and current DB2 performance metrics, delivering insight into the performance over a period of time.

For more information, refer DB2 Management Online Help or refer the other database monitoring capability.

Blog on : Monitor Log Files and System Events

Analyst reports state there are over 25% custom Applications out there and those apps do not have a standard way to monitor. Now here is a credible mechanism to monitor those custom applications too. Where can you use it ? 1. Use it to track Unix SysLogs and check for : * Kernel errors * Device errors * Security alerts etc ..... read full blog