网管监控软件Hyperic HQ对DB2数据库的监控和管理

webmaster 在 2012-11-15 17:59 提交

DB2是IBM的企业级数据库产品。 它支持多种操作系统，能够运行TB级数据库，具有最高的性能和可扩展性。

网管监控软件Hyperic使用DB2的本地客户端接口对数据库引擎的每个实例以及单独的表取得高度精确的测量。 这种功能是通过了DB2运行在所有平台上，包括AIX，Linux和Windows，并且允许你获得管理能力（以前仅仅是访问DBA工具）的解决方案，您可以用它来管理依赖于DB2的基础设施资源。

网管监控软件Hyperic的目的是为DB2用户在企业环境中提供管理功能，通常用在以数据库为中心，再加上数据库其他技术管理支持。

网管监控软件Hyperic具有功能强大的应用程序的概念，可以看到业务逻辑和表示层的同时，从数据库层的监测数据，来衡量反映在您的应用程序基础设施的各个层面的客户活动。

欲了解Hyperic HQ更多信息，请咨询北京铸锐数码科技 010-62139280。

网管软件Hyperic HQ自动发现您的硬件和DB2服务器 

开源网管软件Hyperic HQ 监控所有库存DB2的资源的每一个指标，日志文件和配置

网管工具Hyperic HQ  每个指标利用自动基线确定问题资源 

综合网管系统Hyperic HQ 控制DB2资源的命令，调度计划，或警报响应 

Hyperic HQ 对你的DB2环境中的任何测量，日志，或安全事件产生警报 

系统支持版本

DB2 7.x
DB2 8.x
DB2 9.x
JDBC 9.x
Linux
Solaris
HPUX
AIX
MacOSX
FreeBSD
OpenBSD
NetBSD
系统监控规格

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
Hyperic HQ