The system-view attribute controls how you see the cluster when using system stored procedures such as sp_who and sp_lock, or viewing monitor tables, fake tables, and so on. You can set the system_view attribute so Adaptive Server displays information about the current instance or the physical cluster.
For example, to set the system view for the instance:
sp_cluster logical, "set", SalesLC, system_view, instance
To set the system view for the cluster:
sp_cluster logical, "set", SalesLC, system_view, cluster
Setting the system view at a logical cluster level provides a default value for connections in a logical cluster. See the Reference Manual: Procedures.
The system-view attribute is an administrative
tool. Its current value does not affect the way applications perceive
a logical cluster, its databases, or database objects.
