You can translate the document:

Goal

This document describes how to verify the number of restarts of a Denodo Virtual DataPort server instance.

Content

It is possible to use a grep-like command in order to monitor the vdp.log file and obtain start/stop messages.

An alternative way to do this is to use the Denodo Platform capabilities following these steps:

  1. Create a separate log file specifically for this task
  2. Modify the <DENODO_HOME>/conf/vdp/log4j2.xml file adding a new appender and logging category as follows:

        

<RollingFile name="CONTROL" fileName="<DENODO_HOME>/logs/vdp/vdp-control.log" filePattern="<DENODO_HOME>/logs/vdp/vdp-control.log.%i">

<Policies>

<SizeBasedTriggeringPolicy size="10 MB" />

</Policies>

<DefaultRolloverStrategy max="7" />

<PatternLayout

 pattern="%-4r [%t] %d{yyyy-MM-dd'T'HH:mm:ss.SSS} %x -\t%m %n" />

</RollingFile>


<Logger name="com.denodo.vdb.vdbinterface.server.VDBManagerImpl" level="info">

  <AppenderRef ref="CONTROL" />

</Logger>

  1. Make sure to replace the <DENODO_HOME> value in the appender to the location of the Denodo Installation.
  2. After modifying the log4j configuration file and restarting the VDP server the following log entries will be logged to the new log file:

  1. Virtual DataPort server started successfully. (VDP was started)
  2. JVM Shutdown captured (VDP was stopped, only for Denodo 6.0)

  1. To keep track of these messages, create a Delimited File Data source.
  2. Select Local as Data Route and browse to the path of the new log file.
  3. Select “Tuple pattern” option and type as regular expression to get the time and the log message:

 .*\[.*\]\s*(.*)\s*\[\] -\s+(.*)

  1. Once the data source is configured, create the base view, a query on this base view will return the information about the events that stop and start the Virtual DataPort server including a timestamp for the event.

  1. From this view, the count function can be used to see how many times the “Virtual DataPort server started successfully.” or the “JVM Shutdown captured” messages appear.

If you want to monitor the number of times the Solution Manager server is restarted, you can follow similar steps but modifying the file in <SOLUTION_MANAGER_HOME>/conf/vdp/log4j2.xml.

References

Delimited File Sources

Disclaimer
The information provided in the Denodo Knowledge Base is intended to assist our users in advanced uses of Denodo. Please note that the results from the application of processes and configurations detailed in these documents may vary depending on your specific environment. Use them at your own discretion.
For an official guide of supported features, please refer to the User Manuals. For questions on critical systems or complex environments we recommend you to contact your Denodo Customer Success Manager.

Questions

Ask a question

You must sign in to ask a question. If you do not have an account, you can register here