How to check IBM Db2 edition

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

0
There are no comments. Click here to write the first comment.