DB2 Version 9.7 for Linux, UNIX, and Windows

SNAPSHOT_FCMNODE table function

Returns information from a snapshot of the fast communication manager in the database manager.

Note: This table function has been deprecated and replaced by the SNAPFCM_PART administrative view and SNAP_GET_FCM_PART table function - Retrieve the fcm_node logical data group snapshot information.


>>-SNAPSHOT_FCMNODE--(--dbpartitionnum--)----------------------><

The schema is SYSPROC.

Table function parameter

dbpartitionnum: An input argument of type INTEGER that specifies a valid database partition number. Specify -1 for the current database partition, or -2 for all active database partitions. An active database partition is a partition where the database is available for connection and use by applications.
If the null value is specified, -1 is set implicitly.

If the null value is specified, the snapshot will be taken only if a file has not previously been created by the SNAPSHOT_FILEW stored procedure for the corresponding snapshot API request type.

Authorization

One of the following authorities is required to execute the function:

EXECUTE privilege on the function
DATAACCESS authority

To access snapshot monitor data, one of the following authorities is required:

SYSMON authority
SYSCTRL authority
SYSMAINT authority
SYSADM authority

The function returns a table as shown in the following section.

Table 1. Information returned by the SNAPSHOT_FCMNODE table function
Column name	Data type	Description or corresponding monitor element
SNAPSHOT_TIMESTAMP	TIMESTAMP	snapshot_timestamp - Snapshot timestamp
CONNECTION_STATUS	BIGINT	connection_status - Connection status
TOTAL_BUFFERS_SENT	BIGINT	total_buffers_sent - Total FCM buffers sent
TOTAL_BUFFERS_RCVD	BIGINT	total_buffers_rcvd - Total FCM buffers received
PARTITION_NUMBER	SMALLINT	node_number - Node number