|
Problem IT01233
|
Status: Closed |
DB2CLI EXECUTABLE HANGS WHILE USING -EXECSQL OPTION WITH A STMT IN THE FILE WHOSE LENGTH EXCEEDS 64k |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
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 Summary: |
****************************************************************
* 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. |
| Solution |
First fixed in v9.7fp10 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 23.04.2014
15.12.2014
15.12.2014 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP10
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.10
|
 |
