DB2 - Problembeschreibung
Problem IT03395 | Status: Geschlossen |
A newline character in DB2ENVLIST will result in an infinite loop when accessed by the REG_VARIABLES view causing high cpu. | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 | |
Problembeschreibung: | |
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-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Update to version 10.1 fixpack 5 * **************************************************************** | |
Local-Fix: | |
Remove the newline character from DB2ENVLIST. Use a space character to separate values as per the documentation. | |
Lösung | |
First fixed in version 10.1 fixpack 5. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 25.07.2014 20.07.2015 20.07.2015 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
10.1.0.5 |