DBAs have to comply with the licensing requirements for DB2. As a DBA, how do you know if you are using a particular feature of DB2 or not? I wrote about this long time back at here.
In addition to above, you can also use this SYSIBMADM view to find out if you are using a particular feature of DB2 or not.
SELECT SUBSTR(FEATURE_NAME, 1, 10) AS "FEATURE", SUBSTR(FEATURE_FULLNAME, 1, 35) AS "FEATURE_NAME", LICENSE_INSTALLED AS "LIC", SUBSTR(PRODUCT_NAME, 1, 5) AS "PRODUCT", SUBSTR(FEATURE_USE_STATUS, 1, 15) AS "USE_STATUS" FROM SYSIBMADM.ENV_FEATURE_INFO ORDER BY 1;
A sample output will look like following:
FEATURE FEATURE_NAME LIC PRODUCT USE_STATUS ---------- ----------------------------------- --- ------- --------------- AAC DB2_ADVANCED_ACCESS_CONTROL_FEATURE Y ESE NOT_USED DPF DB2_DATABASE_PARTITIONING_FEATURE Y ESE NOT_USED GEO DB2_GEODETIC_DATA_MANAGEMENT_FEATUR Y ESE NOT_USED HFESE IBM_HOMOGENEOUS_FEDERATION_FEATURE_ Y ESE NOT_USED HRESE IBM_HOMOGENEOUS_REPLICATION_FEATURE Y ESE NOT_USED POESE DB2_PERFORMANCE_OPTIMIZATION_FEATUR Y ESE NOT_USED SO DB2_STORAGE_OPTIMIZATION_FEATURE Y ESE NOT_USED XMLESE DB2_PUREXML_FEATURE_FOR_ESE Y ESE NOT_USED