• About Dangerous DBA
  • Table of Contents
Dangerous DBA A blog for those DBA's who live on the edge

DB2 Licensing – db2licm

July 5, 2011 4:56 pm / Leave a Comment / dangerousDBA

Back in the day DB2 9.5, IBM introduced data compression. This was the time I was first starting with DB2 having moved job and from SQL server 2000/2005, and nearly straight away I was put on a project to migrate the old DB2 V8.1 Linux machine to V9.5 Unix architecture. Being new and being told my the senior team member to use the wonderful Control Centre, and I noticed in the create table dialog box a lovely little check box that said “Compress Data”. Apparently though this is a paid for extra!!

Obviously this was not something I wanted to fall foul of again, I think having soft licensing is a very bad thing, it is equally an education and knowledge thing that I now know. DB2 soft licensing something you have to be very aware of so you do not fall foul of it to that end you need to get the db2licm command in your servers life!

To this end I have hopefully some useful advice here on using the db2licm command, the full official command can be found here and some more here. So the first one I always use now is:

db2licm -e db2ese HARD

This command above will not let your DB2 enterprise server edition use any features that you have not applied a licence key for, so to apply a licence key:

db2licm -a db2ese.lic

So this will apply your licence file for your DB2 enterprise edition. This can be used with any licensing file you just have to supply the full path to the file, if you are not running the command from where the file is being held. Finally you may want to produce a report to make sure that you are compliant:

db2licm -g db2lic-report.txt

So this will generate a report at the file path specified. You must be a DBA user or have SYSADM. The final command just tells you the version and level of the product that is installed and so is especially useful for servers that you have just taken over or some developer “has set up for you”:

db2licm -l

Hopefully this will have given you a quick overview of the command and what it can do for you and the costs it could save.

Posted in: DB2, DB2 Administration, DB2 Built in commands, DB2 Maintenance, db2licm, IBM

Leave a Reply Cancel reply

Post Navigation

← Previous Post
Next Post →

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 757 other subscribers

Recent Posts

  • Self generating Simple SQL procedures – MySQL
  • Google Cloud Management – My Idea – My White Whale?
  • Position Tracker – The Stub – Pandas:
  • Position Tracker – The Stub
  • Position Tracker – In the beginning
  • Whats been going on in the world of the Dangerous DBA:
  • QCon London Day 1
  • Testing Amazon Redshift: Distribution keys and styles
  • Back to dangerous blogging
  • DB2 10.1 LUW Certification 611 notes 1 : Physical Design

Dangerous Topics

added functionality ADMIN_EST_INLINE_LENGTH Amazon Bootcamp colum convert data types db2 DB2 DB2 Administration DB2 Development db2advis db2licm Decompose XML Exam EXPORT Google IBM IBM DB2 LUW idug information centre infosphere LOAD merry christmas and a happy new year Recursive Query Recursive SQL Redshift Reorganisation Reorganise Reorganise Indexes Reorganise Tables Runstats sqlcode sql statement Stored Procedures SYSPROC.ADMIN_CMD Time UDF User Defined Functions V9.7 V10.1 Varchar XML XML PATH XMLTABLE

DangerousDBA Links

  • DB2 for WebSphere Commerce
  • My Personal Blog

Disclaimer:

The posts here represent my personal views and not those of my employer. Any technical advice or instructions are based on my own personal knowledge and experience, and should only be followed by an expert after a careful analysis. Please test any actions before performing them in a critical or nonrecoverable environment. Any actions taken based on my experiences should be done with extreme caution. I am not responsible for any adverse results. DB2 is a trademark of IBM. I am not an employee or representative of IBM.

Advertising

© Copyright 2021 - Dangerous DBA
Infinity Theme by DesignCoral / WordPress