ENV_PROD_INFO administrative view - Retrieve information about installed database products

The ENV_PROD_INFO administrative view returns information about installed database products.

The schema is SYSIBMADM.

Authorization

One of the following authorizations is required:

SELECT privilege on the ENV_PROD_INFO administrative view
CONTROL privilege on the ENV_PROD_INFO administrative view
DATAACCESS authority
DBADM authority
SQLADM authority
ACCESSCTRL authority
SECADM 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 database product information.

SELECT * FROM SYSIBMADM.ENV_PROD_INFO

The following is an example of output from this query.

INSTALLED_PROD  INSTALLED_PROD_FULLNAME        ...
--------------  ------------------------------ ...
ESE             DB2_ENTERPRISE_SERVER_EDITION  ...
WSE             DB2_WORKGROUP_SERVER_EDITION   ...
EXP             DB2_EXPRESS_EDITION            ...

Output from this query (continued).

... LICENSE_INSTALLED  PROD_RELEASE  LICENSE_TYPE
... -----------------  ------------  -------------------------------------
... Y                  12.1          AUTHORIZED_USER_SINGLE_INSTALL_OPTION 
... N                  12.1          LICENSE_NOT_REGISTERED 
... Y                  12.1          RESTRICTED

ENV_PROD_INFO administrative view metadata

Table 1. ENV_PROD_INFO administrative view metadata
Column name	Data type	Description
INSTALLED_PROD	VARCHAR(26)	Identifiers for database products that are installed on the system.
INSTALLED_PROD_FULLNAME	VARCHAR(100)	Full name of installed database 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: 12_MONTHS_LICENSE_AND_SUBSCRIPTION AUTHORIZED_USER AUTHORIZED_USER_SINGLE_INSTALL_OPTION CLIENT_DEVICE CPU CPU_OPTION HOST_SERVER_AND_MSU LICENSE_NOT_REGISTERED MANAGED_PROCESSOR N/A RESTRICTED TRIAL UNWARRANTED USER