You can translate the question and the replies:

How to view execution history of a view

Hi, How to see the execution history of a base/derived view. I want to see the historical execution status of a view. the run time and the status of execution. Is there any way we can get the historical statistics of the views executed in denodo. Sometime we execute the view manually in denodo and sometimes we call that from a diffent application. Can you help me in figuring out the execution histrory. Regards, Sachi
user
07-09-2017 01:47:09 -0400
code

1 Answer

Hi In Denodo Platform you could log the queries executed against the Virtual DataPort using Denodo Monitor tool. It collects information about Select, CALL and DDL statements. If I need to store the execution details of a view I would perform the following, 1. Unzip the file denodo-monitor.zip located in <DENODO_HOME>/tools/monitor. 1. Launch the Denodo Monitor by executing the script "denodo_monitor_startup" located in <DENODO_MONITOR>/bin. 1. Execute the query in Virtual DataPort. 1. You could find the logs of the executed query stored in the file "vdp-queries.log" located in <DENODO_MONITOR>/logs. Besides that, you could store the output of "vdp-queries.log" in a database and query the execution details of a view. You could find the steps in ConfigurationParameters.properties file located in <DENODO_MONITOR>/conf. I would refer the section [Denodo Monitor](https://community.denodo.com/docs/html/browse/6.0/vdp/administration/monitoring_the_virtual_dataport_server/denodo_monitor/denodo_monitor#denodo-monitor) in Virtual DataPort Administration Guide for more information in Denodo Monitor. Hope this helps!
Denodo Team
07-09-2017 09:14:34 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here