You can translate the question and the replies:

VQL statement for Resource Manager rule or plan

Please share some examples/link related to VQL statement for creating resource manager rule/plan. Eg. RESOURCE MANAGER PLAN CREATE OR REPLACE RESOURCE_MANAGER PLAN "RMPLAN1" DESRIPTION = "TEST" CONDITION " " ACTION "" RESOURCE MANAGER RULE CREATE OR REPLACE RESOURCE_MANAGER RULE "RMRULE1" DESCRIPTIOMN ="TEST" CONDITION "" RESOURCE_MANAGER PLAN = "RMPLAN1" please share some example values for CONDITION and ACTION in above plan/rule. Itried to find some examples, but didn't get any examples. We would be very thankful if you share some examples for resource manager rule/plans.

2 Answers

Hi, Generally, the Resource Manager allows the user to allocate or restrict resources for a group of user sessions. In order to get the VQLs for the Plans and Rules, a global export of the Virtual DataPort server includes the creation of VQL sentences of the plans and rules of the Resource Manager. The below VQL sentence creates a resource manager plan named “plan1” that always stops the queries. > CREATE OR REPLACE RESOURCE_MANAGER PLAN plan1 > CONDITION True > ACTION ‘STOP_QUERY_ALWAYS’; Also, > CREATE OR REPLACE RESOURCE_MANAGER RULE rule1 > CONDITION True > RESOURCE_MANAGER PLAN plan1; The above VQL sentence creates a resource manager rule named "rule1" linked to the plan "plan1" that always will be activated. In addition, you could also execute the VQL sentences ALTER RESOURCE_MANAGER RULE and ALTER RESOURCE_MANAGER PLAN to edit the plans and rules of Resource Manager. For instance: ``` ALTER RESOURCE_MANAGER PLAN plan1 CONDITION True ACTION 'STOP_QUERY_ALWAYS'; ``` ``` ALTER RESOURCE_MANAGER RULE rule1 CONDITION True RESOURCE_MANAGER PLAN plan1; ``` You could refer to the [Resource Manager](https://community.denodo.com/docs/html/browse/latest/en/vdp/vql/resource_manager/resource_manager) section under Virtual DataPort VQL Guide for more information. Hope this helps!
Denodo Team
06-12-2021 07:54:01 -0500
code
Thanks a lot
user
06-12-2021 11:40:51 -0500
You must sign in to add an answer. If you do not have an account, you can register here