How to monitor the number of times a VDP server is restarted

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:

3. Make sure to replace the <DENODO_HOME> value in the appender to the location of the Denodo Installation.
4. 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)

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

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

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

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

Note for Denodo 7.0 and Denodo 8.0 only: 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

Virtual DataPort Administration Guide: Delimited File Sources