跳转至

DB2

·

采集 IBM Db2 的性能指标。

已测试的版本：

  • 11.5.0.0a

配置

前置条件

# MD5: `A03356C83E20E74E06A3CC679424A47D`
wget https://static.guance.com/otn_software/db2/linuxx64_odbc_cli.tar.gz
  • 将下载好的 DB2 ODBC/CLI driver 解压，推荐路径：/opt/ibm/clidriver
[root@Linux /opt/ibm/clidriver]# ls
.
├── bin
├── bnd
├── cfg
├── cfgcache
├── conv
├── db2dump
├── include
├── lib
├── license
├── msg
├── properties
└── security64

然后将路径 /opt/ibm/clidriver/lib 填入 DataKit 的 IBM Db2 配置文件中的 LD_LIBRARY_PATH 环境变量中。

  • 对于部分系统可能还需要安装额外的依赖库：
# Ubuntu/Debian
apt-get install -y libxml2

# CentOS
yum install -y libxml2
  • 以管理员权限进入 db2 命令行模式执行以下命令开启监控功能：
update dbm cfg using HEALTH_MON on
update dbm cfg using DFT_MON_STMT on
update dbm cfg using DFT_MON_LOCK on
update dbm cfg using DFT_MON_TABLE on
update dbm cfg using DFT_MON_BUFPOOL on

以上语句开启了以下监控： Statement, Lock, Tables, Buffer pool。可以通过 get dbm cfg 命令查看开启的监控状态：

 Default database monitor switches
   Buffer pool                         (DFT_MON_BUFPOOL) = ON
   Lock                                   (DFT_MON_LOCK) = ON
   Sort                                   (DFT_MON_SORT) = OFF
   Statement                              (DFT_MON_STMT) = ON
   Table                                 (DFT_MON_TABLE) = ON
   Timestamp                         (DFT_MON_TIMESTAMP) = ON
   Unit of work                            (DFT_MON_UOW) = OFF
 Monitor health of instance and databases   (HEALTH_MON) = ON

采集器配置

进入 DataKit 安装目录下的 conf.d/samples 目录，复制 db2.conf.sample 并命名为 db2.conf。示例如下：

[[inputs.external]]
  daemon = true
  name   = 'db2'
  cmd    = "/usr/local/datakit/externals/db2"

  ## Set true to enable election
  election = true

  ## The "--inputs" line below should not be modified.
  args = [
    '--interval'       , '1m'                        ,
    '--host'           , '<db2-host>'                ,
    '--port'           , '50000'                     ,
    '--username'       , 'db2inst1'                  ,
    '--password'       , '<db2-password>'            ,
    '--database'       , '<db2-database-name>'       ,
    '--service-name'   , '<db2-service-name>'        ,
  ]
  envs = [
    'LD_LIBRARY_PATH=/opt/ibm/clidriver/lib:$LD_LIBRARY_PATH',
  ]

  [inputs.external.tags]
    # some_tag = "some_value"
    # more_tag = "some_other_value"

  #############################
  # Parameter Description (Marked with * is mandatory field)
  #############################
  # *--interval       : Collect interval (Default is 1m)
  # *--host           : IBM Db2 nstance address (IP)
  # *--port           : IBM Db2 listen port (Default is 50000)
  # *--username       : IBM Db2 username (Default is db2inst1)
  # *--password       : IBM Db2 password
  # *--database       : IBM Db2 database name
  #  --service-name   : IBM Db2 service name

配置好后，重启 DataKit 即可。

目前可以通过 ConfigMap 方式注入采集器配置来开启采集器。

指标

以下所有数据采集，默认会追加全局选举 tag，也可以在配置中通过 [inputs.db2.tags] 指定其它标签：

  [inputs.db2.tags]
    # some_tag = "some_value"
    # more_tag = "some_other_value"
    # ...

db2_instance

Tags & Fields Description
db2_server
(tag)		 Server addr.
db2_service
(tag)		 Server service.
host
(tag)		 Host name.
connection_active The current number of connections.
Type: int | (gauge)
Unit: count

db2_database

Tags & Fields Description
db2_server
(tag)		 Server addr.
db2_service
(tag)		 Server service.
host
(tag)		 Host name.
application_active The number of applications that are currently connected to the database.
Type: int | (gauge)
Unit: count
application_executing The number of applications for which the database manager is currently processing a request.
Type: int | (gauge)
Unit: count
backup_latest The time elapsed since the latest database backup was completed.
Type: float | (gauge)
Unit: timeStamp,sec
connection_max The highest number of simultaneous connections to the database since the database was activated.
Type: int | (gauge)
Unit: count
connection_total The total number of connections to the database since the first connect, activate, or last reset (coordinator agents).
Type: int | (count)
Unit: count
lock_active The number of locks currently held.
Type: int | (gauge)
Unit: count
lock_dead The total number of deadlocks that have occurred.
Type: int | (count)
Unit: count
lock_pages The memory pages (4 KiB each) currently in use by the lock list.
Type: int | (gauge)
Unit: count
lock_timeouts The number of times that a request to lock an object timed out instead of being granted.
Type: int | (count)
Unit: count
lock_wait The average wait time for a lock.
Type: float | (gauge)
Unit: timeStamp,sec
lock_waiting The number of agents waiting on a lock.
Type: int | (gauge)
Unit: count
row_modified_total The total number of rows inserted, updated, or deleted.
Type: int | (count)
Unit: count
row_reads_total The total number of rows that had to be read in order to return result sets.
Type: int | (count)
Unit: count
row_returned_total The total number of rows that have been selected by and returned to applications.
Type: int | (count)
Unit: count
status Database status.
0: OK (ACTIVE, ACTIVE_STANDBY, STANDBY)
1: WARNING (QUIESCE_PEND, ROLLFWD)
2: CRITICAL (QUIESCED)
3: UNKNOWN
Type: int | (gauge)
Unit: -

db2_buffer_pool

Tags & Fields Description
bp_name
(tag)		 Buffer pool name.
db2_server
(tag)		 Server addr.
db2_service
(tag)		 Server service.
host
(tag)		 Host name.
bufferpool_column_hit_percent The percentage of time that the database manager did not need to load a page from disk to service a column-organized table data page request.
Type: float | (gauge)
Unit: percent,percent
bufferpool_column_reads_logical The number of column-organized table data pages read from the logical table space containers for temporary, regular, and large table spaces.
Type: int | (count)
Unit: count
bufferpool_column_reads_physical The number of column-organized table data pages read from the physical table space containers for temporary, regular, and large table spaces.
Type: int | (count)
Unit: count
bufferpool_column_reads_total The total number of column-organized table data pages read from the table space containers for temporary, regular, and large table spaces.
Type: int | (count)
Unit: count
bufferpool_data_hit_percent The percentage of time that the database manager did not need to load a page from disk to service a data page request.
Type: float | (gauge)
Unit: percent,percent
bufferpool_data_reads_logical The number of data pages read from the logical table space containers for temporary, regular and large table spaces.
Type: int | (count)
Unit: count
bufferpool_data_reads_physical The number of data pages read from the physical table space containers for temporary, regular and large table spaces.
Type: int | (count)
Unit: count
bufferpool_data_reads_total The total number of data pages read from the table space containers for temporary, regular and large table spaces.
Type: int | (count)
Unit: count
bufferpool_hit_percent The percentage of time that the database manager did not need to load a page from disk to service a page request.
Type: float | (gauge)
Unit: percent,percent
bufferpool_index_hit_percent The percentage of time that the database manager did not need to load a page from disk to service an index page request.
Type: float | (gauge)
Unit: percent,percent
bufferpool_index_reads_logical The number of index pages read from the logical table space containers for temporary, regular and large table spaces.
Type: int | (count)
Unit: count
bufferpool_index_reads_physical The number of index pages read from the physical table space containers for temporary, regular and large table spaces.
Type: int | (count)
Unit: count
bufferpool_index_reads_total The total number of index pages read from the table space containers for temporary, regular and large table spaces.
Type: int | (count)
Unit: count
bufferpool_reads_logical The number of pages read from the logical table space containers for temporary, regular and large table spaces.
Type: int | (count)
Unit: count
bufferpool_reads_physical The number of pages read from the physical table space containers for temporary, regular and large table spaces.
Type: int | (count)
Unit: count
bufferpool_reads_total The total number of pages read from the table space containers for temporary, regular and large table spaces.
Type: int | (count)
Unit: count
bufferpool_xda_hit_percent The percentage of time that the database manager did not need to load a page from disk to service an index page request.
Type: float | (gauge)
Unit: percent,percent
bufferpool_xda_reads_logical The number of data pages for XML storage objects (XDAs) read from the logical table space containers for temporary, regular and large table spaces.
Type: int | (count)
Unit: count
bufferpool_xda_reads_physical The number of data pages for XML storage objects (XDAs) read from the physical table space containers for temporary, regular and large table spaces.
Type: int | (count)
Unit: count
bufferpool_xda_reads_total The total number of data pages for XML storage objects (XDAs) read from the table space containers for temporary, regular and large table spaces.
Type: int | (count)
Unit: count

db2_table_space

Tags & Fields Description
db2_server
(tag)		 Server addr.
db2_service
(tag)		 Server service.
host
(tag)		 Host name.
tablespace_name
(tag)		 Tablespace name.
tablespace_size The total size of the table space in bytes.
Type: int | (gauge)
Unit: count
tablespace_usable The total usable size of the table space in bytes.
Type: int | (gauge)
Unit: count
tablespace_used The total used size of the table space in bytes.
Type: int | (gauge)
Unit: count
tablespace_utilized The utilization of the table space as a percentage.
Type: float | (gauge)
Unit: percent,percent

db2_transaction_log

Tags & Fields Description
db2_server
(tag)		 Server addr.
db2_service
(tag)		 Server service.
host
(tag)		 Host name.
log_available The disk blocks (4 KiB each) of active log space in the database that is not being used by uncommitted transactions.
Type: int | (gauge)
Unit: count
log_reads The number of log pages read from disk by the logger.
Type: int | (count)
Unit: count
log_used The disk blocks (4 KiB each) of active log space currently used in the database.
Type: float | (gauge)
Unit: percent,percent
log_utilized The utilization of active log space as a percentage.
Type: float | (gauge)
Unit: percent,percent
log_writes The number of log pages written to disk by the logger.
Type: int | (count)
Unit: count

FAQ

如何查看 IBM Db2 采集器的运行日志？

由于 IBM Db2 采集器是外部采集器，程序名称为 db2，其日志是单独存放在 [DataKit 安装目录]/externals/db2.log 中。

配置好 IBM DB2 采集之后，为何 monitor 中无数据显示？

大概原因有如下几种可能：

  • IBM Db2 动态库依赖有问题

即使你本机当前可能已经有对应的 IBM Db2 包，仍然建议使用上面文档中指定的依赖包且确保其安装路径跟 LD_LIBRARY_PATH 所指定的路径一致。

  • glibc 版本有问题

由于 IBM Db2 采集器是独立编译的，且开启了 CGO，故其运行时需要 glibc 的依赖在 Linux 上可通过如下命令检查当前机器的 glibc 依赖是否有问题：

$ ldd <DataKit 安装目录>/externals/db2
    linux-vdso.so.1 (0x00007ffed33f9000)
    libdl.so.2 => /lib/x86_64-linux-gnu/libdl.so.2 (0x00007f70144e1000)
    libpthread.so.0 => /lib/x86_64-linux-gnu/libpthread.so.0 (0x00007f70144be000)
    libc.so.6 => /lib/x86_64-linux-gnu/libc.so.6 (0x00007f70142cc000)
    /lib64/ld-linux-x86-64.so.2 (0x00007f70144fc000)

如果有报告如下信息，则基本是当前机器上的 glibc 版本较低导致：

externals/db2: /lib64/libc.so.6: version  `GLIBC_2.14` not found (required by externals/db2)
  • IBM Db2 采集器只能在 Linux/AMD64 架构的 DataKit 使用，其它平台均不支持

这意味着 IBM Db2 这个采集器只能在 AMD64 的 Linux 上运行，其它平台一律无法运行当前的 IBM Db2 采集器。

文档评价

文档内容是否对您有帮助？ ×