Technical Blog Post
Tech Tip: Checking DB2 LUW License Status
DB2 LUW provides two ways of determining if you are using the product according to the licenses you have installed. One is the dblicm tool the other is the ENV_FEATURE_INFO administrative view. The db2licm -l command lists the product and feature licenses installed for each DB2 product at the same build level as the instance the command was run under. For example the following is db2licm -l output from a DB2 version 9.7 ESE instance.
Product name: "DB2 Enterprise Server Edition"
License type: "CPU Option"
Expiry date: "Permanent"
Product identifier: "db2ese"
Version information: "9.7"
Enforcement policy: "Soft Stop"
DB2 Performance Optimization ESE: "Not licensed"
DB2 Storage Optimization: "Licensed"
DB2 Advanced Access Control: "Not licensed"
DB2 Geodetic Data Management: "Not licensed"
IBM Homogeneous Replication ESE: "Not licensed"
The db2licm -g <filename> command will generate a compliance report containing the products installed, the features available for the products and their usage status. The following is an example of the file created by db2licm -g command.
License Compliance Report
DB2 Enterprise Server Edition In compliance
DB2 Database Partitioning: "Not used"
DB2 Performance Optimization ESE: "Not used"
DB2 Storage Optimization: "In compliance"
DB2 Advanced Access Control: "Not used"
DB2 Geodetic Data Management: "Not used"
IBM Homogeneous Replication ESE: "Not used"
The ENV_FEATURE_INFO administrative view returns information similar to the db2licm -g command. To use the administrative view connect to a database and run the following query.
SELECT * FROM SYSIBMADM.ENV_FEATURE_INFO
Below is an example of the ENV_FEATURE_INFO output.
FEATURE_NAME FEATURE_FULLNAME LICENSE_INSTALLED PRODUCT_NAME FEATURE_USE_STATUS
------------- --------------------------------------------- ----------------- ------------- -------------------
DPF DB2_DATABASE_PARTITIONING_FEATURE N ESE NOT_USED
POESE DB2_PERFORMANCE_OPTIMIZATION_FEATURE_FOR_ESE N ESE NOT_USED
SO DB2_STORAGE_OPTIMIZATION_FEATURE Y ESE IN_COMPLIANCE
AAC DB2_ADVANCED_ACCESS_CONTROL_FEATURE N ESE NOT_USED
GEO DB2_GEODETIC_DATA_MANAGEMENT_FEATURE N ESE NOT_USED
HRESE IBM_HOMOGENEOUS_REPLICATION_FEATURE_FOR_ESE N ESE NOT_USED
In the examples, both the db2licm and ENV_FEATURE_INFO output indicate that the DB2 Storage Optimization feature has been used and is licensed. If a feature had been used at least once but not licensed the output would show its status as “In violation”. Features that have not been used will have a status of "Not used".
Further information on the ENV_FEATURE_INFO administrative view and the db2licm command can be found at the following URL.
For additional information on DB2 LUW Licensing see the License Issues Knowledge Collection at the following URL.