Environment routines and views

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

ENV_GET_DB2_EDU_SYSTEM_RESOURCES table function - Return information about the database engine dispatchable units
The ENV_GET_DB2_EDU_SYSTEM_RESOURCES table function returns system resource metrics at the instance level for all database engine dispatchable units (EDUs).
ENV_GET_DB2_SYSTEM_RESOURCES table function - Return database system information
The ENV_GET_DB2_SYSTEM_RESOURCES table function returns CPU usage and database 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 on which the database system runs.
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 database products
The ENV_PROD_INFO administrative view returns information about installed database products.

Parent topic: Supported built-in SQL routines and views