Managing the Plans of the Resource Manager

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

Syntax of the CREATE RESOURCE_MANAGER PLAN statement
CREATE [ OR REPLACE ] RESOURCE_MANAGER PLAN <name:identifier>
    [ DESCRIPTION = <description:literal> ]
    CONDITION <condition>
    ACTION <literal> [ PARAMETERS ( <parameters> ) ]*
    [ ACTION <literal> [ PARAMETERS ( <parameters> ) ]* ]*
    [ CONDITION <condition>
      ACTION <literal> [ PARAMETERS ( <parameters> ) ]*
      [ ACTION <literal> [ PARAMETERS ( <parameters> ) ]* ]*
    ]*

<parameters> ::= <param name:literal> = <value> [, <param name:literal>
= <value> ]
Syntax of the ALTER RESOURCE_MANAGER PLAN statement
ALTER RESOURCE_MANAGER PLAN <name:identifier>
    [ RENAME <name:identifier> ]
    [ DESCRIPTION = <description:literal> ]
    [ CONDITION <condition>
      { ACTION <literal> [ PARAMETERS ( <parameters> ) ]* }+
    ]*

To list the existing plans, run LIST RESOURCE_MANAGER PLANS.

To drop a plan, execute DROP RESOURCE_MANAGER PLAN:

Syntax of the DROP RESOURCE_MANAGER PLAN statement
DROP RESOURCE_MANAGER PLAN [ IF EXISTS ] <name:identifier> [ CASCADE ]

You cannot delete a plan if it has rules associated to it, unless you add the CASCADE clause. With the CASCADE clause, you will delete the plan and the rules associated to it.