|
Problem IC74978
|
Status: Geschlossen |
CLP WITH -V OPTION MAY CAUSE ACCESS VIOLATION IF STATEMENT > 128KB AND CONTAINS LINE FEED. |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 |
| Problembeschreibung: |
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 |
| Problem-Zusammenfassung: |
****************************************************************
* 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. *
**************************************************************** |
| Local-Fix: |
Please remove -v option. |
| verfügbare FixPacks: |
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
|
| Lösung |
This problem is first fixed in DB2 V9.5 FixPack 8. |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 11.03.2011
05.07.2011
05.07.2011 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.5.FP8
|
| Problem behoben lt. FixList in der Version |
| 9.5.0.8
|
 |
