DB2 FOR LUW / DB2FORLUW / 970 - DB2

This is an issue in CLPPlus where it is not flushing the 
messages after writing it on to the console. 
 
For example, the following code 
---------- 
SQL> set serveroutput on 
SQL> begin 
2 for i in 1..30 loop 
3 dbms_output.put_line('Count '||i); 
4 end loop; 
5 end; 
6 / 
---------- 
 
Gives the following output: 
---------- 
Count 1 
<snip> 
Count 25 
Count 1 
<snip> 
Count 25 
Count 27 
Count 28 
Count 29 
Count 30 
DB250000I: The command completed successfully. 
SQL> 
---------- 
i.e. We see the first 25 lines duplicated. 
 
The reason for this is, CLPPlus fetches server output messages 
in a chunk of 25 at a time. After each fetch CLPPlus is supposed 
to clear the list of messages which are already displayed on the 
screen, but it fails to do so, hence we see the duplicate 
messages on screen after every fetch. 
 
N.B. The above example also shows APAR IC82246: Consecutive 
calls to DBMS_OUTPUT.GET_LINES() skips a line in between each 
call, since CLPPlus depends on DBMS_OUTPUT.GET_LINES procedure 
to retrieve the server output messages from buffer.

**************************************************************** 
* USERS AFFECTED:                                              * 
* Users using CLPPlus                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 v9.7 Fixpack 7                                * 
****************************************************************

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 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

First fixed in DB2 v9.7 Fixpack 7

not known / see Local fix

forerunner  : APAR is sysrouted TO one or more of the following: IC85280 IC87911 
follow-up : 

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

28.03.2012
26.11.2012
26.11.2012

9.7.FP7