DROP RESOURCE GROUP group_name [FORCE]
group_name identifies which resource
group to drop. If the group does not exist, an error occurs.
FORCE modifier determines statement
behavior if the resource group has any threads assigned to it:
FORCEis not given and any threads are assigned to the group, an error occurs.
FORCEis given, existing threads in the group are moved to their respective default group (system threads to
SYS_default, user threads to
Drop a group, failing if the group contains any threads:
DROP RESOURCE GROUP rg1;
Drop a group and move existing threads to the default groups:
DROP RESOURCE GROUP rg2 FORCE;
Resource group management is local to the server on which it
DROP RESOURCE GROUP
statements are not written to the binary log and are not