A division of VMware
Spring Source - Hyperic | Build, Run, Manage
REQUEST A QUOTE  |  FORUMS  |  BLOG  |      CONTACT US

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.

Hyperic 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 Hyperic 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 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
  • JDBC 9.x
  • Linux
  • Solaris
  • HPUX
  • AIX
  • MacOSX
  • FreeBSD
  • OpenBSD
  • NetBSD

System Monitoring Specification

DB2 7.x, 8.x and 9.x 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
DB2 JDBC 9.x Server Metrics
  • Availability
  • QueryExecTime
  • Current Connection
  • Applications Executing
  • Connections Top
  • Connections
  • Connections per Minute
  • Deadlocks
  • Deadlocks per Minute
  • Exclusive Lock Escalations
  • Exclusive Lock Escalations per Minute
  • Lock Escallations
  • Lock List in Use
  • Lock Waits
  • Agents Waiting On Locks
  • Lock Timeouts
  • Lock Timeouts per Minute
  • Total Sort Heap Allocated
  • Sort Share Heap Allocated
  • Sort share heap high
  • Sorts
  • Sorts per Minute
  • Sort Time
  • Sort Time per Minute
  • Sort Overflows
  • Sort Overflows per Minute
  • Internal Rows Inserted
  • Internal Rows Inserted per Minute
  • Internal Rows Updated
  • Internal Rows Updated per Minute
  • Associated Agents
  • Number of Agents Created
  • Number of Agents Created per Minute
  • Maximum Number of Coordinating Agents
  • Direct Reads
  • Direct Reads per Minute
  • Direct Reads Requests
  • Direct Reads Requests per Minute
  • Direct Reads Ratio
  • Direct Reads Ratio per Minute
  • Direct Read Time
  • Direct Read Time Average
  • Direct Writes
  • Direct Writes per Minute
  • Direct Writes Requests
  • Direct Writes Requests per Minute
  • Direct Writes Ratio
  • Direct Write Time
  • Direct Write Time Average
  • Log Read Time
  • Log Read Time per Minute
  • Log Write IO
  • Log Write IO per Minute
  • Log Read IO
  • Log Read IO per Minute
  • Log Write Time
  • Log Write Time per Minute
  • Log Reads
  • Log Reads per Minute
  • Log Writes
  • Log Writes per Minute
  • Total Logical Reads
  • Total Logical Reads per Minute
  • Data Logical Reads
  • Data Logical Reads per Minute
  • Index Logical Reads
  • Index Logical Reads per Minute
  • Total Physical Reads
  • Total Physical Reads per Minute
  • Data Physical Reads
  • Data Physical Reads per Minute
  • Index Physical Reads
  • Index Physical Reads per Minute
  • Data Page Hit Ratio
  • Index Page Hit Ratio
  • Pool Physical Read Time
  • Pool Physical Read Time per Minute
  • Pool Physical Write Time
  • Pool Physical Write Time per Minute
DB2 JDBC 9.x Buffer Pool Metrics
  • Availability
  • Total Logical Reads
  • Total Logical Reads per Minute
  • Data Logical Reads
  • Data Logical Reads per Minute
  • Index Logical Reads
  • Index Logical Reads per Minute
  • Total Physical Reads
  • Total Physical Reads per Minute
  • Data Physical Reads
  • Data Physical Reads per Minute
  • Index Physical Reads
  • Index Physical Reads per Minute
  • Data Page Hit Ratio
  • Index Page Hit Ratio
DB2 JDBC 9.x Table Space Metrics
  • Availability
  • Utilization
  • Page
  • Prefetch
  • Extent
  • Total
  • Free
  • Usable
  • Used
  • Number Containers
  • Total Logical Reads
  • Total Logical Reads per Minute
  • Data Logical Reads
  • Data Logical Reads per Minute
  • Index Logical Reads
  • Index Logical Reads per Minute
  • Total Physical Reads
  • Total Physical Reads per Minute
  • Data Physical Reads
  • Data Physical Reads per Minute
  • Index Physical Reads
  • Index Physical Reads per Minute
  • Data Page Hit Ratio
  • Index Page Hit Ratio
  • Current size
  • Total Pages
  • Used Pages
  • Total Pages in Container
  • Usable Pages in Container
  • Accessibility of Container
  • Total Size of a File System
  • Space Used on a File System
DB2 JDBC 9.x Table Metrics
  • Availability
  • Total
  • Data
  • Dictionary
  • Index
  • LOB Obejcts
  • Long Objetcs
  • XML
  • Rows Read
  • Rows Read per Minute
  • Rows Written
  • Rows Written per Minute
  • Accesses to Overflowed Records
  • Accesses to Overflowed Records per Minute
  • Page Reorganizations
  • Page Reorganizations per Minute
  • Data Object Pages
  • Index Object Pages
  • LOB Object Pages
  • LONG Object Pages
  • XDA Object Pages
DB2 JDBC 9.x Memory Pool Metrics
  • Availability
  • Configured Size
  • Current Size
  • Used Size
  • Watermark
  • Used Watermark
DB2 JDBC Database Manager 9.x Server Metrics
  • Availability
  • Total Sort Heap Allocated
  • Post Threshold Sorts
  • Post Threshold Sorts per Minute
  • Piped Sorts Requested
  • Piped Sorts Requested per Minute
  • Piped Sorts Accepted
  • Piped Sorts Accepted per Minute
  • Remote Connections
  • Remote Connections Executing
  • Local Connections
  • Local Connections Executing
  • Local Databases with Current Connects
  • Agents Registered
  • Agents Waiting for a Token
  • Maximum Number of Agents Registered
  • Maximum Number of Agents Waiting
  • Committed Private Memory
  • Number of Idle Agents
  • Agents Assigned From Pool
  • Agents Created Due to Empty Agent Pool
  • Agents Created Due to Empty Agent Pool per Minute
  • Maximum Number of Coordinating Agents
  • Maximum Agent Overflows
  • Stolen Agents
  • Total Number of Attempted Connections
  • Total Number of Attempted Connections per Minute
  • Current Number of Connections
  • Connections Waiting for the Host to Reply
  • Connections Waiting for the Client
  • Hash Join Threshold
  • Hash Join Threshold per Minute
  • Connection Switches
  • Connection Switches per Minute
  • Number of Nodes in Partition
  • ort Private Heap High Water Mark