|
Problem IC62114
|
Status: Geschlossen |
BATCH PARAMETRIZED INSERT FAILED TO INSERT MORE THAN 32767 BOUND |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problembeschreibung: |
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-Zusammenfassung: |
****************************************************************
* 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. |
| verfügbare FixPacks: |
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
|
| Lösung |
This limitation is removed from DB2 V975fp1 and more than 32767
parameters can be inserted with this fix pack release. |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 20.07.2009
24.02.2010
16.12.2010 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.7.5FP1,
9.7.FP1
|
| Problem behoben lt. FixList in der Version |
| 9.7.0.1
|
 |
