The stored procedure LOGCONTROLLER changes the level of a log category and its subcategories. The changes performed by this procedure are lost when the Server is stopped.

Read more about this in the section Configuring the Logging System of the Administration Guide.


LogController (
       category : text
     , <level>

<level> ::=
    | 'DEBUG'
    | 'INFO'
    | 'WARN'
    | 'ERROR'
    | 'FATAL'
  • category: the category of the log.

  • level: the type of messages that you want to log for this category.

Privileges Required

Only administrators can invoke this procedure.


CALL LOGCONTROLLER('com.denodo.vdp.requests', 'INFO')

With the default configuration, after executing this query, all the requests sent to the Server will be logged in <DENODO_HOME>/logs/vdp/vdp-requests.log.