DB2 FOR LUW / DB2FORLUW / 950 - DB2

CLP may cause access violation if all the following conditions 
are met: 
 
- The statement is greater than 128KB. 
- The statement contains line feed. 
- db2.exe is running on Windows platforms. 
- DB2 V9.5 FP6 or later. 
 
Stack trace generated by db2.exe is like as follows: 
 
db2clpfp!clp_replace_LFtoCRLF 
db2clpfp!clp_print_output 
db2clpfp!clp_execmd 
db2clpfp!clp_execinp 
db2clpfp!clp_fp_con 
db2clpfp!clp_api 
db2!main 
 
The following steps illustrate how the problem occurs. 
 
1. Create a CLP script like as below: 
 
p1.sql 
------------------------------------------ 
create procedure proc1 (in input1 integer) 
result sets 1 
language sql 
begin 
  declare c1 int default 1; 
  declare c2 int default 0; 
  set c2 = c2 + c1; 
       : -- repeat 6300 lines 
  set c2 = c2 + c1; 
end 
@ 
------------------------------------------ 
 
2. Run the script with -v option 
C:\>db2 -td@ -vf p1.sql

**************************************************************** 
* USERS AFFECTED:                                              * 
* Users who use CLP on Windows platforms.                      * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* CLP may cause access violation if all the following          * 
* conditions are met:                                          * 
*                                                              * 
* - The statement is greater than 128KB.                       * 
* - The statement contains line feed.                          * 
* - db2.exe is running on Windows platforms.                   * 
* - DB2 V9.5 FP6 or later.                                     * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Please upgrade to V9.5 FixPack 8 or later.                   * 
****************************************************************

Please remove -v option.

DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
 DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows
 

This problem is first fixed in DB2 V9.5 FixPack 8.

keiner bekannt / siehe Local-Fix

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

11.03.2011
05.07.2011
05.07.2011

9.5.FP8