Each logical cluster is associated with a load profile, either a system load profile or a user-created load profile. To change the load profile, associate the new load profile with a logical cluster.
For example, to change the load profile for “SalesLC” from “my_profile” to “sybase_profile_oltp,” enter:
sp_cluster logical, "set", SalesLC, load_profile, sybase_profile_oltp
You can then drop the old load profile. For example, to drop “my_profile,” enter:
sp_cluster profile, "drop", my_profile