This query returns installed product edition of IBM Db2 instance. Use it to determine the features and its limitations.

Query

select installed_prod_fullname as installed_product_name,
    prod_release as product_release,
    license_installed,
    license_type
from sysibmadm.env_prod_info

Columns

• 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
  • 12_MONTHS_LICENSE_AND_SUBSCRIPTION
  • AUTHORIZED_USER
  • AUTHORIZED_USER_OPTION
  • CLIENT_DEVICE
  • CPU
  • CPU_OPTION
  • HOST_SERVER_AND_MSU
  • LICENSE_NOT_REGISTERED
  • MANAGED_PROCESSOR
  • N/A
  • RESTRICTED
  • TRIAL
  • UNWARRANTED
  • USER

Rows

Query returns just one row

Sample results