Logging Resource Manager Actions

The log of the Resource Manager actions is at <DENODO_HOME>/logs/vdp/vdp-resource-manager.log

It collects the following information about all the actions activated by the Resource Manager:

  • Time: time when the action was evaluated.

  • Request id: query identifier.

  • Rule name: the rule that applied the initial plan to the query (a query can then switch from one plan to another with the switch query plan action).

  • Plan name: plan associated with the action being executed.

  • Global CPU usage: percentage of global CPU usage.

  • Action type: action being executed (all actions can be found here).

  • Action message: explanatory message of the action being executed.

  • Database: session database.

  • Query: VQL of the query.

How to Enable this Log

To enable this log, do these changes in the file <DENODO_HOME>/conf/vdp/log4j2.xml

  1. Inside the Appenders section, add this:

    <RollingFile name="RMOUT" fileName="{<DENODO_HOME>}/logs/vdp/vdp-resource-manager${env:vdp.instance.log}.log" filePattern="{<DENODO_HOME>}/logs/vdp/vdp-resource-manager${env:vdp.instance.log}.log.%i">
            <SizeBasedTriggeringPolicy size="10 MB" />
        <DefaultRolloverStrategy max="7" />
        <PatternLayout pattern="%-4r [%t] %d{yyyy-MM-dd'T'HH:mm:ss.SSS} %x -\t%m  %n" />
  2. Inside the Loggers section, add this:

    <Logger name="com.denodo.vdp.resourcemanager.actions.ResourceManagerEngine" level="INFO" additivity="false">
        <AppenderRef ref="RMOUT" />
  3. Restart Virtual DataPort.

Add feedback