DB2 10.5 for Linux, UNIX, and Windows

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.

The schema is SYSIBMADM.

Authorization

One of the following authorizations is required:

SELECT privilege on the ENV_FEATURE_INFO administrative view
CONTROL privilege on the ENV_FEATURE_INFO administrative view
DATAACCESS authority
DBADM authority
SQLADM authority

Default PUBLIC privilege

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

Example

Request the installed DB2® offerings license information.

  SELECT FEATURE_NAME, FEATURE_FULLNAME, LICENSE_INSTALLED, 
    PRODUCT_NAME, FEATURE_USE_STATUS 
      FROM SYSIBMADM.ENV_FEATURE_INFO

The following is an example of output from this query.

FEATURE_NAME  FEATURE_FULLNAME                                ...
------------  --------------------------------------------    ...
BAF           IBM_DB2_BLU_ACCELERATION_IN_MEMORY_OFFERING     ...
PMF           IBM_DB2_PERFORMANCE_MANAGEMENT_OFFERING         ...
EF            IBM_DB2_ENCRYPTION_OFFERING                     ...
BCF           IBM_DB2_BUSINESS_APPLICATION_CONTINUITY_OFFERING...

Output from this query (continued).

... LICENSE_INSTALLED  PRODUCT_NAME  FEATURE_USE_STATUS
... -----------------  ------------  ------------------
... Y                  ESE           NOT_USED          
... N                  ESE           NOT_USED
... N                  ESE           NOT_USED
... N                  ESE           NOT_USED

ENV_FEATURE_INFO administrative view metadata

Table 1. ENV_FEATURE_INFO administrative view metadata
Column name	Data type	Description
FEATURE_NAME	VARCHAR(26)	Short names for DB2 offerings which are available on licensed DB2 servers.
FEATURE_FULLNAME	VARCHAR(100)	Full name of DB2 offerings. Column values will be displayed in English in uppercase. Words are separated with an underscore character instead of a space character.
LICENSE_INSTALLED	CHAR(1)	Indicates if offering is licensed. If the value is 'N', the offering is not licensed. If the value is 'Y', the offering is licensed.
PRODUCT_NAME	VARCHAR(26)	product_name - Product Name monitor element
FEATURE_USE_STATUS	VARCHAR(30)	Indicates the license compliance status. This value indicates the usage status of the offering. There are three possible values: IN_COMPLIANCE: Offering has been used at least once and there is a valid license for the feature. IN_VIOLATION: Offering has been used at least once and there is no valid license for the feature. NOT_USED: Offering has not been used.