IBM Support

DB2 License compliance report returns a VIOLATION status against a certain feature

Troubleshooting


Problem

When "db2licm" is used to generate a compliance report, it shows "Violation" against a certain feature. This indicates that the feature is not licensed, but has been used.

Symptom

This can be demonstrated with the help of the following example. The following db2licm command would return the compliance information,

db2licm -g /tmp/report.out ; cat /tmp/report.out


LIC1440I License compliance report generated successfully.


License Compliance Report

DB2 Enterprise Server Edition In compliance

DB2 Database Partitioning: "Not used"
DB2 Performance Optimization ESE: "Not used"
DB2 Storage Optimization: "Violation"
DB2 Advanced Access Control: "Not used"
DB2 Geodetic Data Management: "Not used"
IBM Homogeneous Replication ESE: "Not used"

So the DB2 Storage Optimization feature is in "VIOLATION"

Diagnosing The Problem

The problem can be diagnosed as follows:

1)

The output of "db2licm -l" should be checked to confirm if the use of the feature in "violation" is entitled to be used. If it returns an an output, similar to the following,



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: "Not licensed"
DB2 Advanced Access Control: "Not licensed"
DB2 Geodetic Data Management: "Not licensed"
IBM Homogeneous Replication ESE: "Not licensed"

It would mean that the license for the feature in "Violation" has not been applied.

2)

The following link should be checked, and the queries pertaining to the feature in "Violation" should be executed


http://www-01.ibm.com/support/knowledgecenter/SSEPGG_9.7.0/com.ibm.db2.luw.admin.trb.doc/doc/t0053718.html

Considering the example above, the following queries can be executed to check if "DB2 Storage Optimization" is being used or not,

SELECT TABSCHEMA, TABNAME
FROM SYSCAT.TABLES
WHERE COMPRESSION IN ('R', 'B')

SELECT TABSCHEMA, TABNAME, INDNAME, COMPRESSION
FROM SYSCAT.INDEXES
WHERE COMPRESSION = 'Y'

SELECT TABSCHEMA, TABNAME
FROM SYSIBMADM.ADMINTABINFO
WHERE DICTIONARY_SIZE <> 0 OR XML_DICTIONARY_SIZE <> 0

Resolving The Problem

If the "select" queries mentioned above returns 0 records, then the following command should be tried out to reset the license compliance information,

"db2licm -x"

The license compliance report can be re generated after resetting the compliance information, and if it still shows the same feature in Violation, DB2 Technical Support should be engaged.

Related Information

[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Install\/Migrate\/Upgrade - Licensing","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"9.7;10.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 June 2018

UID

swg21700656