MON_GET_FCM_CONNECTION_LIST - Get details for all FCM connections

The MON_GET_FCM_CONNECTION_LIST table function returns monitor metrics for all the fast communication manager (FCM) connections on the specified member or members.

Syntax

Read syntax diagramSkip visual syntax diagramMON_GET_FCM_CONNECTION_LIST(member )

The schema is SYSPROC.

Table function parameter

member
An input argument of type INTEGER that specifies a valid database member number. Specify -1 for the current database member, or -2 for information from all active database members. An active database member is where the database is available for connection and use by applications.

Authorization

One of the following authorities is required to execute the routine:
  • EXECUTE privilege on the routine
  • DATAACCESS authority
  • DBADM authority
  • SQLADM authority

Default PUBLIC privilege

None

Information returned

Table 1. Information returned for MON_GET_FCM_CONNECTION_LIST
Column Name Data Type Description or corresponding monitor element
MEMBER SMALLINT member - Database member
REMOTE_MEMBER SMALLINT remote_member - Remote member
CONNECTION_STATUS VARCHAR(16) connection_status - Connection status
TOTAL_BUFFERS_SENT BIGINT total_buffers_sent - Total FCM buffers sent
TOTAL_BUFFERS_RCVD BIGINT total_buffers_rcvd - Total FCM buffers received
FCM_CONGESTION_TIME BIGINT fcm_congestion_time - FCM congestion time
FCM_CONGESTED_SENDS BIGINT fcm_congested_sends - FCM congested sends
FCM_NUM_CONGESTION_TIMEOUTS BIGINT fcm_num_congestion_timeouts - FCM congestion timeouts
FCM_SEND_VOLUME BIGINT fcm_send_volume - FCM send volume
FCM_RECV_VOLUME BIGINT fcm_recv_volume - FCM received volume
FCM_MESSAGE_SEND_VOLUME BIGINT fcm_message_send_volume - FCM message send volume
FCM_MESSAGE_RECV_VOLUME BIGINT fcm_message_recv_volume - FCM message received volume
FCM_TQ_SEND_VOLUME BIGINT fcm_tq_send_volume - FCM table queue send volume
FCM_TQ_RECV_VOLUME BIGINT fcm_tq_recv_volume - FCM table queue received volume
FCM_NUM_CONN_LOST BIGINT fcm_num_conn_lost - FCM lost connections
FCM_NUM_CONN_TIMEOUTS BIGINT fcm_num_conn_timeouts - FCM connection timeouts