DB2 Monitoring

Prerequisites

• InfluxDB (the host is the same as Grafana)
• Separated Linux host
  • Install and running telegraf
  • Install DB2 Client
  • Implement custom scripts

InfluxDB

新增 database

> create database db2_mon with duration 180d
> create user mon with password 'thisispassword'
> grant read on db2_mon to mon

mon 唯讀帳號是給 Grafana 的 datasource 使用。

Telegraf

 

DB2 Client and custom scripts

 

 

Learning

Archive Log Monitor

• Generating Log Archive Activity Histograms