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
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 |
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 |