You can also use the Adaptive Server plug-in to create
logical clusters. See “Adding a logical cluster”.
Create a logical cluster using sp_cluster logical, "create".
For example, suppose a physical cluster called “mycluster” that contains four instances: “ase1”, “ase2”, “ase3”, and “ase4”. We create three logical clusters:
“SalesLC” – to handle applications and logins from the Sales Department.
“HRLC” – to handle applications and logins from the Human Resources Department.
“CatchallLC” – to use later for an open logical cluster.
To create “SalesLC”, “HRLC”, and “CatchallLC”, enter:
sp_cluster logical, "create", SalesLC sp_cluster logical, "create", HRLC sp_cluster logical, "create", CatchallLC
