DB2数据库监控项

[复制链接]
lewei 发表于 2020-7-31 16:34:55 | 显示全部楼层 |阅读模式 打印 上一主题 下一主题
监控项类型应用集监控项说明监控项
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}

回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

关注0

粉丝0

帖子110

发布主题
最新发布

乐维社区

微信公众号

版权所有 © 2016-2021 九一乐维丨粤ICP备17007026号