| 监控项类型 | 应用集 | 监控项说明 | 监控项 |
LLD
| DB_DB2 Performance | 当前数据库agent等待数 | Waiting agents on Instance:{#INSTNAME} DBName:{#DBNAME} |
| 当前数据库提交确认数 | Commits on Instance:{#INSTNAME} DBName:{#DBNAME} |
| 当前数据库连接数 | Database connections on Instance:{#INSTNAME} DBName:{#DBNAME} |
| 当前数据库状态 | Database status on Instance:{#INSTNAME} DBName:{#DBNAME} |
| 当前数据库死锁数 | Deadlocks on on Instance:{#INSTNAME} DBName:{#DBNAME} |
| 当前数据库delete语句数 | Deleted rows on Instance:{#INSTNAME} DBName:{#DBNAME} |
| 当前数据库动态sql数 | Dynamic sqls on Instance:{#INSTNAME} DBName:{#DBNAME} |
| 当前数据库insert语句数 | Inserted rows on Instance:{#INSTNAME} DBName:{#DBNAME} |
| 当前数据库实例连接数 | Instance connections on Instance:{#INSTNAME} DBName:{#DBNAME} |
| 数据库实例消耗内存大小 | Instance used memory on Instance:{#INSTNAME} DBName:{#DBNAME} |
| 数据库最近一次备份时间 | Last backup time on Instance:{#INSTNAME} DBName:{#DBNAME} |
| 数据库锁timeout时间 | Time of Lock time out on Instance:{#INSTNAME} DBName:{#DBNAME} |
| 当前数据库回滚事务数 | Rollbacks on Instance:{#INSTNAME} DBName:{#DBNAME} |
| 当前数据库select语句数 | Selected rows on Instance:{#INSTNAME} DBName:{#DBNAME} |
| 当前数据库静态sql数 | Static sqls on Instance:{#INSTNAME} DBName:{#DBNAME} |
| 当前数据库update语句数 | Updated rows on Instance:{#INSTNAME} DBName:{#DBNAME} |
| DB_DB2 Bufferpool | 缓冲池命中率（每个BP） | Total hit ratio of BP:{#BPNAME} on Instance:{#INSTNAME} DBName:{#DBNAME} |
| 数据命中率 | Overall bufferpool data hit ratio on Instance:{#INSTNAME} DBName:{#DBNAME} |
| 索引命中率 | Overall bufferpool index hit ratio on Instance:{#INSTNAME} DBName:{#DBNAME} |
| 读响应时间 | Bufferpool calulated read time on Instance:{#INSTNAME} DBName:{#DBNAME} |
| 写响应时间 | Bufferpool calulated write time on Instance:{#INSTNAME} DBName:{#DBNAME} |
| 数据读请求数 | Bufferpool data P reads on Instance:{#INSTNAME} DBName:{#DBNAME} |
| 数据写请求数 | Bufferpool data writes on Instance:{#INSTNAME} DBName:{#DBNAME} |
| 索引读请求数 | Bufferpool index P reads on Instance:{#INSTNAME} DBName:{#DBNAME} |
| 索引写请求数 | Bufferpool index writes on Instance:{#INSTNAME} DBName:{#DBNAME} |
| 读响应时间（原始） | Bufferpool read time on Instance:{#INSTNAME} DBName:{#DBNAME} |
| 临时数据读请求数 | Bufferpool temp data P reads on Instance:{#INSTNAME} DBName:{#DBNAME} |
| 临时索引读请求数 | Bufferpool temp index P reads on Instance:{#INSTNAME} DBName:{#DBNAME} |
| 写响应时间（原始） | Bufferpool write time on Instance:{#INSTNAME} DBName:{#DBNAME} |
| 缓存池时间信息 | Bufferpool time info on Instance:{#INSTNAME} DBName:{#DBNAME} |
| DB_DB2 Lock | 锁升级 | Number of lock escalations on Instance:{#INSTNAME} DBName:{#DBNAME} |
| 锁内存使用率 | Percent of lock list in use on Instance:{#INSTNAME} DBName:{#DBNAME} |
| 锁等待比率 | Percent of app lock waiting on Instance:{#INSTNAME} DBName:{#DBNAME} |
| DB_DB2 Log | 日志使用率 | Percent of used log on Instance:{#INSTNAME} DBName:{#DBNAME} |
| DB_DB2 Object | 非正常包数 | Number of Invalid Packages on on Instance:{#INSTNAME} DBName:{#DBNAME} |
| 非正常触发器数 | Number of Invalid Triggers on on Instance:{#INSTNAME} DBName:{#DBNAME} |
| DB_DB2 TableSpace | 表空间剩余大小 | TBSPNAME:{#TBSPNAME} Free size on Instance:{#INSTNAME} DBName:{#DBNAME} |
| 表空间使用率 | TBSPNAME:{#TBSPNAME} Utilization on Instance:{#INSTNAME} DBName:{#DBNAME} |
| 表空间总大小 | TBSPNAME:{#TBSPNAME} Total size on Instance:{#INSTNAME} DBName:{#DBNAME} |
| 表空间已使用大小 | TBSPNAME:{#TBSPNAME} Used size on Instance:{#INSTNAME} DBName:{#DBNAME} |
