monLogicalClusterAction

Description

Shows all administrative actions against local clusters from start-up until these actions are released. This monitoring table is available only for Adaptive Server Cluster Edition.

You need not enable any configuration parameters for this monitoring table to collect data.

Columns

Name	Datatype	Description
Handle	int	Unique handle used to cancel this action.
State	varchar(20)	State of the action: `active`, `complete`, or `canceled`.
LCID	int	Logical cluster ID to which this action applies.
LogicalClusterName	varchar(30)	Logical cluster name of this logical cluster (denormalized to reduce joins).
Action	varchar(15)	Action being performed. A combination of the command running and its scope. For example, offline instance or failover cluster.
FromInstances	varchar(96)	A comma-separated list of `from instances` for this command and action (instance being brought offline).
ToInstances	varchar(96)	A comma-separated list of `to instances` for this command and action (instances being brought online).
InstancesWaiting	int	Number of instances waiting to go offline (this is a count of FromInstances that are in the `time_wait` state).
WaitType	varchar(20)	Current wait state for this action. One of: `wait`, `until`, or `nowait`.
StartTime	datetime	Date and time the command was issued.
Deadline	datetime	Date and time the command must be finished (based on the time value supplied to the `wait` or `until` options).
CompleteTime	datetime	Date and time the command and action completed (when InstancesWaiting is zero and the action went from `active` to the `complete` state). Returns NULL for incomplete actions.
ConnectionsRemaining	int	Number of connections remaining to move as a result of this command.
NonMigConnections	int	Number of connections to be terminated because they do not support the migration protocol.
NonAHConnections	int	Number of connections that do not support the high availability failover protocol. These connections are disconnected and cannot fail over when the command finishes.