DB2 10.1 Express C - How to fix your expired license

DB2 10.1 Express C - free to download, deploy and use is an ultimate  database server if you want to spend some time learning DB2, try the  windows 64 bit version available for free download here.

The software is free for a life time as said in the website, but there are situations you face when anything can go wrong, even the licensing

db2 => start dbm
SQL8000N DB2START processing failed; a valid product license was not found. If you have licensed this product, ensure the license key is properly registered. You can register the license using the db2licm command. The license key can be obtained from your licensed product CD

As seen above, the error clearly states that, a valid product license was not found. Now all the while for over 2 months this worked perfectly fine. All of a sudden the start database manager command wouldn't work. I did have a word with my buds regarding this and this could have possible happened due to a packaging issue with the software when it was hosted on the web ; ready for download. 

To confirm the license has expired I issued the following command : 

C:\Program Files\IBM\SQLLIB\BIN>db2licm -l
Product name:                     "DB2 Express-C"
License type:                     "Unwarranted"
Expiry date:                      
“expired"
Product identifier:               "db2expc"
Version information:              
"10.1"
Max number of CPUs:               "2"
Max amount of memory (GB):        "16"
Enforcement policy:               "Soft Stop"
How do you go about fixing this ?

With a lot of reading and surfing the web day in an day out I found that under the C:\Program Files\IBM\SQLLIB\BIN folder there exists a hidden folder by the name .licbkp 

Now if we open the folder ( after enabling view hidden folders from the control panel ) we will notice a file by the name : lic00000001.lic

This is your license file, simply copy it to this location C:\Program Files\IBM\SQLLIB\BIN and issue the following command to bring DB2 back to life : db2licm –a \lic00000001.lic

C:\Program Files\IBM\SQLLIB\BIN>db2licm -a \lic00000001.lic

LIC1408N  The file "C:\lic00000001.lic" could not be opened. Enter the name of a file that exists and can be opened and try the command again.

Copied the license file to C:\ and tried again, it is easy this way for me as I now know where my license file resides, you can specify the direct path on the db2licm command too

C:\Program Files\IBM\SQLLIB\BIN>db2licm -a \lic00000001.lic

LIC1402I  License added successfully.

LIC1426I  This product is now licensed for use as outlined in your License Agreement.  USE OF THE PRODUCT CONSTITUTES ACCEPTANCE OF THE TERMS OF THE IBM LICENSE AGREEMENT, LOCATED IN THE FOLLOWING DIRECTORY: "C:\PROGRA~1\IBM\SQLLIB\license\en"

Please note that this location may vary if you are on a different version on windows, I was on windows 7 when I got this error.

Issue the db2licm - l command again :

C:\Program Files\IBM\SQLLIB\BIN>db2licm -l
Product name:                     "DB2 Express-C"
License type:                     "Unwarranted"
Expiry date:                      
"Permanent"
Product identifier:               "db2expc"
Version information:              
"10.1"
Max number of CPUs:               "2"
Max amount of memory (GB):        "16"
Enforcement policy:               "Soft Stop"



3 comments:

  1. Where to find this file under DB2 version V9.7 linux install/

    ReplyDelete
    Replies
    1. Not so great with Linux - You might want to search or post your question on the IBM developer work forums..

      Or may be this link below can guide you - good luck !

      https://www-01.ibm.com/support/knowledgecenter/SSEPGG_9.7.0/com.ibm.db2.luw.qb.server.doc/doc/r0006748.html

      Delete
  2. All About Data And Databases: Db2 10.1 Express C - How To Fix Your Expired License >>>>> Download Now

    >>>>> Download Full

    All About Data And Databases: Db2 10.1 Express C - How To Fix Your Expired License >>>>> Download LINK

    >>>>> Download Now

    All About Data And Databases: Db2 10.1 Express C - How To Fix Your Expired License >>>>> Download Full

    >>>>> Download LINK N7

    ReplyDelete