Configuring the Denodo Monitor

To start using the Denodo Monitor, follow these steps:

  1. Go to the directory <DENODO_HOME>/tools/monitor.

  2. On Windows, uncompress the file denodo-monitor.zip.

    On Linux, execute this: tar -xzf denodo-monitor.tar.gz.

  3. 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.

  4. To start the Denodo Monitor go to bin, in the directory of the Denodo Monitor and do this:

    • On Linux, execute ./denodo_monitor.sh.
    • On Windows, execute denodo_monitor.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 and sockets (see section Local Monitors).

  • monitors.remote. Comma-separated list of the monitors you want to launch: vdp, browserpool, arn, arnindex, maintenance or scheduler.

  • { 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 for vdp): to enable the “Virtual DataPort Queries Monitor”.
    • vdploadcacheprocesses (only for vdp): to enable the “Virtual DataPort Cache Monitor”.
    • vdpconnections (only for vdp): 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 to true 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.

      1. Open the file <DENODO_HOME>/tools/monitor/denodo-monitor/conf/ConfigurationParameters.properties
      2. Set the value of the property vdp.jmx.password to the encrypted password you obtained in step 1.
      3. Set the value of the property vdp.jmx.password.encrypted to true.
  • vdpqueries.jdbcagent.enable and vdploadcacheprocesses.jdbcagent.enable. If true, 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 and vdploadcacheprocesses.snmptrapagent.enable. If true, 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.