This is an automated email from the ASF dual-hosted git repository.
gongchao pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/hertzbeat.git
The following commit(s) were added to refs/heads/master by this push:
new 6473546f56 [feat] Add DB2 database monitoring support (#3857)
6473546f56 is described below
commit 6473546f566db87d968f65c9d874cb01637d7d5c
Author: starryCoder <[email protected]>
AuthorDate: Thu Nov 20 22:16:52 2025 +0800
[feat] Add DB2 database monitoring support (#3857)
Co-authored-by: Tomsun28 <[email protected]>
Co-authored-by: Calvin <[email protected]>
Co-authored-by: Duansg <[email protected]>
---
.../hertzbeat-collector-basic/pom.xml | 7 +-
.../collect/database/JdbcCommonCollect.java | 10 +
.../src/main/resources/define/app-db2.yml | 381 +++++++++++++++++++++
home/docs/help/db2.md | 80 +++++
.../current/help/db2.md | 79 +++++
home/sidebars.json | 3 +-
6 files changed, 558 insertions(+), 2 deletions(-)
diff --git a/hertzbeat-collector/hertzbeat-collector-basic/pom.xml
b/hertzbeat-collector/hertzbeat-collector-basic/pom.xml
index e418cde5aa..549c6f08b6 100644
--- a/hertzbeat-collector/hertzbeat-collector-basic/pom.xml
+++ b/hertzbeat-collector/hertzbeat-collector-basic/pom.xml
@@ -109,6 +109,12 @@
<artifactId>orai18n</artifactId>
<scope>provided</scope>
</dependency>
+ <!-- db2 -->
+ <dependency>
+ <groupId>com.ibm.db2</groupId>
+ <artifactId>jcc</artifactId>
+ <scope>provided</scope>
+ </dependency>
<!--redis-->
<dependency>
<groupId>io.lettuce</groupId>
@@ -152,7 +158,6 @@
</dependency>
-
<!--plc-->
<dependency>
<groupId>org.apache.plc4x</groupId>
diff --git
a/hertzbeat-collector/hertzbeat-collector-basic/src/main/java/org/apache/hertzbeat/collector/collect/database/JdbcCommonCollect.java
b/hertzbeat-collector/hertzbeat-collector-basic/src/main/java/org/apache/hertzbeat/collector/collect/database/JdbcCommonCollect.java
index 75b43e6ee0..5c4a6be6a0 100644
---
a/hertzbeat-collector/hertzbeat-collector-basic/src/main/java/org/apache/hertzbeat/collector/collect/database/JdbcCommonCollect.java
+++
b/hertzbeat-collector/hertzbeat-collector-basic/src/main/java/org/apache/hertzbeat/collector/collect/database/JdbcCommonCollect.java
@@ -172,6 +172,14 @@ public class JdbcCommonCollect extends AbstractCollect {
".*en\\s*([/\\\\]|\\\\n|/n|\\n)\\s*crypt.*",
".*ci\\s*([/\\\\]|\\\\n|/n|\\n)\\s*pher.*"
});
+
+ // DB2 bypass mode
+ PLATFORM_BYPASS_PATTERNS.put("db2", new String[]{
+ ".*security\\s*([/\\\\]|\\\\n|/n|\\n)\\s*mechanism.*",
+ ".*client\\s*([/\\\\]|\\\\n|/n|\\n)\\s*accounting.*",
+ ".*ssl\\s*([/\\\\]|\\\\n|/n|\\n)\\s*connection.*",
+
".*use\\s*([/\\\\]|\\\\n|/n|\\n)\\s*client\\s*([/\\\\]|\\\\n|/n|\\n)\\s*information.*"
+ });
}
private final GlobalConnectionCache connectionCommonCache =
GlobalConnectionCache.getInstance();
@@ -531,6 +539,8 @@ public class JdbcCommonCollect extends AbstractCollect {
case "oracle" -> "jdbc:oracle:thin:@" + host + ":" + port
+ "/" + (jdbcProtocol.getDatabase() == null ? "" :
jdbcProtocol.getDatabase());
case "dm" -> "jdbc:dm://" + host + ":" + port;
+ case "db2" -> "jdbc:db2://" + host + ":" + port
+ + "/" + (jdbcProtocol.getDatabase() == null ? "" :
jdbcProtocol.getDatabase());
case "testcontainers" -> "jdbc:tc:" + host + ":" + port
+ ":///" + (jdbcProtocol.getDatabase() == null ? "" :
jdbcProtocol.getDatabase()) + "?user=root&password=root";
default -> throw new IllegalArgumentException("Not support
database platform: " + jdbcProtocol.getPlatform());
diff --git a/hertzbeat-manager/src/main/resources/define/app-db2.yml
b/hertzbeat-manager/src/main/resources/define/app-db2.yml
new file mode 100644
index 0000000000..b40b81415a
--- /dev/null
+++ b/hertzbeat-manager/src/main/resources/define/app-db2.yml
@@ -0,0 +1,381 @@
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+
+# The monitoring type category：service-application service monitoring
db-database monitoring custom-custom monitoring os-operating system monitoring
+category: db
+# The monitoring type eg: linux windows tomcat mysql aws...
+app: db2
+# The monitoring i18n name
+name:
+ zh-CN: DB2数据库
+ en-US: DB2 DB
+ ja-JP: DB2 データベース
+# The description and help of this monitoring type
+help:
+ zh-CN: HertzBeat 使用 <a class='help_module_content'
href='https://hertzbeat.apache.org/docs/advanced/extend-jdbc'> JDBC 协议</a> 通过配置
SQL 对 DB2 数据库的通用性能指标(表空间、性能状态、用户连接、缓存、慢SQL等)进行采集监控。<br>您可以点击“<i>新建 DB2
数据库</i>”并进行配置，或者选择“<i>更多操作</i>”，导入已有配置。
+ en-US: HertzBeat uses <a class='help_module_content'
href='https://hertzbeat.apache.org/docs/advanced/extend-jdbc'> JDBC
Protocol</a> to configure SQL for collecting general metrics of DB2 database
(tablespace、user connect、performance、slow SQL etc.). <br>You can click "<i>New
DB2 Database</i>" and configure it, or select "<i>More Operations"</i> to
import the existing configuration.
+ zh-TW: HertzBeat 使用 <a class='help_module_content'
href='https://hertzbeat.apache.org/docs/advanced/extend-jdbc'> JDBC 協議</a> 通過配置
SQL 對 DB2 數據庫的通用性能指標(表空間、性能狀態、用戶連接、緩存、慢SQL等)進行采集監控。<br>您可以點擊“<i>新建 DB2
數據庫</i>”並進行配置，或者選擇“<i>更多操作</i>”，導入已有配置。
+ ja-JP: Hertzbeat は <a class='help_module_content'
href='https://hertzbeat.apache.org/docs/advanced/extend-jdbc'>
JDBCプロトコルを介して</a> DB2 データベースの一般的なパフォーマンスのメトリクスを監視します。<br>「<i>新規 DB2
データベース</i>」をクリックしてパラメタを設定した後、新規することができます。
+helpLink:
+ zh-CN: https://hertzbeat.apache.org/zh-cn/docs/help/db2/
+ en-US: https://hertzbeat.apache.org/docs/help/db2/
+# Input params define for monitoring(render web ui by the definition)
+params:
+ # field-param field key
+ - field: host
+ # name-param field display i18n name
+ name:
+ zh-CN: 目标Host
+ en-US: Target Host
+ ja-JP: 目標ホスト
+ # type-param field type(most mapping the html input type)
+ type: host
+ # required-true or false
+ required: true
+ # field-param field key
+ - field: port
+ # name-param field display i18n name
+ name:
+ zh-CN: 端口
+ en-US: Port
+ ja-JP: ポート
+ # type-param field type(most mapping the html input type)
+ type: number
+ # when type is number, range is required
+ range: '[0,65535]'
+ # required-true or false
+ required: true
+ # default value
+ defaultValue: 50000 # DB2 default port
+ - field: timeout
+ name:
+ zh-CN: 查询超时时间(ms)
+ en-US: Query Timeout(ms)
+ ja-JP: クエリタイムアウト（ｍｓ）
+ type: number
+ range: '[400,200000]'
+ required: false
+ hide: true
+ defaultValue: 6000
+ - field: reuseConnection
+ name:
+ zh-CN: 复用连接
+ en-US: Reuse Connection
+ ja-JP: 接続再利用
+ type: boolean
+ required: false
+ defaultValue: true
+ - field: database
+ name:
+ zh-CN: 数据库名
+ en-US: Database Name
+ ja-JP: データベース名
+ type: text
+ required: true # Database Name is typically mandatory for DB2 JDBC
connection
+ - field: username
+ name:
+ zh-CN: 用户名
+ en-US: Username
+ ja-JP: ユーザー名
+ type: text
+ limit: 50
+ required: false
+ - field: password
+ name:
+ zh-CN: 密码
+ en-US: Password
+ ja-JP: パスワード
+ type: password
+ required: false
+ - field: url
+ name:
+ zh-CN: URL
+ en-US: URL
+ ja-JP: URL
+ type: text
+ required: false
+ hide: true
+
+# collect metrics config list
+metrics:
+ # metrics - basic
+ - name: basic
+ i18n:
+ zh-CN: 基本信息
+ en-US: Basic Info
+ ja-JP: 基礎情報
+ priority: 0
+ fields:
+ - field: database_version
+ type: 1
+ label: true
+ i18n:
+ zh-CN: 数据库版本
+ en-US: Database Version
+ ja-JP: データベースバージョン
+ - field: instance_name
+ type: 1
+ i18n:
+ zh-CN: 实例名
+ en-US: Instance Name
+ ja-JP: インスタンス名
+ - field: status
+ type: 1
+ i18n:
+ zh-CN: 实例状态
+ en-US: Instance Status
+ ja-JP: インスタンス的状态
+ - field: num_db
+ type: 0
+ i18n:
+ zh-CN: 数据库数量
+ en-US: Number of Databases
+ ja-JP: データベースの数
+ aliasFields:
+ - INSTANCE_NAME
+ - INSTANCE_STATUS
+ - NUM_DB
+ - CURRENT_USER
+ calculates:
+ - database_version=INSTANCE_NAME
+ - instance_name=INSTANCE_NAME
+ - status=INSTANCE_STATUS
+ - num_db=NUM_DB
+ protocol: jdbc
+ jdbc:
+ host: ^_^host^_^
+ port: ^_^port^_^
+ platform: db2
+ username: ^_^username^_^
+ password: ^_^password^_^
+ database: ^_^database^_^
+ timeout: ^_^timeout^_^
+ reuseConnection: ^_^reuseConnection^_^
+ queryType: oneRow
+ sql: "SELECT CURRENT SERVER AS INSTANCE_NAME, 'ACTIVE' AS
INSTANCE_STATUS, 1 AS NUM_DB, CURRENT USER AS CURRENT_USER FROM
SYSIBM.SYSDUMMY1"
+ url: ^_^url^_^
+
+ # Combined tablespace capacity and usage
+ - name: tablespace_usage
+ i18n:
+ zh-CN: 表空间使用率
+ en-US: Tablespace Usage
+ ja-JP: 表領域使用率
+ priority: 1
+ fields:
+ - field: tablespace_name
+ type: 1
+ i18n:
+ zh-CN: 表空间名
+ en-US: Tablespace Name
+ ja-JP: 表領域名
+ label: true
+ - field: status
+ type: 1
+ i18n:
+ zh-CN: 类型
+ en-US: Type
+ ja-JP: タイプ
+ - field: total
+ type: 0
+ i18n:
+ zh-CN: 总容量
+ en-US: Total Size
+ ja-JP: 総容量
+ unit: MB
+ - field: used
+ type: 0
+ i18n:
+ zh-CN: 已使用
+ en-US: Used Size
+ ja-JP: 使用済み
+ unit: MB
+ - field: free
+ type: 0
+ i18n:
+ zh-CN: 空闲
+ en-US: Free Size
+ ja-JP: 利用可能
+ unit: MB
+ - field: used_percentage
+ type: 0
+ i18n:
+ zh-CN: 已用百分比
+ en-US: Used Percentage
+ ja-JP: 使用した比率
+ unit: '%'
+ aliasFields:
+ - TBSP_NAME
+ - TBSP_TYPE
+ - TBSP_TOTAL_SIZE_KB
+ - TBSP_USED_SIZE_KB
+ - TBSP_FREE_SIZE_KB
+ calculates:
+ - tablespace_name=TBSP_NAME
+ - status=TBSP_TYPE
+ - total=TBSP_TOTAL_SIZE_KB / 1024
+ - used=TBSP_USED_SIZE_KB / 1024
+ - free=TBSP_FREE_SIZE_KB / 1024
+ - used_percentage=TBSP_USED_SIZE_KB / TBSP_TOTAL_SIZE_KB * 100
+ protocol: jdbc
+ jdbc:
+ host: ^_^host^_^
+ port: ^_^port^_^
+ platform: db2
+ username: ^_^username^_^
+ password: ^_^password^_^
+ database: ^_^database^_^
+ timeout: ^_^timeout^_^
+ reuseConnection: ^_^reuseConnection^_^
+ queryType: multiRow
+ sql: "SELECT TBSP_NAME, TBSP_TYPE, TBSP_TOTAL_SIZE_KB,
TBSP_USED_SIZE_KB, TBSP_FREE_SIZE_KB FROM SYSIBMADM.TBSP_UTILIZATION"
+ url: ^_^url^_^
+
+ # Sessions/Applications status distribution
+ - name: sessions_status
+ i18n:
+ zh-CN: 会话状态
+ en-US: Session Status
+ ja-JP: セッション状態
+ priority: 2
+ fields:
+ - field: status_type
+ type: 1
+ i18n:
+ zh-CN: 状态类型
+ en-US: Status Type
+ ja-JP: 状態タイプ
+ label: true
+ - field: count
+ type: 0
+ i18n:
+ zh-CN: 数量
+ en-US: Count
+ ja-JP: 数
+ protocol: jdbc
+ jdbc:
+ host: ^_^host^_^
+ port: ^_^port^_^
+ platform: db2
+ username: ^_^username^_^
+ password: ^_^password^_^
+ database: ^_^database^_^
+ timeout: ^_^timeout^_^
+ reuseConnection: ^_^reuseConnection^_^
+ queryType: multiRow
+ sql: "SELECT APPL_STATUS AS STATUS_TYPE, COUNT(*) AS COUNT FROM
SYSIBMADM.APPLICATIONS GROUP BY APPL_STATUS"
+ url: ^_^url^_^
+
+
+ # Total number of applications/sessions
+ - name: process
+ i18n:
+ zh-CN: 应用进程数
+ en-US: Application Process Count
+ ja-JP: アプリケーションプロセス数
+ priority: 5
+ fields:
+ - field: process_count
+ type: 0
+ i18n:
+ zh-CN: 进程数
+ en-US: Process Count
+ ja-JP: プロセス数
+ protocol: jdbc
+ jdbc:
+ host: ^_^host^_^
+ port: ^_^port^_^
+ platform: db2
+ username: ^_^username^_^
+ password: ^_^password^_^
+ database: ^_^database^_^
+ timeout: ^_^timeout^_^
+ reuseConnection: ^_^reuseConnection^_^
+ queryType: oneRow
+ # Count of all running applications
+ sql: "select count(*) as process_count from SYSIBMADM.APPLICATIONS"
+ url: ^_^url^_^
+
+ - name: locks
+ i18n:
+ zh-CN: 锁
+ en-US: Locks
+ ja-JP: ロック
+ priority: 10
+ fields:
+ - field: waiting_locks
+ type: 0
+ i18n:
+ zh-CN: 当前等待锁数
+ en-US: Current Waiting Locks
+ ja-JP: 現在の待機中ロック数
+ aliasFields:
+ - WAITING_LOCKS
+ calculates:
+ - waiting_locks=WAITING_LOCKS
+ protocol: jdbc
+ jdbc:
+ host: ^_^host^_^
+ port: ^_^port^_^
+ platform: db2
+ username: ^_^username^_^
+ password: ^_^password^_^
+ database: ^_^database^_^
+ timeout: ^_^timeout^_^
+ reuseConnection: ^_^reuseConnection^_^
+ queryType: oneRow
+ sql: "SELECT COUNT(*) AS WAITING_LOCKS FROM SYSIBMADM.MON_LOCKWAITS"
+ url: ^_^url^_^
+
+ # Slow Query / Top Statements (by Total CPU Time)
+ - name: slow_query
+ i18n:
+ zh-CN: 慢查询
+ en-US: Slow Query
+ ja-JP: スロークエリ
+ priority: 14
+ fields:
+ - field: avg_exe_time
+ type: 0
+ i18n:
+ zh-CN: 平均执行时间
+ en-US: Avg Execution Time
+ ja-JP: 平均実行時間
+ unit: ms
+ - field: sql_text
+ type: 1
+ i18n:
+ zh-CN: SQL文本
+ en-US: SQL Text
+ ja-JP: SQLテキスト
+ aliasFields:
+ - AVG_EXE_TIME
+ - SQL_TEXT
+ calculates:
+ - avg_exe_time=AVG_EXE_TIME
+ - sql_text=SQL_TEXT
+ protocol: jdbc
+ jdbc:
+ host: ^_^host^_^
+ port: ^_^port^_^
+ platform: db2
+ username: ^_^username^_^
+ password: ^_^password^_^
+ database: ^_^database^_^
+ timeout: ^_^timeout^_^
+ reuseConnection: ^_^reuseConnection^_^
+ queryType: multiRow
+ sql: "select total_act_time/num_exec_with_metrics as AVG_EXE_TIME,
substr(stmt_text,1,4000) as SQL_TEXT from table(mon_get_pkg_cache_stmt(null,
null, null, -2)) as T where num_exec_with_metrics>=1 order by 1 desc fetch
first 100 rows only"
+ url: ^_^url^_^
\ No newline at end of file
diff --git a/home/docs/help/db2.md b/home/docs/help/db2.md
new file mode 100644
index 0000000000..5652094fa9
--- /dev/null
+++ b/home/docs/help/db2.md
@@ -0,0 +1,80 @@
+---
+id: db2
+title: Monitoring：DB2 database monitoring
+sidebar_label: DB2 Database
+keywords: [ open source monitoring tool, open source database monitoring tool,
monitoring DB2 database metrics ]
+---
+
+
+> Collect and monitor general performance metrics (tablespace, session status,
process count, locks, slow queries, etc.)
+> for DB2 databases.
+
+### Note: DB2 JDBC Driver JAR Must be Added
+
+- Download the DB2 JDBC driver JAR package, for
+ example,
[jcc.jar](https://repo1.maven.org/maven2/com/ibm/db2/jcc/11.5.9.0/jcc-11.5.9.0.jar).
+- Copy the JAR package to the `hertzbeat/ext-lib` directory.
+- Restart the HertzBeat service.
+
+### Configuration Parameters
+
+The following are the required configuration parameters for DB2 monitoring:
+
+| Parameter Name | Parameter Description
|
+|:---------------------|:---------------------------------------------------------------------------------------------------------------------------------------|
+| **Target Host** | The IPv4, IPv6, or domain name of the monitored DB2
database server.
|
+| **Port** | The port provided by the DB2 database, default is
`50000`.
|
+| **Database Name** | The name of the DB2 database to connect to.
|
+| **Username** | The username for the database connection.
|
+| **Password** | The password for the database connection.
|
+| **Query Timeout** | Sets the timeout for when an SQL query does not
return data, in milliseconds (ms), default is `6000`.
|
+| **Reuse Connection** | Whether to reuse the database connection, boolean
value, default is `true`.
|
+| **URL** | The database connection URL, optional. If configured,
it will override the database name, username, and password parameters set
above. |
+
+### Collected Metrics
+
+#### Metric Set: Basic Info
+
+| Metric Name | Metric Unit | Metric Description |
+|:-------------------|:------------|:------------------------|
+| `database_version` | None | Database Version. |
+| `instance_name` | None | Database Instance Name. |
+| `status` | None | Instance Status. |
+| `num_db` | None | Number of Databases. |
+
+#### Metric Set: Tablespace Usage
+
+| Metric Name | Metric Unit | Metric Description |
+|:------------------|:---------------|:-------------------|
+| `tablespace_name` | None | Tablespace Name. |
+| `status` | None | Type. |
+| `total` | MB | Total Size. |
+| `used` | MB | Used Size. |
+| `free` | MB | Free Size. |
+| `used_percentage` | Percentage (%) | Used Percentage. |
+
+#### Metric Set: Session Status
+
+| Metric Name | Metric Unit | Metric Description |
+|:--------------|:------------|:----------------------------------|
+| `status_type` | None | Session Status Type. |
+| `count` | None | Count of sessions in that status. |
+
+#### Metric Set: Application Process Count
+
+| Metric Name | Metric Unit | Metric Description
|
+|:----------------|:------------|:-----------------------------------------------------------------------------------|
+| `process_count` | None | Total number of application
processes/sessions. |
+
+#### Metric Set: Locks
+
+| Metric Name | Metric Unit | Metric Description |
+|:----------------|:------------|:-----------------------------------|
+| `waiting_locks` | None | Number of currently waiting locks. |
+
+#### Metric Set: Slow Query
+
+| Metric Name | Metric Unit | Metric Description |
+|:---------------|:------------|:----------------------------|
+| `avg_exe_time` | ms | Average Execution Time. |
+| `sql_text` | None | SQL Text of the slow query. |
diff --git a/home/i18n/zh-cn/docusaurus-plugin-content-docs/current/help/db2.md
b/home/i18n/zh-cn/docusaurus-plugin-content-docs/current/help/db2.md
new file mode 100644
index 0000000000..0c2f9bb7e3
--- /dev/null
+++ b/home/i18n/zh-cn/docusaurus-plugin-content-docs/current/help/db2.md
@@ -0,0 +1,79 @@
+---
+id: db2
+title: 监控：DB2数据库监控
+sidebar_label: DB2数据库
+keywords: [ 开源监控系统, 开源数据库监控, DB2数据库监控 ]
+---
+
+
+> 对 DB2 数据库的通用性能指标（表空间、会话状态、进程数、锁、慢查询等）进行采集监控
+
+### 注意, 必须添加 DB2 jdbc 驱动 jar
+
+- 下载 DB2 jdbc 驱动 jar
+ 包，例如
[jcc.jar](https://repo1.maven.org/maven2/com/ibm/db2/jcc/11.5.9.0/jcc-11.5.9.0.jar)
+- 将 jar 包复制到 `hertzbeat/ext-lib` 目录下
+- 重启 HertzBeat 服务
+
+### 配置参数
+
+以下是 DB2 监控所需的配置参数：
+
+| 参数名称 | 参数帮助描述 |
+|:-----------|:-----------------------------------------|
+| **目标Host** | 被监控的 DB2 数据库服务器的 IPv4、IPv6 或域名 |
+| **端口** | DB2 数据库对外提供的端口，默认为 `50000` |
+| **数据库名** | 要连接的 DB2 数据库的名称 |
+| **用户名** | 数据库连接用户名 |
+| **密码** | 数据库连接密码 |
+| **查询超时时间** | 设置 SQL 查询未响应数据时的超时时间，单位毫秒 (ms)，默认 `6000` |
+| **复用连接** | 是否复用数据库连接，布尔值，默认 `true` |
+| **URL** | 数据库连接 URL，可选，配置后将覆盖上面配置的数据库名、用户名、密码等参数 |
+
+### 采集指标
+
+#### 指标集合：基本信息
+
+| 指标名称 | 指标单位 | 指标帮助描述 |
+|:-------------------|:-----|:-------|
+| `database_version` | 无 | 数据库版本 |
+| `instance_name` | 无 | 数据库实例名 |
+| `status` | 无 | 实例状态 |
+| `num_db` | 无 | 数据库数量 |
+
+#### 指标集合：表空间使用率
+
+| 指标名称 | 指标单位 | 指标帮助描述 |
+|:------------------|:-------|:-------|
+| `tablespace_name` | 无 | 表空间名 |
+| `status` | 无 | 类型 |
+| `total` | MB | 总容量 |
+| `used` | MB | 已使用容量 |
+| `free` | MB | 空闲容量 |
+| `used_percentage` | 百分比(%) | 已用百分比 |
+
+#### 指标集合：会话状态
+
+| 指标名称 | 指标单位 | 指标帮助描述 |
+|:--------------|:-----|:-----------|
+| `status_type` | 无 | 会话状态类型 |
+| `count` | 无 | 处于该状态的会话数量 |
+
+#### 指标集合：应用进程数
+
+| 指标名称 | 指标单位 | 指标帮助描述 |
+|:----------------|:-----|:-------------|
+| `process_count` | 无 | 总的应用进程数/会话总数 |
+
+#### 指标集合：锁
+
+| 指标名称 | 指标单位 | 指标帮助描述 |
+|:----------------|:-----|:-------------|
+| `waiting_locks` | 无 | 当前处于等待状态的锁数量 |
+
+#### 指标集合：慢查询
+
+| 指标名称 | 指标单位 | 指标帮助描述 |
+|:---------------|:-----|:------------|
+| `avg_exe_time` | ms | 平均执行时间 |
+| `sql_text` | 无 | 慢查询的 SQL 文本 |
diff --git a/home/sidebars.json b/home/sidebars.json
index 174b58769c..f3bbd18cb9 100755
--- a/home/sidebars.json
+++ b/home/sidebars.json
@@ -174,7 +174,8 @@
"help/tidb",
"help/mongodb",
"help/mongodb_atlas",
- "help/oceanbase"
+ "help/oceanbase",
+ "help/db2"
]
},
{
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
