|
Problem IC66589
|
Status: Closed |
WHEN EXPLAIN MODE IS SET AND SERVEROUTPUT ON,ALL COMMANDS INCLUD ING SET CURRENT EXPLAIN MODE USING CLP RESULTS IN ENDLESS LOOP |
| product: |
DB2 FOR LUW / DB2FORLUW / 980 - DB2 |
| 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 |
| Problem Summary: |
****************************************************************
* 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: |
|
| available fix packs: |
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
|
| Solution |
Problem fixed in v97fp2 and v98fp3 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 23.02.2010
17.01.2011
17.01.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP2,
9.8.FP3
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.8.0.3
|
 |
