REALIGN_CONTROL_NODES

Chooses control nodes (spread hosts) from all cluster nodes and assigns the rest of the nodes in the cluster to a control node. Calling this function respects existing fault groups, which you can view by querying the V_CATALOG.CLUSTER_LAYOUT system table. This view also lets you see the proposed new layout for nodes in the cluster.

Syntax

REALIGN_CONTROL_NODES()

Privileges

Superuser

Example

Choose control nodes from all cluster nodes and assign the remaining nodes to a control node:

=> SELECT REALIGN_CONTROL_NODES;

See Also

Defining and Realigning Control Nodes on an Existing Cluster