Denodo logs of internal queries?

Where can I find the logs when a user is querying the internal Denodo database? e.g. when investigating data lineage ``` CALL VIEW_DEPENDENCIES(...) ``` I can not find these in the regular logs
user
30-08-2018 04:14:36 -0400

1 Answer

Hi, You can enable Denodo Monitor to get the logs for Virtual DataPort Queries Monitor. It logs all the statements processed by Virtual DataPort. To start using the Denodo Monitor, you can follow these steps: * Unzip the file in the directory <DENODO_HOME>/tools/monitor. * To start the Denodo Monitor go to bin, in the directory of the Denodo Monitor and run the script *denodomonitorstartup.bat/.sh* Once Denodo Monitor starts, it collects information about queries and the logs can be found in denodo-monitor/logs/vdp-queries.log. You can also use the [LOGCONTROLLER](https://community.denodo.com/docs/html/browse/7.0/vdp/vql/stored_procedures/predefined_stored_procedures/logcontroller) stored procedure and execute this statement in VQL Shell: `CALL LOGCONTROLLER(‘com.denodo.vdb.management.mbeans.request.RequestsManagementInfo’, ‘INFO’)` The queries will be stored in <DENODO_HOME>/logs/vdp/vdp-queries.log. You can refer to the [Configuring the Denodo Monitor](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/monitoring_the_virtual_dataport_server/denodo_monitor/configuring_the_denodo_monitor) section of Virtual DataPort Administration Guide and [Using logcontroller and useful log categories](https://community.denodo.com/kb/view/document/Using%20logcontroller%20and%20useful%20log%20categories?category=Operation) Knowledge Base Article for more information. Hope this helps!
Denodo Team
30-08-2018 05:57:34 -0400
You must sign in to add an answer. If you do not have an account, you can register here