The Denodo Virtual DataPort Server provides the possibility to log the requests sent to the Virtual DataPort Server. So, any queries which the server receives will be written to the log file <DENODO_HOME>/logs/vdp/vdp-requests.log.
There are two ways to activate the log level:
We will first have a look at the first approach and then on the second one.
For configuring the log level persistently the file vdp-requests.log located under <DENODO_HOME>\logs\vdp should be used to log information about the requests sent to the Virtual DataPort server.
By default, the information about requests will not be logged. To enable it you need to follow these steps:
Note that the only change is the level value from "error" to "info”.
After these changes, the requests arriving at the VDP server will be logged to the vdp-requests.log file.
An example request we will see the following information:
61381 [RMI(14)-192.168.0.45-20] INFO 2018-03-23T11:22:35.524 com.denodo.vdp.requests - SELECT * FROM phone_inc CONTEXT ('i18n'='us_pst') TRACE
If the log level should only be changed temporarily, for example, during a certain session the built-in LOGCONTROLLER stored procedure can be used. The main differences to the approach above are:
An example can be as following:
After running this statement you will find the same output in the file vdp-requests.log as above for this log category. Of course, this works also for other log categories.