Tech Tip: Checking DB2 LUW License Status
gorddbds 060001JCXS Visits (5557)
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
Below is an example of the ENV_FEATURE_INFO output.
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.