Tech Tip: Checking DB2 LUW License Status

Body

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.

>db2licm -l

Product name: "DB2 Enterprise Server Edition"

License type: "CPU Option"

Expiry date: "Permanent"

Product identifier: "db2ese"

Version information: "9.7"

Enforcement policy: "Soft Stop"

Features:

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.

ENV_FEATURE_INFO

http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/index.jsp?topic=%2…

db2licm

http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/index.jsp?topic=%2Fcom.ibm.db2.luw.admin.cmd.doc%2Fdoc%2Fr0002451.html

For additional information on DB2 LUW Licensing see the License Issues Knowledge Collection at the following URL.

http://www-304.ibm.com/support/docview.wss?rs=71&uid=swg21322757