DB2 FOR LUW / DB2FORLUW / 970 - 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 9.7 Fix Pack 10.                      * 
****************************************************************

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

First fixed in Version 9.7 Fix Pack 10.

keiner bekannt / siehe Local-Fix

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

25.11.2013
08.12.2014
08.12.2014

9.7.FP10