DB2 8.x Database service

DB2 8.x Database service

Log Track Supported: No
Config Track Supported: No
Custom Properties Supported: None
Supported Control Actions: None
Supported Metrics:

Name Alias Units Category Default On Default Interval
Availability Availability percentage AVAILABILITY true 10 min
Locks Held LocksHeld none UTILIZATION false 5 min
Lock Waits LockWaits none UTILIZATION false 5 min
Locks Wait Time LockWaitTime ms UTILIZATION false 10 min
Locks Wait Time per Minute LockWaitTime1m ms UTILIZATION false 10 min
Lock List in Use LockListInUse B UTILIZATION false 5 min
Lock Timeouts LockTimeouts none UTILIZATION false 10 min
Lock Timeouts per Minute LockTimeouts1m none UTILIZATION false 10 min
Deadlocks DeadLocks none UTILIZATION false 10 min
Deadlocks per Minute DeadLocks1m none UTILIZATION false 10 min
Sort Heap Allocated SortHeapAllocated B UTILIZATION false 5 min
Sorts Total TotalSorts none UTILIZATION false 10 min
Sorts Total per Minute TotalSorts1m none UTILIZATION false 10 min
Sorts Active ActiveSorts none UTILIZATION false 5 min
Sort Time Total TotalSortTime ms UTILIZATION false 10 min
Sort Time Total per Minute TotalSortTime1m ms UTILIZATION false 10 min
Sort Overflows SortOverflows none UTILIZATION false 10 min
Sort Overflows per Minute SortOverflows1m none UTILIZATION false 10 min
Buffer Pool Data Logical Reads PoolDataLReads none UTILIZATION false 10 min
Buffer Pool Data Logical Reads per Minute PoolDataLReads1m none UTILIZATION false 10 min
Buffer Pool Data Reads PoolDataPReads none UTILIZATION false 10 min
Buffer Pool Data Reads per Minute PoolDataPReads1m none UTILIZATION false 10 min
Buffer Pool Data Writes PoolDataWrites none UTILIZATION false 10 min
Buffer Pool Data Writes per Minute PoolDataWrites1m none UTILIZATION false 10 min
Buffer Pool Index Logical Reads PoolIndexLReads none UTILIZATION false 10 min
Buffer Pool Index Logical Reads per Minute PoolIndexLReads1m none UTILIZATION false 10 min
Buffer Pool Index Reads PoolIndexPReads none UTILIZATION false 10 min
Buffer Pool Index Reads per Minute PoolIndexPReads1m none UTILIZATION false 10 min
Buffer Pool Index Writes PoolIndexWrites none UTILIZATION false 10 min
Buffer Pool Index Writes per Minute PoolIndexWrites1m none UTILIZATION false 10 min
Buffer Pool Read Time PoolReadTime ms UTILIZATION false 10 min
Buffer Pool Read Time per Minute PoolReadTime1m ms UTILIZATION false 10 min
Buffer Pool Write Time PoolWriteTime ms UTILIZATION false 10 min
Buffer Pool Write Time per Minute PoolWriteTime1m ms UTILIZATION false 10 min
Files Closed FilesClosed ms UTILIZATION false 10 min
Files Closed per Minute FilesClosed1m ms UTILIZATION false 10 min
SQL Commit Statements CommitSqlStmts none UTILIZATION true 10 min
SQL Commit Statements per Minute CommitSqlStmts1m none UTILIZATION true 10 min
SQL Rollback Statements RollbackSqlStmts none UTILIZATION false 10 min
SQL Rollback Statements per Minute RollbackSqlStmts1m none UTILIZATION false 10 min
SQL Dynamic Statements DynamicSqlStmts none UTILIZATION false 10 min
SQL Dynamic Statements per Minute DynamicSqlStmts1m none UTILIZATION false 10 min
SQL Static Statements StaticSqlStmts none UTILIZATION false 10 min
SQL Static Statements per Minute StaticSqlStmts1m none UTILIZATION false 10 min
SQL Failed Statements FailedSqlStmts none UTILIZATION false 10 min
SQL Failed Statements per Minute FailedSqlStmts1m none UTILIZATION false 10 min
SQL Select Statements SelectSqlStmts none UTILIZATION false 10 min
SQL Select Statements per Minute SelectSqlStmts1m none UTILIZATION false 10 min
SQL DDL Statements DdlSqlStmts none UTILIZATION false 10 min
SQL DDL Statements per Minute DdlSqlStmts1m none UTILIZATION false 10 min
SQL Update/Insert/Delete Statements UidSqlStmts none UTILIZATION false 10 min
SQL Update/Insert/Delete Statements per Minute UidSqlStmts1m none UTILIZATION false 10 min
Rows Deleted RowsDeleted none UTILIZATION false 10 min
Rows Deleted per Minute RowsDeleted1m none UTILIZATION false 10 min
Rows Inserted RowsInserted none UTILIZATION false 10 min
Rows Inserted per Minute RowsInserted1m none UTILIZATION false 10 min
Rows Updated RowsUpdated none UTILIZATION false 10 min
Rows Updated per Minute RowsUpdated1m none UTILIZATION false 10 min
Rows Selected RowsSelected none UTILIZATION false 10 min
Rows Selected per Minute RowsSelected1m none UTILIZATION false 10 min
Buffer Pool Data Async Reads PoolAsyncDataReads none UTILIZATION false 10 min
Buffer Pool Data Async Reads per Minute PoolAsyncDataReads1m none UTILIZATION false 10 min
Buffer Pool Data Async Writes PoolAsyncDataWrites none UTILIZATION false 10 min
Buffer Pool Data Async Writes per Minute PoolAsyncDataWrites1m none UTILIZATION false 10 min
Buffer Pool Index Async Writes PoolAsyncIndexWrites none UTILIZATION false 10 min
Buffer Pool Index Async Writes per Minute PoolAsyncIndexWrites1m none UTILIZATION false 10 min
Buffer Pool Async Read Time PoolAsyncReadTime ms UTILIZATION false 10 min
Buffer Pool Async Read Time per Minute PoolAsyncReadTime1m ms UTILIZATION false 10 min
Buffer Pool Async Write Time PoolAsyncWriteTime ms UTILIZATION false 10 min
Buffer Pool Async Write Time per Minute PoolAsyncWriteTime1m ms UTILIZATION false 10 min
Direct Writes DirectWrites none UTILIZATION false 10 min
Direct Writes per Minute DirectWrites1m none UTILIZATION false 10 min
Direct Read Reqs DirectReadReqs none UTILIZATION false 10 min
Direct Read Reqs per Minute DirectReadReqs1m none UTILIZATION false 10 min
Direct Write Reqs DirectWriteReqs none UTILIZATION false 10 min
Direct Write Reqs per Minute DirectWriteReqs1m none UTILIZATION false 10 min
Direct Read Time DirectReadTime ms UTILIZATION false 10 min
Direct Read Time per Minute DirectReadTime1m ms UTILIZATION false 10 min
Direct Write Time DirectWriteTime ms UTILIZATION false 10 min
Direct Write Time per Minute DirectWriteTime1m ms UTILIZATION false 10 min
First Connect Time FirstConnTime epoch-seconds PERFORMANCE false 30 min
Total Connects TotalCons none THROUGHPUT true 10 min
Total Connects per Minute TotalCons1m none THROUGHPUT true 10 min
Log Space Allocated TotLogUsedTop B UTILIZATION false 10 min
Log Space Allocated per Minute TotLogUsedTop1m B UTILIZATION false 10 min
Log Writes LogWrites none UTILIZATION false 10 min
Log Writes per Minute LogWrites1m none UTILIZATION false 10 min
Log Reads LogReads none UTILIZATION false 10 min
Log Reads per Minute LogReads1m none UTILIZATION false 10 min
Package Cache Lookups PkgCacheLookups none UTILIZATION false 10 min
Package Cache Lookups per Minute PkgCacheLookups1m none UTILIZATION false 10 min
Package Cache Inserts PkgCacheInserts none UTILIZATION false 10 min
Package Cache Inserts per Minute PkgCacheInserts1m none UTILIZATION false 10 min
Catalog Cache Inserts CatCacheInserts none UTILIZATION false 10 min
Catalog Cache Inserts per Minute CatCacheInserts1m none UTILIZATION false 10 min
Catalog Cache Lookups CatCacheLookups none UTILIZATION false 10 min
Catalog Cache Lookups per Minute CatCacheLookups1m none UTILIZATION false 10 min
Catalog Cache Overflows CatCacheOverflows none UTILIZATION false 10 min
Catalog Cache Overflows per Minute CatCacheOverflows1m none UTILIZATION false 10 min
Catalog Cache Heap Full CatCacheHeapFull none UTILIZATION false 10 min
Catalog Cache Heap Full per Minute CatCacheHeapFull1m none UTILIZATION false 10 min
Hash Joins Total TotalHashJoins none UTILIZATION false 10 min
Hash Joins Total per Minute TotalHashJoins1m none UTILIZATION false 10 min
Hash Loops Total TotalHashLoops none UTILIZATION false 10 min
Hash Loops Total per Minute TotalHashLoops1m none UTILIZATION false 10 min
Hash Join Overflows HashJoinOverflows none UTILIZATION false 10 min
Hash Join Overflows per Minute HashJoinOverflows1m none UTILIZATION false 10 min
Hash Join Small Overflows HashJoinSmallOverflows none UTILIZATION false 10 min
Hash Join Small Overflows per Minute HashJoinSmallOverflows1m none UTILIZATION false 10 min

Configuration help:


Browse Space

- Pages
- News
- Labels
- Attachments
- Bookmarks
- Mail
- Advanced
- Activity

Explore Confluence

- Popular Labels
- Notation Guide

Your Account

Log In

or Sign Up  

Other Features

Add Content

Powered by Atlassian Confluence 2.8.1, the Enterprise Wiki.
Bug/feature request - Contact administrators

System Monitoring Software
SourceForge.net Logo