DB2 FOR LUW / DB2FORLUW / 950 - DB2

SYSIBMADM.ENV_PROD_INFO display incorrect values after applying 
user licenses by the db2licm command. 
 
Steps for recreation: 
1) Install a fresh DB2 copy 
2) db2sampl 
3) db2licm -a <licfile> 
4) db2 select * from SYSIBM.ENV_PROD_INFO 
 
Result with DB2 9.5: 
 
********************************************** 
 
 
 
INSTALLED_PROD             INSTALLED_PROD_FULLNAME 
LICENSE_INSTALLED PROD_RELEASE LICENSE_TYPE 
 
-------------------------- ----------------------------- 
----------------- ------------ ------------ 
ESE                        DB2_ENTERPRISE_SERVER_EDITION 
        N          9.5 AUTHORIZED_USER_OPTION 
********************************************** 
 
The above value for LICENSE_INSTALLED is N and it should be Y. 
(first after the instance restart the result is correct)

**************************************************************** 
* USERS AFFECTED:                                              * 
* All Platforms                                                * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* SYSIBMADM.ENV_PROD_INFO SQL QUERY DISPLAY INCORRECT VALUES   * 
* AFTER                                                        * 
* APPLYING USER LICENSE BY USING DB2LICM                       * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to to DB2 v9.5 Fixpack 9                             * 
****************************************************************

Restart of the instance resolve the output.

DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows
 

First Fixed in DB2 v9.5 Fixpack 9

keiner bekannt / siehe Local-Fix

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

17.05.2011
08.03.2012
08.03.2012

9.5.FP9