You can translate the question and the replies:

VDP configuration

Hi Team, How can i configure the VDP configuration in sigle command cetralized location like setting query limit in all vdp in sigle query or command without login every vdp admin tool to do the changes. Thanks
QUERY_TIMEOUT
user
19-04-2022 06:52:27 -0400
code

1 Answer

Hi, If I face such scenario, I would use the Resource Manager to create a new Plan and a Rule to configure the Query Timeout using the parameter “**Stop query when the maximum execution time has been reached**”. This parameter stops the query once the maximum execution time configured, has been reached and this applies to all the queries that are being executed against the particular Virtual DataPort Server. Also, this property overrides the Query timeout configured in the “**Tools > Admin Tool Preferences > Connection > Query timeout**”. For more information, you could refer to the **[Resource Manager](https://community.denodo.com/docs/html/browse/8.0/en/vdp/administration/resource_manager/resource_manager#resource-manager)** section of the Virtual DataPort Administration Guide. Hope this helps!
Denodo Team
19-04-2022 23:51:32 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here