|
Problem IC76442
|
Status: Closed |
SYSIBMADM.ENV_PROD_INFO SQL QUERY DISPLAY INCORRECT VALUES AFTER APPLYING USER LICENSE BY USING DB2LICM |
| product: |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 |
| Problem description: |
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) |
| Problem Summary: |
****************************************************************
* 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 *
**************************************************************** |
| Local Fix: |
Restart of the instance resolve the output. |
| available fix packs: |
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
First Fixed in DB2 v9.5 Fixpack 9 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 17.05.2011
08.03.2012
08.03.2012 |
| Problem solved at the following versions (IBM BugInfos) |
9.5.FP9
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.5.0.9
|
 |
