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 |