|
Problem IC66385
|
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 / 970 - 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: *
* Setting the environment variable SERVEROUTPUT to ON, and *
* then setting the explain mode to expalin will cause an *
* endless loop of newlines. It could happen with all db2 *
* 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. *
* *
* *
* *
* 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 *
****************************************************************
* RECOMMENDATION: *
* Upgrade to db2_v97fp2. *
**************************************************************** |
| Local-Fix: |
|
| verfügbare FixPacks: |
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Lösung |
db2_v97fp2 and db2_v98fp3 contains fix of this issue. |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Bug-Verfolgung |
Vorgänger : APAR is sysrouted TO one or more of the following: IC66589
Nachfolger : |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 16.02.2010
14.05.2010
14.05.2010 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
|
| Problem behoben lt. FixList in der Version |
| 9.7.0.2
|
 |
