(Cluster environments only) Provides summary figures for total messaging within the cluster, as viewed from the current instance or all instances.
One row is returned in the monCIPC table for each instance in the cluster, if the system view is set to cluster; otherwise, a single row is returned for the instance on which the query is executed.
You need not enable any configuration parameters for this monitoring table to collect data.
The columns for monCIPC are:
Name |
Datatype |
Description |
---|---|---|
InstanceID |
tinyint |
ID of the instance within the cluster |
ReceiveCount |
int |
Number of messages received by this instance |
TransmitCount |
int |
Number of messages sent by this instance |
Multicast |
int |
Number of messages sent that were addressed to all other instances in the cluster |
Synchronous |
int |
Number of those messages sent synchronously |
ReceiveSoftError |
int |
Number of recoverable errors received on this instance |
ReceiveHardError |
int |
Number of unrecoverable errors received on this instance |
TransmitsSoftError |
int |
Number of recoverable transmit errors on this instance |
TransmitHardError |
int |
Number of unrecoverable transmit errors on this instance |
Retransmits |
int |
Number of retransmissions performed by this instance |
Switches |
int |
Number of switches between the primary interconnect network and the secondary interconnect network |
FailedSwitches |
int |
Number of attempts to switch between primary and secondary interconnect networks that failed |
RegularBuffersInUse |
int4 |
Number of buffers from the CIPC regular buffer pool currently allocated. |
FreeRegularBuffers |
int4 |
Number of buffers available in the CIPC regular buffer pool. |
MaxRegularBuffersInUse |
int4 |
Maximum number of buffers from the CIPC regular buffer pool allocated at any time since the server was started. |
LargeBuffersInUse |
int4 |
Number of buffers from the CIPC large buffer pool currently allocated. |
FreeLargeBuffers |
int4 |
Number of buffers available in the CIPC large buffer pool. |
MaxLargeBuffersInUse |
int4 |
Maximum number of buffers from the CIPC large buffer pool allocated at any time since the server was started. |