DB2 Version 9.7 for Linux, UNIX, and Windows

MON_GET_FCM - Get FCM metrics

The MON_GET_FCM table function returns metrics for the fast communication manager (FCM).

Syntax


>>-MON_GET_FCM--(--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 table function.

Example

To retrieve information about the fast communication manager message buffers on all members:

SELECT member, buff_free, buff_free_bottom
   FROM TABLE (MON_GET_FCM (-2))

This query returns the following output:

MEMBER BUFF_FREE           BUFF_FREE_BOTTTOM
------ ------------------- -----------------
     2               13425             13416
    10               13425             13416
     1               13425             13416

3 record(s) selected.

Information returned

Table 1. Information returned for MON_GET_FCM
Column Name	Data Type	Description or corresponding monitor element
HOSTNAME	VARCHAR(128)	hostname - Host name
MEMBER	SMALLINT	member - Database member
BUFF_MAX	BIGINT	buff_max - Maximum possible number of FCM buffers
BUFF_TOTAL	BIGINT	buff_total - Number of currently allocated FCM buffers
BUFF_FREE	BIGINT	buff_free - FCM buffers currently free
BUFF_FREE_BOTTOM	BIGINT	buff_free_bottom - Minimum FCM buffers free
BUFF_AUTO_TUNING	SMALLINT	buff_auto_tuning - FCM buffer auto-tuning indicator
CH_MAX	BIGINT	ch_max - Maximum possible number of FCM channels
CH_TOTAL	BIGINT	ch_total - Number of currently allocated FCM channels
CH_FREE	BIGINT	ch_free - Channels currently free
CH_FREE_BOTTOM	BIGINT	ch_free_bottom - Minimum channels free
CH_AUTO_TUNING	SMALLINT	ch_auto_tuning - FCM channel auto-tuning indicator
ADDITIONAL_DETAILS	BLOB(100K)	Reserved for future use.

Note: The metrics provided by this table function apply to all members on a given host machine. All members on a given host machine share the same set of buffers and channels. This means that the individual metrics will usually be the same for each member on given host machine. However, each member executes independently and the metrics might differ slightly as the resource numbers change in between the sampling on different members.