SAP DB2 License Issue or db2 service not starting in db2diag.log

DB2 License Issue

In DB2 , the SAP OEM license has to be applied after 90 days. If you don't apply then the database won't start. The procedure is different from Oracle as you need to log into the DB2 CLP to apply the license. Please find below the procedure:

Windows:

1. Login as db2<SID>
2.Go to Start -> All Programs ->IBM DB2 -> SAPDB2SOL -> Command Line Tools -> Command Window
3. Now apply license here as per SAP Note 816773.Even with db2cmd we were not getting the actual license status.

Db2

Solaris / SOLARIS  /Unix

Updating the DB2 product license key

This task is part of the main task of Setting up a DB2 server after manual installation.

Updating the DB2 product license key is done by running the db2licm command and specifying the license file name for your DB2 product.

You must install a license key on each computer where DB2 is installed.

Procedure

To update your DB2 product license key using root authority:

1. Log in db2<SID>.
2. Update the DB2 product license key with the appropriate command:

License files Copy to  /tmp location

3.  #cd /tmp/licensefiles

4.  #db2licm

It will show License expired or not.

5.  #db2licm -a filename  on SOLARIS

6.  #db2licm -a filename  for all

7.   other UNIX-based operating systems

where filename is the full pathname and filename for the license file that corresponds to the product you have purchased. The license file is located in the /db2/license directory located at the root of your CD-ROM.

For example, on SOLARIS , if the CD-ROM is mounted in the /cdrom directory and the name of the license file is db2dlm.lic, the command should be as follows:

     /usr/opt/db2_09_07/adm/db2licm -a /cdrom/db2/license/db2dlm.lic

The DB2 product license key exists in the following directories dependent on platform:

• For SOLARIS , the product license keys are located in /var/ifor.
• For HP-UX, the product license keys are located in /var/lum.
• For the Solaris operating environment, the product license keys are located in /var/lum.
• For Linux, the product license keys are located in /var/lum.

To update your DB2 product license key as the instance owner:

1. Create the instance environment and become the instance owner.
2. Update your DB2 product license with the appropriate command:
1. On SOLARIS  enter:

b.       /usr/opt/db2_09_07/adm/db2licm -a filename

3. On all other UNIX-based operating systems enter:

3.        /opt/IBM/db2/V8.1/adm/db2licm -a filename

Regards,

Alihamed.sa,

Basis Administrator.