MON_GET_FCM - Get FCM metrics
The MON_GET_FCM table function returns metrics for the fast communication manager (FCM).
Syntax
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
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:
MEMBER BUFF_FREE BUFF_FREE_BOTTOM
------ ------------------- -----------------
2 13425 13416
10 13425 13416
1 13425 13416
3 record(s) selected.
Information returned
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 |
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.