The SNAPFCM administrative view and the SNAP_GET_FCM table function return information about the fast communication manager from a database manager snapshot, in particular, the fcm logical data group.
Used with the SNAPDBM, SNAPDBM_MEMORY_POOL, SNAPFCM_PART and SNAPSWITCHES administrative views, the SNAPFCM 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 BUFF_FREE, BUFF_FREE_BOTTOM, DBPARTITIONNUM
FROM SYSIBMADM.SNAPFCM ORDER BY DBPARTITIONNUM
BUFF_FREE BUFF_FREE_BOTTOM DBPARTITIONNUM
---------...---- -------------------- --------------
5120 5100 0
5120 5100 1
5120 5100 2
The SNAP_GET_FCM table function returns the same information as the SNAPFCM 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_PART and SNAP_GET_SWITCHES table functions, the SNAP_GET_FCM 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--(--+----------------+--)---------------------->< '-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 table function takes a snapshot for the currently connected database and database partition number.
SELECT BUFF_FREE, BUFF_FREE_BOTTOM, DBPARTITIONNUM
FROM TABLE(SYSPROC.SNAP_GET_FCM( 1 )) AS T
BUFF_FREE BUFF_FREE_BOTTOM DBPARTITIONNUM
-------------------- -------------------- --------------
5120 5100 1
Column name | Data type | Description or corresponding monitor element |
---|---|---|
SNAPSHOT_TIMESTAMP | TIMESTAMP | snapshot_timestamp - Snapshot timestamp monitor element |
BUFF_FREE | BIGINT | buff_free - FCM buffers currently free |
BUFF_FREE_BOTTOM | BIGINT | buff_free_bottom - Minimum FCM Buffers Free |
CH_FREE | BIGINT | ch_free - Channels Currently Free |
CH_FREE_BOTTOM | BIGINT | ch_free_bottom - Minimum Channels Free |
DBPARTITIONNUM | SMALLINT | The database partition from which the data was retrieved for this row. |