monCIPCMesh

Description

monCIPCMesh gives summary figures for the mesh of connections, from the current instance to all other instances in the cluster, on a per-instance basis. This monitoring table is available only for Adaptive Server Cluster Edition.

One row is returned for each of the four connections to each of the other nodes in the cluster, up to the maximum configured. If the system view is cluster, a set of rows for each instance active in the cluster is returned.

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

Columns

Name

Datatype

Description

InstanceID

tinyint

ID of the instance within the cluster.

FarInstanceID

tinyint

Instance number of the far-end instance in the cluster.

Received

int

Number of messages received by this instance from the FarInstanceID instance.

Dropped

int

Number of messages from the FarInstanceID instance that were dropped, due to a lack of resources.

Transmitted

int

Number of messages transmitted to the FarInstanceID instance.

Resent

int

Number of messages re-sent to the FarInstanceID instance.

Retry

int

Number of packets retried to the FarInstanceID instance.

SendQ

int

Current number of messages waiting to be sent to the FarInstanceID instance.

MaxSetQ

int

Maximum number of messages sent, but notification of sending is not yet processed.

Mesh

varchar

The channel name for the connection. One of:

  • Out of Band

  • Message

  • Large Message

  • Direct memory access (DMA)

MinRTT

int

Minimum round-trip delay observed for messages (applies only to user datagram protocol (UDP) transport).

MaxRTT

int

Maximum round trip delay observed for messages (applies only to UDP transport).

AverageRTT

int

Average round trip delay observed for messages (applies only to UDP transport).