ENV_CF_SYS_RESOURCES administrative view - Get cluster caching facility system resource information

The ENV_CF_SYS_RESOURCES administrative view returns a list of system resources used by the cluster caching facilities (also known as CFs) on the system.

The schema is SYSIBMADM.

Authorization

One of the following authorizations is required:
  • SELECT privilege on the view
  • CONTROL privilege on the view
  • DATAACCESS authority

Default PUBLIC privilege

In a non-restrictive database, SELECT privilege is granted to PUBLIC when the view is automatically created.

Examples

The following example demonstrates the information you can obtain using the ENV_CF_SYS_RESOURCES administrative view.

SELECT * FROM SYSIBMADM.ENV_CF_SYS_RESOURCES

Information returned

Table 1. Information returned by the ENV_CF_SYS_RESOURCES administrative view
Column name Data type Description
NAME VARCHAR(128) Name of the system resource, see following table for possible values.
VALUE VARCHAR(1024) The value of the system resource.
DATATYPE VARCHAR(128) The data type of the value, see following table for possible values.
UNIT VARCHAR(128) The unit represented by the value, if applicable; null otherwise.
ID SMALLINT id - cluster caching facility identification monitor element
Table 2. Possible values for the NAME and DATATYPE columns
Information type Name Data Types Description
Operating system HOST_NAME VARCHAR(256) Name of the host the cluster caching facility is running on.
Physical memory MEMORY_TOTAL BIGINT Total size of physical memory.
MEMORY_FREE BIGINT Amount of free physical memory.
MEMORY_SWAP_TOTAL BIGINT Total amount of swap space.
MEMORY_SWAP_FREE BIGINT Amount of free swap space.
Virtual memory VIRTUAL_MEM_TOTAL BIGINT Total amount of virtual memory on the system.
VIRTUAL_MEM_RESERVED BIGINT Amount of reserved virtual memory.
CPU load CPU_USAGE_TOTAL DECIMAL Percentage of time the CF workers are busy doing work when the CF is bound to its own set of CPUs