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.
SELECT CONNECTION_STATUS, TOTAL_BUFFERS_SENT, TOTAL_BUFFERS_RECEIVED
FROM SYSIBMADM.SNAPFCM_PART WHERE DBPARTITIONNUM = 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 partition, aggregate of all database partitions or all database partitions.
Used with the SNAP_GET_DBM_V95, 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--(--+----------------+--)----------------->< '-dbpartitionnum-'
The schema is SYSPROC.
If dbpartitionnum 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 database partition number.
SELECT FCM_DBPARTITIONNUM, TOTAL_BUFFERS_SENT, TOTAL_BUFFERS_RCVD,
DBPARTITIONNUM FROM TABLE(SNAP_GET_FCM_PART()) AS T
ORDER BY DBPARTITIONNUM
FCM_DBPARTITIONNUM TOTAL_BUFFERS_SENT TOTAL_BUFFERS_RCVD DBPARTITIONNUM
------------------ -------------------- -------------------- --------------
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 | snapshot_timestamp - Snapshot timestamp monitor element |
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 | The database partition from which the data was retrieved for this row. |
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). |