Contact Hyperic
Hyperic Systems & Application Monitoring - Company Logo
BUY  |  DEMO  |  FORUMS  |  BLOG  |  1-888-4HYPERIC (1-888-449-7374)


Enterprise application and systems management for large scale Web infrastructure
More about Hyperic HQE

Open Source Systems Monitoring
Open source systems management and monitoring
More about Hyperic HQ

DB2 Monitoring & Management

DB2 is IBM's enterprise database product. It is supported across a vast number of operating systems, and is capable of running multi-terabyte databases with maximum performance and scalability.

HQ uses DB2's native client interface to obtain highly granular measurements for the database engine, each instance, as well as individual tables. This capability is delivered by HQ across all platforms which DB2 runs on, including AIX, Linux, and Windows and allows you to obtain management capabilities previously only accessible to DBA tools in a solution you can use to manage the resources that your DB2 infrastructure depends on.

Hyperic HQ aims to provide DB2 users the management capabilities typically found in database centric tools coupled with management support for the other technologies which, along with databases, are used in today's enterprise environment.

Its powerful application concept allows you to visualize monitoring data from your database tier alongside your business logic and presentation tiers by giving you the ability to measure how client activity is reflected across the various layers of your application infrastructure.

For more information, please visit our IBM DB2 plugin HyperFORGE page.

Auto-Discover your hardware and IBM DB2 servers
Monitor every metric, log, and configuration for all IBM DB2 resources in your inventory
Identify problem resources with automatic baselines for every metric
Control all your IBM DB2 resources on-demand, on schedule, or in response to alerts
Alert on any measurement, log, or security event in your IBM DB2 environment

System Supported Versions

  • DB2 7.x
  • DB2 8.x
  • DB2 9.x

System Monitoring Specification

General Server Metrics
  • Availability
  • Agents Created Because Pool Was Empty
  • Agents Created Because Pool Was Empty per Minute
  • Agents Assigned From Pool
  • Agents Assigned From Pool per Minute
  • Agents Registered
  • Agents Stolen
  • Agents Stolen per Minute
  • Agents Waiting On Token
  • Commited Private Memory
  • Local Databases with Connects
  • Gateway Connections Waiting For Client
  • Gateway Connections Waiting for Host
  • Gateway Connections Current
  • Gateway Connections Total
  • Gateway Connections Total per Minute
  • Idle Agents
  • Local Connections Current
  • Local Connections in Exec
  • Max Agent Overflows
  • Max Agent Overflows per Minute
  • Piped Sorts Accepted
  • Piped Sorts Accepted per Minute
  • Piped Sorts Requested
  • Piped Sorts Requested per Minute
  • Post Threshold Hash Joins
  • Post Threshold Hash Joins per Minute
  • Post Threshold Sorts
  • Post Threshold Sorts per Minute
  • Remote Connections
  • Remote Connections in Exec
  • Sort Heap Allocated
  • Start Time
DB2 7.x, 8.x and 9.x Tablespace Metrics
  • Availability
  • Buffer Pool Data Logical Reads
  • Buffer Pool Data Logical Reads per Minute
  • Buffer Pool Data Reads
  • Buffer Pool Data Reads per Minute
  • Buffer Pool Data Async Reads
  • Buffer Pool Data Async Reads per Minute
  • Buffer Pool Data Writes
  • Buffer Pool Data Writes per Minute
  • Buffer Pool Data Async Writes
  • Buffer Pool Data Async Writes per Minute
  • Buffer Pool Index Logical Reads
  • Buffer Pool Index Logical Reads per Minute
  • Buffer Pool Index Reads
  • Buffer Pool Index Reads per Minute
  • Buffer Pool Index Writes
  • Buffer Pool Index Writes per Minute
  • Buffer Pool Index Async Writes
  • Buffer Pool Index Async Writes per Minute
  • Buffer Pool Read Time
  • Buffer Pool Read Time per Minute
  • Buffer Pool Write Time
  • Buffer Pool Write Time per Minute
  • Buffer Pool Async Read Time
  • Buffer Pool Async Read Time per Minute
  • Buffer Pool Async Write Time
  • Buffer Pool Async Write Time per Minute
  • Buffer Pool Async Data Read Reqs
  • Buffer Pool Async Data Read Reqs per Minute
  • Direct Reads
  • Direct Reads per Minute
  • Direct Writes
  • Direct Writes per Minute
  • Direct Read Reqs
  • Direct Read Reqs per Minute
  • Direct Write Reqs
  • Direct Write Reqs per Minute
  • Direct Read Time
  • Direct Read Time per Minute
  • Direct Write Time
  • Direct Write Time per Minute
  • File Closed
  • File Closed per Minute
DB2 7.x, 8.x and 9.x Table Metrics
  • Availability
  • Rows Read
  • Rows Read per Minute
  • Rows Written
  • Rows Written per Minute
  • Overflow Accesses
  • Overflow Accesses per Minute
  • Page Reorgs
  • Page Reorgs per Minute
DB2 7.x, 8.x and 9.x Database Metrics
  • Availability
  • Locks Held
  • Lock Waits
  • Locks Wait Time
  • Locks Wait Time per Minute
  • Lock List in Use
  • Lock Timeouts
  • Lock Timeouts per Minute
  • Deadlocks
  • Deadlocks per Minute
  • Sort Heap Allocated
  • Sorts Total
  • Sorts Total per Minute
  • Sorts Active
  • Sort Time Total
  • Sort Time Total per Minute
  • Sort Overflows
  • Sort Overflows per Minute
  • Buffer Pool Data Logical Reads
  • Buffer Pool Data Logical Reads per Minute
  • Buffer Pool Data Reads
  • Buffer Pool Data Reads per Minute
  • Buffer Pool Data Writes
  • Buffer Pool Data Writes per Minute
  • Buffer Pool Index Logical Reads
  • Buffer Pool Index Logical Reads per Minute
  • Buffer Pool Index Reads
  • Buffer Pool Index Reads per Minute
  • Buffer Pool Index Writes
  • Buffer Pool Index Writes per Minute
  • Buffer Pool Read Time
  • Buffer Pool Read Time per Minute
  • Buffer Pool Write Time
  • Buffer Pool Write Time per Minute
  • Files Closed
  • Files Closed per Minute
  • SQL Commit Statements
  • SQL Commit Statements per Minute
  • SQL Rollback Statements
  • SQL Rollback Statements per Minute
  • SQL Dynamic Statements
  • SQL Dynamic Statements per Minute
  • SQL Static Statements
  • SQL Static Statements per Minute
  • SQL Failed Statements
  • SQL Failed Statements per Minute
  • SQL Select Statements
  • SQL Select Statements per Minute
  • SQL DDL Statements
  • SQL DDL Statements per Minute
  • SQL Update/Insert/Delete Statements
  • SQL Update/Insert/Delete Statements per Minute
  • Rows Deleted
  • Rows Deleted per Minute
  • Rows Inserted
  • Rows Inserted per Minute
  • Rows Updated
  • Rows Updated per Minute
  • Rows Selected
  • Rows Selected per Minute
  • Buffer Pool Data Async Reads
  • Buffer Pool Data Async Reads per Minute
  • Buffer Pool Data Async Writes
  • Buffer Pool Data Async Writes per Minute
  • Buffer Pool Index Async Writes
  • Buffer Pool Index Async Writes per Minute
  • Buffer Pool Async Read Time
  • Buffer Pool Async Read Time per Minute
  • Buffer Pool Async Write Time
  • Buffer Pool Async Write Time per Minute
  • Direct Writes
  • Direct Writes per Minute
  • Direct Read Reqs
  • Direct Read Reqs per Minute
  • Direct Write Reqs
  • Direct Write Reqs per Minute
  • Direct Read Time
  • Direct Read Time per Minute
  • Direct Write Time
  • Direct Write Time per Minute
  • First Connect Time
  • Total Connects
  • Total Connects per Minute
  • Log Space Allocated
  • Log Space Allocated per Minute
  • Log Writes
  • Log Writes per Minute
  • Log Reads
  • Log Reads per Minute
  • Package Cache Lookups
  • Package Cache Lookups per Minute
  • Package Cache Inserts
  • Package Cache Inserts per Minute
  • Catalog Cache Inserts
  • Catalog Cache Inserts per Minute
  • Catalog Cache Lookups
  • Catalog Cache Lookups per Minute
  • Catalog Cache Overflows
  • Catalog Cache Overflows per Minute
  • Catalog Cache Heap Full
  • Catalog Cache Heap Full per Minute
  • Hash Joins Total
  • Hash Joins Total per Minute
  • Hash Loops Total
  • Hash Loops Total per Minute
  • Hash Join Overflows
  • Hash Join Overflows per Minute
  • Hash Join Small Overflows
  • Hash Join Small Overflows per Minute