DB2 10.5 for Linux, UNIX, and Windows

Environment routines and views

This grouping of routines and views can be used to retrieve information about a database environment.

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.
ENV_FEATURE_INFO administrative view - Return license information for DB2 offerings
The ENV_FEATURE_INFO administrative view returns information about all available offerings for which a license is required. For each offering, there is information about whether or not a valid license for the offering has been installed.
ENV_GET_DB2_EDU_SYSTEM_RESOURCES table function - Return DB2 engine dispatchable units system information
The ENV_GET_DB2_EDU_SYSTEM_RESOURCES table function returns system resource metrics at the instance level for all DB2 engine dispatchable units (EDUs).
ENV_GET_DB2_SYSTEM_RESOURCES table function - Return DB2 system information
The ENV_GET_DB2_SYSTEM_RESOURCES table function returns CPU usage and DB2 process information for specified members in the current instance.
ENV_GET_NETWORK_RESOURCES table function - Return network information
The ENV_GET_NETWORK_RESOURCES table function returns information for all active network adaptors on the host machines running DB2.
ENV_GET_REG_VARIABLES table function - Retrieve DB2 registry settings in use
The ENV_GET_REG_VARIABLES table function returns the DB2 registry settings from one or all database members.
ENV_GET_INSTANCE_CODE_LEVELS table function - Return architectural level
The ENV_GET_INSTANCE_CODE_LEVELS table function returns the code level for the instance, members, and cluster caching facilities.
ENV_GET_SYSTEM_RESOURCES table function - Return system information
The ENV_GET_SYSTEM_RESOURCES table function returns operating system, CPU, memory, and other information that is related to members on the system.
ENV_INST_INFO administrative view - Retrieve information about the current instance
The ENV_INST_INFO administrative view returns information about the current instance.
ENV_PROD_INFO administrative view - Retrieve information about installed DB2 products
The ENV_PROD_INFO administrative view returns information about installed DB2 database products.
ENV_SYS_INFO administrative view - Retrieve information about the system
The ENV_SYS_INFO administrative view returns information about the system.