DB2 FOR LUW / DB2FORLUW / A50 - DB2

When the value of DB2ENVLIST contains a newline character the 
processing 
of it for the REG_VARIABLES view will enter a infinite loop 
driving up 
CPU usage for the db2fmp process handling the request. 
 
As it is an infinite loop, the accessing statement will never 
complete 
and will have to be interrupted. The db2fmp process will need to 
be 
identified and terminated using db2fmpterm <process-ID>. 
 
For example, executing: 
 
SELECT * FROM SYSIBMADM.REG_VARIABLES 
 
With: 
 
$ db2set -all 
[e] DB2ENVLIST=VAR_A 
VAR_B 
[i] DB2COMM=tcpip 
... 
 
active at the time the instance was started, will result in this 
issue.

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 10.5 Fix Pack 5.                      * 
****************************************************************

Remove the newline character from DB2ENVLIST. Use a space 
character to 
separate values as per the documentation.

First fixed in Version 10.5 Fix Pack 4.

not known / see Local fix

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

25.07.2014
15.03.2015
15.03.2015