DB2 9.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:
Labels
(None)