home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IC66589 Status: Geschlossen

WHEN EXPLAIN MODE IS SET AND SERVEROUTPUT ON,ALL COMMANDS INCLUD ING SET
CURRENT EXPLAIN MODE USING CLP RESULTS IN ENDLESS LOOP

Produkt:
DB2 FOR LUW / DB2FORLUW / 980 - DB2
Problembeschreibung:
Setting the environment variable SERVEROUTPUT to ON, and then 
setting the explain mode to expalin will cause an endless loop 
of newlines. 
 
Reproduction: 
 
db2 set serveroutput on 
db2 set current explain mode explain 
The moment  the above is executed, the screen will go into an 
endless loop. 
Transaction log becomes full 
Nothing will run for the session 
CTRL C will stop the loop
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* CLP users                                                    * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* Setting the environment variable SERVEROUTPUT to ON, and     * 
* then                                                         * 
* setting the explain mode to expalin will cause an endless    * 
* loop                                                         * 
* of newlines.                                                 * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to v98fp3                                            * 
****************************************************************
Local-Fix:
verfügbare FixPacks:
DB2 Version 9.8 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.8 Fix Pack 4 for AIX and Linux
DB2 Version 9.8 Fix Pack 5 for AIX and Linux

Lösung
Problem fixed in v97fp2 and v98fp3
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
23.02.2010
17.01.2011
17.01.2011
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.FP2,
9.8.FP3
Problem behoben lt. FixList in der Version
9.8.0.3 FixList