DB2 Version 9.7 for Linux, UNIX, and Windows

SNAPSHOT_FCM table function

Note: This table function has been deprecated and replaced by the SNAPFCM administrative view and SNAP_GET_FCM table function - Retrieve the fcm logical data group snapshot information.
Read syntax diagramSkip visual syntax diagram
>>-SNAPSHOT_FCM--(--dbpartitionnum--)--------------------------><

The schema is SYSPROC.

The SNAPSHOT_FCM function returns database manager level information regarding the fast communication manager (FCM).

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.

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_FCM table function
Column name Data type Description or corresponding monitor element
SNAPSHOT_TIMESTAMP TIMESTAMP snapshot_timestamp - Snapshot timestamp
BUFF_FREE BIGINT buff_free - FCM buffers currently free
BUFF_FREE_BOTTOM BIGINT buff_free_bottom - Minimum FCM Buffers Free
MA_FREE BIGINT The ma_free monitor element is discontinued. A null value is returned for the discontinued monitor element.
MA_FREE_BOTTOM BIGINT The ma_free_bottom monitor element is discontinued. A null value is returned for the discontinued monitor element.
CE_FREE BIGINT The ce_free monitor element is discontinued. A null value is returned for the discontinued monitor element.
CE_FREE_BOTTOM BIGINT The ce_free_bottom monitor element is discontinued. A null value is returned for the discontinued monitor element.
RB_FREE BIGINT The rb_free monitor element is discontinued. A null value is returned for the discontinued monitor element.
RB_FREE_BOTTOM BIGINT The rb_free_bottom monitor element is discontinued. A null value is returned for the discontinued monitor element.
PARTITION_NUMBER SMALLINT node_number - Node number
Parent topic: Deprecated SQL administrative routines and their replacement routines or views
Related reference:
Snapshot monitor logical data groups and monitor elements