Adds a resource or one or more routes to the logical cluster.
sp_cluster logical, "add", lc_name, {
route, route_type, key_list |
instance, instance_list |
failover, instance_list }
lc_name – is the name of a logical cluster.
route – specifies that one or more routes are to be added to the logical cluster.
route_type – is the type of route to be added. Values are:
application – specifies a route for an application name to the logical cluster.
login – specifies a route for a login name to the logical cluster.
alias – specifies a route for a server name alias to the logical cluster.
key_list – is a list of applications, logins, or aliases, depending on the route type. Elements in the key list are delimited by semicolons.
instance – specifies that one or more base instances are to be added to the logical cluster.
instance_list – is the list of instances to be added. Separate multiple instances with semicolons.
failover – specifies that one or more failover instances are to be added to the logical cluster.
Example 1 Adds instances “ase1” and “ase2” to the “SalesLC” logical cluster.
sp_cluster logical, "add", SalesLC, instance, "ase1;ase2"
Example 2 Creates one failover group with “ase3” for “SalesLC”.
sp_cluster logical, "add", SalesLC, failover, ase3
Example 3 Routes the logins “tom”, “dick”, and “harry” to the “SalesLC” logical cluster
sp_cluster logical, "add", SalesLC, route, login, "tom;dick;harry"
Example 4 Routes the field_sales application to the “SalesLC” logical cluster.
sp_cluster logical, "add", SalesLC, route, application, field_sales
You cannot add a base instance or a failover resource to the system logical cluster.
Separate multiple instance, failover resources, or applications with semicolons.
Create multiple failover groups by enclosing the group in parenthesis, and separating groups with a comma. If you do not specify group, a new group is created and the instances are added to that group. You can specify a group into which the instances are placed (the group number must be quoted).
For example:
1> sp_cluster logical, 'add', tempLC, failover, "asedemo3;asedemo2" 2> go Added failover instance 'asedemo3' to group 1 for logical cluster 'tempLC'. Added failover instance 'asedemo2' to group 1 for logical cluster 'tempLC'.
And then add the instances to the group:
1> sp_cluster logical, 'add', tempLC, failover, asedemo4, "4" 2> go Added failover instance 'asedemo4' to group 4 for logical cluster 'tempLC'.
