monLogicalCluster

Description

(Cluster environments only) Displays information about the logical clusters currently configured on the system.

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

Columns

The columns for monLogicalCluster are:

Name

Datatype

Description

LCID

int

Logical cluster ID.

Attributes

int

Bitmask of logical cluster attributes.

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.

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.

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.

ActionnRelease

varchar(20)

The current action release mode for this logical cluster. Values are:

  • Manual

  • Automatic

Manual indicates that the user must execute the action release command to release the actions for this cluster.

Gather

varchar(30)

Indicates whether this logical cluster is configured to automatically gather routable connections to this logical cluster. Values are:

  • Manual

  • Automatic