DB2 FOR LUW / DB2FORLUW / B10 - DB2

The values set to REG_VAR_DEFAULT_VALUE returned by 
ENV_GET_REG_VARIABLES table function for DB2CHGPWD_EEE 
and DB2LOGINRESTRICTIONS registry variables are incorrect. 
 
1. 
The default value for DB2CHGPWD_EEE should be NULL. 
However, the value returned by ENV_GET_REG_VARIABLES is 'DB2'. 
 
Example: 
$ db2 "select substr(REG_VAR_NAME, 1, 40) as REG_VAR_NAME, 
substr(REG_VAR_DEFAULT_VALUE, 1, 20) as REG_VAR_DEFAULT_VALUE 
from table (ENV_GET_REG_VARIABLES (-2,1)) where REG_VAR_NAME = 
'DB2CHGPWD_EEE'" 
 
REG_VAR_NAME                             REG_VAR_DEFAULT_VALUE 
---------------------------------------- --------------------- 
DB2CHGPWD_EEE                            DB2 
 
  1 record(s) selected. 
 
2. 
The default value for DB2LOGINRESTRICTIONS should be 'LOCAL'. 
However, the value returned by ENV_GET_REG_VARIABLES is NULL. 
 
Example: 
$ db2 "select substr(REG_VAR_NAME, 1, 40) as REG_VAR_NAME, 
substr(REG_VAR_DEFAULT_VALUE, 1, 20) as REG_VAR_DEFAULT_VALUE 
from table (ENV_GET_REG_VARIABLES (-2,1)) where REG_VAR_NAME = 
'DB2LOGINRESTRICTIONS'" 
 
REG_VAR_NAME                             REG_VAR_DEFAULT_VALUE 
---------------------------------------- --------------------- 
DB2LOGINRESTRICTIONS                     - 
 
  1 record(s) selected.

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 11.1 Mod 2 Fix Pack 2 or higher               * 
****************************************************************

DB2 Version 11.1 Mod 2 Fix Pack 2 for Linux, UNIX, and Windows
 Db2 Version 11.1 Mod2 Fix Pack2 iFix001 for Linux, UNIX, and Windows
 Db2 Version 11.1 Mod2 Fix Pack2 iFix002 for Linux, UNIX, and Windows
 Db2 Version 11.1 Mod 3 Fix Pack 3 for Linux, UNIX, and Windows
 Db2 Version 11.1 Mod3 Fix Pack3 iFix001 for Linux, UNIX, and Windows
 Db2 Version 11.1 Mod3 Fix Pack3 iFix002 for Linux, UNIX, and Windows
 

First fixed in DB2 11.1 Mod 2 Fix Pack 2

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

21.02.2017
23.06.2017
23.06.2017