Configuring the Denodo Monitor¶
To start using the Denodo Monitor, follow these steps:
Go to the directory
<DENODO_HOME>/tools/monitor
.On Windows, uncompress the file
denodo-monitor.zip
.On Linux, execute this:
tar -xzf denodo-monitor.tar.gz
.Edit the file
conf/ConfigurationParameters.properties
to configure it.Although usually the default configuration of the Denodo Monitor is correct, you can find a description of the properties in this file right after this list of steps.
To start the Denodo Monitor go to bin, in the directory of the Denodo Monitor and do this:
On Linux, execute
./denodomonitor_startup.sh
.On Windows, execute
denodomonitor_startup.bat
.
Then, change the values of all the properties jmx.host
,
jmx.port
, jmx.user
and jmx.password
. Each monitor will read
these properties to know the URI and credentials of the Server it has to
monitor.
Almost all the properties in this configuration file are self-explanatory, so we are going to review only the most important ones:
monitors.local
. Comma-separated list of local active “monitors”:processes
andsockets
(see section Local Monitors).monitors.remote
. Comma-separated list of the monitors you want to launch:vdp
,browserpool
,arn
,arnindex
,maintenance
orscheduler
.{ arn | arnindex | browserpool | maintenance | scheduler | vdp }.monitors
. Properties that indicate which remote “monitors” will be active for each Server.The possible values for these properties are:
threads
resources
vdpqueries
(only forvdp
): to enable the “Virtual DataPort Queries Monitor”.vdploadcacheprocesses
(only forvdp
): to enable the “Virtual DataPort Cache Monitor”.vdpconnections
(only forvdp
): to enable the “Virtual DataPort Connections Monitor”.
{ processes | sockets | resources | threads }.interval
. Number of seconds between two JMX requests issued by that monitor.The properties
.jmx.password
store the password to connect to the Server of that property. These passwords can be stored encrypted. To do this, set the value of the property.jmx.password.encrypted
totrue
if the value of.jmx.password
is encrypted.For example, by default the Virtual DataPort password is
admin
. If you changed it and you want to store it in this configuration file encrypted, do the following:Execute the script
<DENODO_HOME>/tools/monitor/denodo-monitor/bin/encrypt_password <new password>
The output of this script is the encrypted password that you will put in the configuration file of the Denodo Monitor.
Open the file
<DENODO_HOME>/tools/monitor/denodo-monitor/conf/ConfigurationParameters.properties
Set the value of the property
vdp.jmx.password
to the encrypted password you obtained in step 1.Set the value of the property
vdp.jmx.password.encrypted
totrue
.
vdpqueries.jdbcagent.enable
andvdploadcacheprocesses.jdbcagent.enable
. Iftrue
, the information generated by the Queries monitor or the Cache monitor are stored in a database.To use this feature, uncomment and configure the other
jdbcagent
properties.Important
When using this feature, before launching the Denodo Monitor, copy the JDBC driver of the database (i.e. its jar file(s)) to the folder
<DENODO_MONITOR>/lib
.vdpqueries.snmptrapagent.enable
andvdploadcacheprocesses.snmptrapagent.enable
. Iftrue
, the monitor sends SNMP traps with the information received by the Queries monitor or the Cache Monitor.To use it, uncomment and configure the other
snmptrapagent
properties.