Troubleshooting
Problem
The db2licm -l output shows a DB2 Connect trial license when the installed product is not DB2 Connect. This trial license can only be removed before it expires.
Symptom
The db2licm -l output will show a trial DB2 Connect license even though DB2 Connect was not installed. Attempts to remove the license after the expiry date will result in a a LIC1417N error .
Cause
In addition to the product license DB2 servers install a DB2 Connect trial license.
Diagnosing The Problem
Confirm that DB2 Connect is not the server product installed by checking the sqllib/cfg directory for a file that starts with "db2con" and has a ".lvl" extension. If this file is not present then the DB2 Connect product is not installed. If DB2 Connect is the product installed it will be necessary to obtain a license or remove the product. If DB2 Connect is not installed and an entry for DB2 Connect returns from the db2licm -l command you have encountered this issue.
Resolving The Problem
The license can be removed prior to its expiration date by issuing the command db2licm -r <Product identifier> (the <Product identifier> is provided in the db2licm -l output).
Once expired the trial license can be removed either by setting the system date to a time before the trial license expired and issuing the db2licm -r command, or by renaming the nodelock file and installing the base product and the permanent license again.
Please be sure that you have both the base and permanent license files (both filenames end in .lic) prior to renaming the nodelock file. Permanent DB2 licenses are available on Passport Advantage (PPA) as Quick Start and Activation Kits. There is a technote which documents how to locate and download the appropriate Quick Start and Activation Kit (A link to this license technote is located in the Related URL section of this technote). The base license file is located in the db2/license directory in the original installation image.
The location of the nodelock file depends on the OS being used with DB2. On Unix systems it is located in the /opt/ibm/db2/<DB2 copy name>/license directory
On Windows systems running Windows 2008 or 7 the file can be found in the C:\Program Data\<DB2 copy name>\license directory. On Windows XP systems its located in the C: \Documents and Settings\All Users\Application Data\IBM\DB2\<DB2 copy name>\license directory.
Note: The "Program Data" and "Application Data" folders are hidden by default on Windows Systems.
Once the nodelock file is renamed, you can re-install the base and authorized licenses by issuing the db2licm -a command. For example if the product installed is DB2 ESE and it is licensed with the cpu option, then after renaming the nodelock file issue the following commands
db2licm -a db2ese.lic
A LIC1448I message may return after the above command is run. This message is warning that the license being installed is not permanent and can be ignored.
db2licm -a db2ese_c.lic
The above commands assume that both the db2ese.lic and the db2ese_c.lic files are located in the current directory if the files are not in the current directory it will be necessary to specify their absolute paths. After the commands are run the db2licm -l ouput should be similar to the following.
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"
Related Information
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21615643