Certain stored procedures, such as sp_who and sp_lock, read from fake tables such as sysprocesses and syslocks. Because their rows are not stored on disk, fake tables present an exception to the shared-data nature of a shared-disk cluster, and special features apply.
You can control whether a fake-table query returns rows from the local instance or all instances in the cluster by using the set system_view command. set system_view is a session-level command. In addition, set system_view also controls monitoring table materialization.
For information about setting the default system view at the logical-cluster level see the Users Guide to Clusters.
By default, Adaptive Server retrieves rows only from the local instance.
To specify that fake-table queries materialize rows for all instances, use the cluster option. For example:
set system_view cluster
To specify that fake-table queries materialize rows for the local instance, use the instance option. For example:
set system_view instance
To retrieve the current system_view setting, select the @@system_view global variable.
Adaptive Server supports cluster-wide materialization for these fake tables:
sysprocesses
syslocks
sysengines
syslisteners
sysmonitors
syssechmechs
syscurconfigs
sysinstances is always set for cluster-wide materialization, regardless of the system_view setting.