monLogicalCluster

Description

Displays information about the logical clusters currently configured on the system. This monitoring table is available only for Adaptive Server Cluster Edition.

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

Columns

Name

Datatype

Description

LCID

int

Logical cluster ID.

Name

varchar(30)

Logical cluster name.

State

varchar(20)

Current state. One of:

  • Online

  • Offline

  • Failed

  • Inactive

  • Time_wait

DownRoutingMode

varchar(20)

Down routing-mode setting. One of:

  • System

  • Open

  • Disconnect

FailoverMode

varchar(20)

Failover mode setting, instance or cluster.

Attributes

int

Bitmask of logical cluster attributes.

StartupMode

varchar(20)

Start-up mode setting, automatic or manual.

SystemView

varchar(20)

System view setting, instance or cluster.

Roles

varchar(20)

Comma-delimited list of special roles for this logical cluster. The “system” logical cluster always has the system role. The open logical cluster has the “open” role. If the system logical cluster also has the open role, the value for this column is system, open. Logical clusters without any special roles return a null value.

LoadProfile

varchar(30)

Load profile associated with this logical cluster.

ActiveConnections

int

Number of active connections using this logical cluster.

BaseInstances

tinyint

Number of instances configured as base instances for this logical cluster.

ActiveBaseInstances

tinyint

Number of base instances on which this logical cluster is currently active.

FailoverInstances

tinyint

Number of instances configured as failover instances for this logical cluster.

ActiveFailoverInstances

tinyint

Number of failover instances on which this logical cluster is currently active.