|
Problem IC62114
|
Status: Closed |
BATCH PARAMETRIZED INSERT FAILED TO INSERT MORE THAN 32767 BOUND |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
When you try to insert via DB2 OLEDB more than 32767 bound
parameters with insert statements, a catastrophic failure
occurs.
This limitation is due to the usage of a short integer which has
a max value of 32767. DB2 is not able to allocate memory after
this maximum value is reached.
For example, a parameterized insert sql statement with more than
8191 statements in which each statement has got 4 parameters
will reach this limit ( 8191 *4 = 32764).
This limitation is removed from DB2 V95fp5 and more than 32767
parameters can be inserted with this fix pack release. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Windows - DB2 OLEDB *
****************************************************************
* PROBLEM DESCRIPTION: *
* When you try to insert via DB2 OLEDB more than 32767 bound *
* parameters with insert statements, a catastrophic failure *
* occurs. *
* *
* This limitation is due to the usage of a short integer which *
* has a max value of 32767. DB2 is not able to allocate memory *
* after this maximum value is reached. *
* *
* For example, a parameterized insert sql statement with more *
* than 8191 statements in which each statement has got 4 *
* parameters will reach this limit ( 8191 *4 = 32764). *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 9.7 FP1 or later. *
**************************************************************** |
| Local Fix: |
Use no more than 32767 bound parameters in insert statement for
earlier DB2 V95 fix pack releases. |
| available fix packs: |
DB2 Version 9.7 Fix Pack 1 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
This limitation is removed from DB2 V975fp1 and more than 32767
parameters can be inserted with this fix pack release. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 20.07.2009
24.02.2010
16.12.2010 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.5FP1,
9.7.FP1
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.1
|
 |
