IBM DB2 Management Support
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.
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
IBM DB2 Supported Versions
DB2 7.x
DB2 8.x
DB2 9.x
IBM DB2 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
)
COMMUNITY
