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, the SAP ASE server retrieves rows only from the local instance.
set system_view cluster
set system_view instance
To retrieve the current system_view setting, select the @@system_view global variable.
sysprocesses
syslocks
sysengines
syslisteners
sysmonitors
syssechmechs
syscurconfigs