{Denodo}Denodo Monitor ログをデータベースに保存する

Denodo

 

https://community.denodo.com/docs/html/browse/latest/jp/vdp/administration/monitoring_the_virtual_dataport_server/denodo_monitor/configuring_the_denodo_monitor#jdbc-logging-configuration

前提: 
Denodo Express(Windows版) インストール済み
MySQL8.0.31インストール、起動済み
MySQL Connector/J 入手済み ※ ダウンロード時、ドロップダウンよりPlatform Independentを選択する必要あり

 

 

-- 1. DBにテーブル作成


cd C:\Denodo\DenodoPlatform8.0\tools\monitor\denodo-monitor\sql

MySQLに接続して下記ファイルを実行

mysql_5_0_3_or_later.sql


-- 2. JDBC ドライバーの準備

「mysql-connector-j-8.0.32.jar」をC:\Denodo\DenodoPlatform8.0\tools\monitor\denodo-monitor\lib フォルダにコピー

 

-- 3. DB出力設定

cd C:\Denodo\DenodoPlatform8.0\tools\monitor
notepad .\denodo-monitor\conf\ConfigurationParameters.properties

 

# Settings to store the output of the Virtual DataPort query monitor in a database
vdpqueries.jdbcagent.enable=true
vdpqueries.jdbcagent.driverClassName=com.mysql.jdbc.Driver
vdpqueries.jdbcagent.url=jdbc:mysql://localhost:3306/test
vdpqueries.jdbcagent.user=root
vdpqueries.jdbcagent.password=password
vdpqueries.jdbcagent.password.encrypted=false

 


# Settings to store the output of the Virtual DataPort cache monitor in a database
vdploadcacheprocesses.jdbcagent.enable=true
vdploadcacheprocesses.jdbcagent.driverClassName=com.mysql.jdbc.Driver
vdploadcacheprocesses.jdbcagent.url=jdbc:mysql://localhost:3306/test
vdploadcacheprocesses.jdbcagent.user=root
vdploadcacheprocesses.jdbcagent.password=password
vdploadcacheprocesses.jdbcagent.password.encrypted=false


# Settings to store the output of the Virtual DataPort query-blocks monitor in a database
vdpqueryblocks.jdbcagent.enable=true
vdpqueryblocks.jdbcagent.driverClassName=com.mysql.jdbc.Driver
vdpqueryblocks.jdbcagent.url=jdbc:mysql://localhost:3306/test
vdpqueryblocks.jdbcagent.user=root
vdpqueryblocks.jdbcagent.password=password
vdpqueryblocks.jdbcagent.password.encrypted=false

 

# Settings to store the output of the Virtual DataPort connections monitor in a database
vdpconnections.jdbcagent.enable=true
vdpconnections.jdbcagent.driverClassName=com.mysql.jdbc.Driver
vdpconnections.jdbcagent.url=jdbc:mysql://localhost:3306/test
vdpconnections.jdbcagent.user=root
vdpconnections.jdbcagent.password=password
vdpconnections.jdbcagent.password.encrypted=false

 


# Settings to store the output of the threads monitor in a database
threads.jdbcagent.enable=true
threads.jdbcagent.driverClassName=com.mysql.jdbc.Driver
threads.jdbcagent.url=jdbc:mysql://localhost:3306/test
threads.jdbcagent.user=root
threads.jdbcagent.password=password
threads.jdbcagent.password.encrypted=false

 

# Settings to store the output of the resources monitor in a database
resources.jdbcagent.enable=true
resources.jdbcagent.driverClassName=com.mysql.jdbc.Driver
resources.jdbcagent.url=jdbc:mysql://localhost:3306/test
resources.jdbcagent.user=root
resources.jdbcagent.password=password
resources.jdbcagent.password.encrypted=false


# To store the output of the Virtual DataPort datasources monitor in a database, do the following:
vdpdatasources.jdbcagent.enable=true
vdpdatasources.jdbcagent.driverClassName=com.mysql.jdbc.Driver
vdpdatasources.jdbcagent.url=jdbc:mysql://localhost:3306/test
vdpdatasources.jdbcagent.user=root
vdpdatasources.jdbcagent.password=password
vdpdatasources.jdbcagent.password.encrypted=false

 


.\denodo-monitor\bin\denodomonitor_shutdown.bat
.\denodo-monitor\bin\denodomonitor_startup.bat


-- 4. ログ出力確認

 


select * from cache_notification;
select * from connection_notification;
select * from datasource_polling;
select * from queryblock_notification;
select * from request_notification;
select * from resource_polling;
select * from thread_polling;

select * from monitor_configuration;