The ENV_PROD_INFO administrative view returns information about installed DB2® database products.
The schema is SYSIBMADM.
In a non-restrictive database, SELECT privilege is granted to PUBLIC when the view is automatically created.
SELECT * FROM SYSIBMADM.ENV_PROD_INFO
INSTALLED_PROD INSTALLED_PROD_FULLNAME ...
-------------- ------------------------------ ...
ESE DB2_ENTERPRISE_SERVER_EDITION ...
WSE DB2_WORKGROUP_SERVER_EDITION ...
EXP DB2_EXPRESS_EDITION ...
... LICENSE_INSTALLED PROD_RELEASE LICENSE_TYPE
... ----------------- ------------ ----------------------
... Y 9.5 AUTHORIZED_USER_OPTION
... N 9.5 LICENSE_NOT_REGISTERED
... Y 9.5 RESTRICTED
Column name | Data type | Description |
---|---|---|
INSTALLED_PROD | VARCHAR(26) | Identifiers for DB2 products that are installed on the system. |
INSTALLED_PROD_FULLNAME | VARCHAR(100) | Full name of installed DB2 products. Column values will be displayed in English in uppercase. Words are separated with an underscore character. |
LICENSE_INSTALLED | CHAR(1) | Indicates if product is licensed. If the value is N, the product is not licensed. If the value is Y, the product is licensed. For LICENSE_TYPE values TRIAL and LICENSE_NOT_REGISTERED, the value is always N. |
PROD_RELEASE | VARCHAR(26) | Product release number. |
LICENSE_TYPE | VARCHAR(50) | Name of the type of license that
is installed for the product. The possible return values are:
|