Managing the Rules of the Resource Manager¶

The figures below lists how to create, modify and delete rules of the resource manager.

Syntax of the CREATE RESOURCE_MANAGER RULE statement¶

CREATE [ OR REPLACE ] RESOURCE_MANAGER RULE <name:identifier>
    [ DESCRIPTION = <description:literal> ]
    CONDITION <condition>
    RESOURCE_MANAGER PLAN <name:identifier>

<condition> ::= (see Rules for forming functions)

<identifier> ::= (see Basic primitives for specifying VQL statements)

Syntax of the ALTER RESOURCE_MANAGER RULE statement¶

ALTER RESOURCE_MANAGER RULE <name:identifier>
    [ RENAME <new_name:identifier> ]
    [ DESCRIPTION = <description:literal> ]
    [ CONDITION <condition> ]
    [ RESOURCE_MANAGER PLAN <name:identifier> ]

To list the existing rules, run LIST RESOURCE_MANAGER RULES.

To drop a plan, execute DROP RESOURCE_MANAGER RULE:

Syntax of the DROP RESOURCE_MANAGER RULE statement¶

DROP RESOURCE_MANAGER RULE [ IF EXISTS ] <name:identifier>

USER MANUALS

Managing the Rules of the Resource Manager¶