The SNAPFCM_PART administrative view and the SNAP_GET_FCM_PART table function return information about the fast communication manager from a database manager snapshot, in particular, the fcm_node logical data group.
Used with the SNAPDBM, SNAPDBM_MEMORY_POOL, SNAPFCM and SNAPSWITCHES administrative views, the SNAPFCM_PART administrative view provides the data equivalent to the GET SNAPSHOT FOR DBM command.
The schema is SYSIBMADM.
Refer to Table 1 for a complete list of information that can be returned.
In a non-restrictive database, SELECT privilege is granted to PUBLIC when the view is automatically created.
SELECT CONNECTION_STATUS, TOTAL_BUFFERS_SENT, TOTAL_BUFFERS_RECEIVED
FROM SYSIBMADM.SNAPFCM_PART WHERE MEMBER = 0
CONNECTION_STATUS TOTAL_BUFFERS_SENT TOTAL_BUFFERS_RCVD
-------------------- -------------------- --------------------
INACTIVE 2 1
1 record(s) selected.
The SNAP_GET_FCM_PART table function returns the same information as the SNAPFCM_PART administrative view, but allows you to retrieve the information for a specific database member, aggregate of all database members or all database members.
Used with the SNAP_GET_DBM, SNAP_GET_DBM_MEMORY_POOL, SNAP_GET_FCM and SNAP_GET_SWITCHES table functions, the SNAP_GET_FCM_PART table function provides the data equivalent to the GET SNAPSHOT FOR DBM command.
Refer to Table 1 for a complete list of information that can be returned.
>>-SNAP_GET_FCM_PART--(--+--------+--)------------------------->< '-member-'
The schema is SYSPROC.
If member is set to NULL, an attempt is made to read data from the file created by SNAP_WRITE_FILE procedure. Note that this file could have been created at any time, which means that the data might not be current. If a file with the corresponding snapshot API request type does not exist, then the SNAP_GET_FCM_PART table function takes a snapshot for the currently connected database and member.
In a non-restrictive database, EXECUTE privilege is granted to PUBLIC when the function is automatically created.
SELECT FCM_MEMBER, TOTAL_BUFFERS_SENT, TOTAL_BUFFERS_RCVD,
MEMBER FROM TABLE(SNAP_GET_FCM_PART()) AS T
ORDER BY MEMBER
FCM_MEMBER TOTAL_BUFFERS_SENT TOTAL_BUFFERS_RCVD MEMBER
---------- -------------------- -------------------- ------
0 305 305 0
1 5647 1664 0
2 5661 1688 0
0 19 19 1
1 305 301 1
2 1688 5661 1
0 1664 5647 2
1 10 10 2
2 301 305 2
Column name | Data type | Description or corresponding monitor element |
---|---|---|
SNAPSHOT_TIMESTAMP | TIMESTAMP | The date and time that the snapshot was taken. |
CONNECTION_STATUS | VARCHAR(10) | connection_status - Connection status .
This interface returns a text identifier based on the defines in sqlmon.h and is one of:
|
TOTAL_BUFFERS_SENT | BIGINT | total_buffers_sent - Total FCM buffers sent |
TOTAL_BUFFERS_RCVD | BIGINT | total_buffers_rcvd - Total FCM buffers received |
DBPARTITIONNUM | SMALLINT | dbpartitionnum - Database partition number monitor element |
FCM_DBPARTITIONNUM | SMALLINT | The database partition number to which data was sent or from which data was received (as per the TOTAL_BUFFERS_SENT and TOTAL_BUFFERS_RCVD columns). |
MEMBER | SMALLINT | member - Database member monitor element |
FCM_MEMBER | SMALLINT | The member to which data was sent or from which data was received (as per the TOTAL_BUFFERS_SENT and TOTAL_BUFFERS_RCVD columns). |