DB2 Version 9.7 for Linux, UNIX, and Windows

ENV_FEATURE_INFO administrative view - Return license information for DB2 features

The ENV_FEATURE_INFO administrative view returns information about all available features for which a license is required. For each feature, there is information about whether or not a valid license for the feature 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

Example

Request the installed DB2® features license information.

  SELECT * FROM SYSIBMADM.ENV_FEATURE_INFO

The following example is a sample output from this query.

FEATURE_NAME  FEATURE_FULLNAME                              ...
------------  --------------------------------------------  ...
DPF           DB2_DATABASE_PARTITIONING_FEATURE             ...
POESE         DB2_PERFORMANCE_OPTIMIZATION_FEATURE_FOR_ESE  ...
SO            DB2_STORAGE_OPTIMIZATION_FEATURE              ...
AAC           DB2_ADVANCED_ACCESS_CONTROL_FEATURE           ...
GEO           DB2_GEODETIC_DATA_MANAGEMENT_FEATURE          ...
HFESE         IBM_HOMOGENEOUS_FEDERATION_FEATURE_FOR_ESE    ...
XMLESE        DB2_PUREXML_FEATURE_FOR_ESE                   ...

Output from this query (continued).

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

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 features which are available on licensed DB2 servers.
FEATURE_FULLNAME	VARCHAR(100)	Full name of DB2 features. 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 feature is licensed. If the value is 'N', the feature is not licensed. If the value is 'Y', the feature is licensed.
PRODUCT_NAME	VARCHAR(26)	Identifiers for DB2 server product on which the feature is available. The possible return values are: ESE - DB2 Enterprise Server Edition WSE - DB2 Workgroup Server Edition EXP - DB2 Express® Edition
FEATURE_USE_STATUS	VARCHAR(30)	Indicates the license compliance status. This value indicates the usage status of the feature. There are three possible values: IN_COMPLIANCE: Feature has been used at least once and there is a valid license for the feature. IN_VIOLATION: Feature has been used at least once and there is no valid license for the feature. NOT_USED: Feature has not been used.