Adding failover resources

Use sp_cluster logical, "add" to add failover resources to a logical cluster. You cannot add failover resources to the system logical cluster.

Each time you use sp_cluster logical, "add" to add failover resources, Adaptive Server creates one or more failover groups.

If you add one or more failover instances, separating multiple instances with semicolons, Adaptive Server places all instances in a single group.

For example, to add “ase3” as a failover group to “SalesLC”, enter:

sp_cluster logical, "add", SalesLC, failover, ase3

You can also add failover instances to existing failover groups. For example, suppose “ase3” is a member of failover group 1. To add “ase4” to failover group 1, enter:

sp_cluster logical, "add", SalesLC, failover, ase4, "1"

To view failover resource information, including the failover group ID, use sp_cluster logical, “show”.