Cluster=(node-list)
Nocluster
Specifies the list of remote nodes from which statistics
collection and presentation are to be performed. The collected
statistics are merged with the information for the current node
and displayed using the usual statistics screens.
The following list summarizes usage of the Cluster qualifier:
o If the Cluster qualifier is specified by itself, remote
statistics collection is performed on all cluster nodes on
which the database is currently open.
o If the Cluster=(node-list) qualifier is specified, remote
statistics collection is performed on the specified nodes
only, even if the database is not yet open on those nodes.
o If the Cluster qualifier is not specified, or the Nocluster
qualifier (the default) is specified, cluster statistics
collection is not performed. However, you can still enable
clusterwide statistics collection online using the Tools menu.
You can specify up to 95 different cluster nodes with the Cluster
qualifier. There is a maximum number of 95 cluster nodes because
Oracle Rdb supports only 96 nodes per database. The current node
is always included in the list of nodes from which statistics
collection is to be performed.
It is not necessary to have the RMU Show Statistics command
running on the specified remote nodes or to have the database
open on the remote nodes. These events are automatically handled
by the feature.
The following example shows the use of the Cluster qualifier to
initiate statistics collection and presentation from two remote
nodes:
$ RMU /SHOW STATISTICS /CLUSTER=(BONZAI, ALPHA4) MF_PERSONNEL
Remote nodes can also be added and removed online at run time.
Use the Cluster Statistics option located in the Tools menu.
The Tools menu is displayed by using the exclamation point (!)
on-screen menu option.
See the RMU Show Statistic DBA Handbook (available in MetaLink
if you have a service contract) for information about the Cluster
Statistics Collection and Presentation feature.