This query returns installed product edition of IBM Db2 instance. Use it to determine the features and its limitations.
select installed_prod_fullname as installed_product_name, prod_release as product_release, license_installed, license_type from sysibmadm.env_prod_info
- installed_product_name - name of installed DB2 products
- product_release - product release
- license_installed - indicates if product is licensed (Y/N)
- license_type - type of license
Query returns just one row