|
Problem IC97941
|
Status: Closed |
A newline character in DB2ENVLIST will result in an infinite loop when accessed by the REG_VARIABLES view causing high cpu. |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
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. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 Version 9.7 Fix Pack 10. *
**************************************************************** |
| Local Fix: |
Remove the newline character from DB2ENVLIST. Use a space
character to
separate values as per the documentation. |
| Solution |
First fixed in Version 9.7 Fix Pack 10. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 25.11.2013
08.12.2014
08.12.2014 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP10
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.10
|
 |
