|
Problem IC66385
|
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 / 970 - 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: *
* 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: |
|
| available fix packs: |
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
|
| Solution |
db2_v97fp2 and db2_v98fp3 contains fix of this issue. |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC66589
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 16.02.2010
14.05.2010
14.05.2010 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.2
|
 |
