DB2 Version 9.7 for Linux, UNIX, and Windows

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


>>-MON_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

EXECUTE privilege on the MON_GET_FCM_CONNECTION_LIST table function.

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	Reserved for future use.
FCM_CONGESTED_SENDS	BIGINT	Reserved for future use.
FCM_NUM_CONGESTION_TIMEOUTS	BIGINT	Reserved for future use.
FCM_SEND_VOLUME	BIGINT	fcm_send_volume - FCM send volume monitor element
FCM_RECV_VOLUME	BIGINT	fcm_recv_volume - FCM received volume monitor element
FCM_MESSAGE_SEND_VOLUME	BIGINT	Reserved for future use.
FCM_MESSAGE_RECV_VOLUME	BIGINT	Reserved for future use.
FCM_TQ_SEND_VOLUME	BIGINT	fcm_tq_send_volume - FCM table queue send volume monitor element
FCM_TQ_RECV_VOLUME	BIGINT	fcm_tq_recv_volume - FCM table queue received volume monitor element
FCM_NUM_CONN_LOST	BIGINT	Reserved for future use.
FCM_NUM_CONN_TIMEOUTS	BIGINT	Reserved for future use.
ADDITIONAL_DETAILS	BLOB(100K)	Reserved for future use.