监视 Db2 on Cloud
深入了解 Db2 on Cloud 实例。 这些指标可帮助您找到瓶颈或预测可能的生产问题。
您可以使用 IBM Cloud® Monitoring 服务来监视 Db2 on Cloud 实例。 Db2 on Cloud 将有关实例的选定信息转发到 "监视" ,以便您可以监视特定度量,例如 cpu 和内存利用率。
有关平台度量的其他详细信息,请参阅 平台度量简介。
监视度量值当前仅可用于企业套餐和标准套餐。 当前不支持轻量套餐。
设置 Db2 on Cloud 服务实例
要为 Db2 on Cloud设置 "监视" ,必须创建服务实例,然后在要监视的 Db2 on Cloud 实例所在的区域中启用 "平台度量"。 如果在多个区域中具有部署,那么必须为每个区域供应 "监视" 并启用平台度量。
要设置 Monitoring,
- 从 IBM Cloud 导航菜单中,选择 可观察性。
- 选择 监视。
- 使用现有的 Monitoring 服务实例或创建新的服务实例。
- 在实例就绪后,通过单击 配置平台度量来启用平台度量。
- 选择区域,然后从该区域选择 Monitoring 实例。 如果在多个区域中具有部署,那么必须供应 Monitoring 并为每个区域启用平台度量。
访问 IBM Cloud Monitoring 度量
要在 Monitoring中查看 Db2 on Cloud 客户度量仪表板:
- 从 IBM Cloud 导航菜单中,选择 可观察性。
- 选择 监视。
- 选择 查看 IBM Cloud Monitoring 以打开仪表板。
有关更多信息,请参阅 Monitoring 入门教程。
按服务套餐提供的度量值
度量名称 |
---|
数据库可用性检查 |
数据库落实时间 |
数据库回滚 |
灾难恢复日志缺陷 |
高可用性灾难恢复日志缺陷 |
是否已连接灾难恢复? |
是否已配置灾难恢复? |
上次备份持续时间 (以分钟计) |
日志磁盘等待 |
唯一标识语句数 |
已删除的行数 |
更新的行数 |
插入的行数 |
自上次备份以来经过的时间 (以小时计) |
异常终止的活动总数 |
已完成的活动总数 |
已拒绝的活动总数 |
连接总数 |
落实总数 |
数据库可用性检查
元数据 | 描述 |
---|---|
Metric Name |
ibm_db2_db_availability_check |
Metric Type |
gauge |
Value Type |
none |
Segment By |
Service instance , Resource |
Metric Description |
The current status of the database. |
数据库落实时间
元数据 | 描述 |
---|---|
Metric Name |
ibm_db2_db_commits_time |
Metric Type |
counter |
Value Type |
none |
Segment By |
Service instance , Resource |
Metric Description |
Indicates the number of applications that are currently connected to the database. |
数据库回滚
元数据 | 描述 |
---|---|
Metric Name |
ibm_db2_db_rollbacks |
Metric Type |
counter |
Value Type |
none |
Segment By |
Service instance , Resource |
Metric Description |
Total number of rollback statements issued by the client application and total number of rollbacks initiated internally by the database manager. |
灾难恢复日志缺陷
元数据 | 描述 |
---|---|
Metric Name |
ibm_db2_dr_log_gap |
Metric Type |
gauge |
Value Type |
none |
Segment By |
Service instance , Resource |
Metric Description |
Disaster Recovery Log Gap. |
高可用性灾难恢复日志间隔
元数据 | 描述 |
---|---|
Metric Name |
ibm_db2_hadr_log_gap |
Metric Type |
gauge |
Value Type |
none |
Segment By |
Service instance , Resource |
Metric Description |
HADR Log Gap monitor element This element shows the recent average of the gap between the PRIMARY_LOG_POS value and STANDBY_LOG_POS value. The gap is measured in number ofbytes. |
灾难恢复是否已连接?
元数据 | 描述 |
---|---|
Metric Name |
ibm_db2_is_dr_connected |
Metric Type |
gauge |
Value Type |
none |
Segment By |
Service instance , Resource |
Metric Description |
Availability disaster recovery connection status of the database. |
是否已配置灾难恢复?
元数据 | 描述 |
---|---|
Metric Name |
ibm_db2_is_dr_configured |
Metric Type |
gauge |
Value Type |
none |
Segment By |
Service instance , Resource |
Metric Description |
Is this formation configured with DR. |
上次备份持续时间 (分钟)
元数据 | 描述 |
---|---|
Metric Name |
ibm_db2_last_backup_duration_minutes |
Metric Type |
gauge |
Value Type |
none |
Segment By |
Service instance , Resource |
Metric Description |
The duration of the last successful backup. |
日志磁盘等待时间
元数据 | 描述 |
---|---|
Metric Name |
ibm_db2_log_disk_wait |
Metric Type |
counter |
Value Type |
none |
Segment By |
Service instance , Resource |
Metric Description |
The number of times agents have to wait for log data to write to disk. |
唯一标识语句数
元数据 | 描述 |
---|---|
Metric Name |
ibm_db2_uid_stmts |
Metric Type |
counter |
Value Type |
none |
Segment By |
Service instance , Resource |
Metric Description |
The number of UPDATE, INSERT, MERGE and DELETE statements that were executed. |
已删除的行数
元数据 | 描述 |
---|---|
Metric Name |
ibm_db2_rows_deleted |
Metric Type |
counter |
Value Type |
none |
Segment By |
Service instance , Resource |
Metric Description |
Total of number of row deletions attempted and total number of rows deleted from the database as a result of internal activity. |
已更新的行数
元数据 | 描述 |
---|---|
Metric Name |
ibm_db2_rows_updated |
Metric Type |
counter |
Value Type |
none |
Segment By |
Service instance , Resource |
Metric Description |
Total number of row updates attempted and total number of rows updated from the database as a result of internal activity. |
插入的行数
元数据 | 描述 |
---|---|
Metric Name |
ibm_db2_rows_inserted |
Metric Type |
counter |
Value Type |
none |
Segment By |
Service instance , Resource |
Metric Description |
Total number of row insertions attempted and total number of rows inserted from the database as a result of internal activity. |
自上次备份以来的时间 (以小时计)
元数据 | 描述 |
---|---|
Metric Name |
ibm_db2_since_last_backup_hours |
Metric Type |
gauge |
Value Type |
none |
Segment By |
Service instance , Resource |
Metric Description |
The number of hours since there was a last successful backup. |
异常中止的活动总数
元数据 | 描述 |
---|---|
Metric Name |
ibm_db2_db_act_aborted |
Metric Type |
counter |
Value Type |
none |
Segment By |
Service instance , Resource |
Metric Description |
The total number of coordinator activities at any nesting level that completed with errors. |
已完成的活动总数
元数据 | 描述 |
---|---|
Metric Name |
ibm_db2_db_act_completed |
Metric Type |
counter |
Value Type |
none |
Segment By |
Service instance , Resource |
Metric Description |
The total number of coordinator activities at any nesting level that completed successfully. |
拒绝的活动总数
元数据 | 描述 |
---|---|
Metric Name |
ibm_db2_db_act_rejected |
Metric Type |
counter |
Value Type |
none |
Segment By |
Service instance , Resource |
Metric Description |
The total number of coordinator activities at any nesting level that were rejected instead of being allowed to execute. |
连接总数
元数据 | 描述 |
---|---|
Metric Name |
ibm_db2_total_conn |
Metric Type |
gauge |
Value Type |
none |
Segment By |
Service instance , Resource |
Metric Description |
Indicates the number of applications that are currently connected to the database. |
落实总次数
元数据 | 描述 |
---|---|
Metric Name |
ibm_db2_db_num_commits |
Metric Type |
counter |
Value Type |
none |
Segment By |
Service instance , Resource |
Metric Description |
Total number of commit statements issued by the client application and the total number of commits initiated internally by the database manager. |
分段的属性
全局属性
以下属性可用于对以上列出的所有度量进行分段
属性 | 属性名称 | 属性描述 |
---|---|---|
Cloud Type |
ibm_ctype |
云类型的值为 public , dedicated 或 local |
Location |
ibm_location |
受监视资源的位置-这可能是区域,数据中心或全局 |
Resource |
ibm_resource |
由服务度量的数据库成员资源 |
Scope |
ibm_scope |
作用域是与此度量值关联的帐户,组织或空间 GUID |
Service name |
ibm_service_name |
生成此度量的服务的名称 |
|
其他属性
以下属性可用于对上面参考内容中所述的一个或多个属性分段。 请查看各个度量值以了解分段选项。
属性 | 属性名称 | 属性描述 |
---|---|---|
Service instance |
ibm_service_instance |
服务实例段标识与度量值关联的实例 |