This document explains how to use the predefined LOGCONTROLLER stored procedure and some useful log categories.
Denodo Virtual DataPort uses the logging library Apache Log4j to log the activity of the Virtual DataPort server and its Administration Tool. Log4j allows defining several categories on which the log level will be specified independently.
By default, the Virtual DataPort Server logs are stored in <DENODO_HOME>/logs/vdp and the Administration Tool logs, in <DENODO_HOME>/logs/vdp-admin. The configuration of Log4j of the Virtual DataPort server is controlled by the file log4j2.xml (<DENODO_HOME>/conf/vdp) and for the Administration Tool by the file log4j.xml (<DENODO_HOME>/conf/vdp-admin).
You can change the log level of a category in the VDP server without restarting it by calling the stored procedure “LogController”. This stored procedure changes the log level for a certain log category of the logging engine used by Virtual DataPort at run time. The changes performed by this procedure are lost when the Server is stopped. Administration privileges are required to call this stored procedure.
Syntax: LogController (<logCategory>, <logLevel>)
The log categories have a hierarchical structure when a log level is set for a category all its subcategories will also be set to the same log level.
For example, on executing
CALL LOGCONTROLLER('com.denodo', 'INFO')
all the classes under the “com.denodo” category will be set to the INFO log level and its subcategories will also log to the same level.
The “com.denodo” log category can be used when we are not aware of which log category has to be used since it displays all the subcategories in the VDP servers.
The following is a list of useful log categories:
Virtual DataPort Administration Guide: Configuring the Logging Engine
Advanced VQL Guide: LOGCONTROLLER