home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IT01233 Status: Geschlossen

DB2CLI EXECUTABLE HANGS WHILE USING -EXECSQL OPTION WITH A STMT IN THE FILE
WHOSE LENGTH EXCEEDS 64k

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
db2cli executable hangs while using -execsql option and when the 
size of the SQL statement in the file passed to -execsql is 
greater than 64k. 
 
db2cli enters an infinite loop due to incorrect handling of the 
negative error scenario as currently there is no proper 
validation of the statement length. 
with this fix, the limitation of the stmt would be lifted and we 
would support 2MB (sql standard) limit for the sql.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Update to v9.7fp10 or above                                  * 
****************************************************************
Local-Fix:
Use db2 -tvf <file with statement> in order to execute the 
statement over 64K in size.
Lösung
First fixed in v9.7fp10
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
23.04.2014
15.12.2014
15.12.2014
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.FP10
Problem behoben lt. FixList in der Version
9.7.0.10 FixList