|
Problem IC68563
|
Status: Geschlossen |
.NET DB2 BULK COPY FOR LOAD OPERATION PRODUCES INCORRECT RESULTS |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problembeschreibung: |
While trying to load data from .NET DataTable object to DB2
table using DB2BulkCopy object and WriteToServer() method.
Problem occures while 2 condition are fulfilled:
1) in DataTable there is null values in for example middle
column in
the table.
2) DB2BulkCopyColumnMapping are configured so that source
mapping of some
(not null) column are mapped to destination column at the end of
a DB2
table - after some column that contains null values, and the
source
column is before nullable columns.
When this 2 conditions are fulfilled bulk copy mechanism load
some
random data. |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* .NET applications using IBM ADO.NET provider V9.7 FP2 and *
* below *
****************************************************************
* PROBLEM DESCRIPTION: *
* While trying to load data from .NET DataTable object to DB2 *
* *
* table using DB2BulkCopy object and WriteToServer() method. *
* *
* *
* *
* Problem occures while 2 condition are fulfilled: *
* *
* *
* *
* 1) in DataTable there is null values in for example middle *
* *
* column in *
* *
* the table. *
* *
* *
* *
* 2) DB2BulkCopyColumnMapping are configured so that source *
* *
* mapping of some *
* *
* (not null) column are mapped to destination column at the *
* end of *
* a DB2 *
* *
* table - after some column that contains null values, and the *
* *
* source *
* *
* column is before nullable columns. *
* *
* *
* *
* When this 2 conditions are fulfilled bulk copy mechanism *
* load *
* some *
* *
* random data. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to V9.7 FP3 release. *
**************************************************************** |
| Local-Fix: |
|
| verfügbare FixPacks: |
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 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Lösung |
The issue was fixed in V9.7FP3 release. After the fix, correct
data is written by bulk copy under specified conditions. |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Bug-Verfolgung |
Vorgänger : APAR is sysrouted TO one or more of the following: IC68586
Nachfolger : |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 11.05.2010
06.07.2011
06.07.2011 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.7.FP3
|
| Problem behoben lt. FixList in der Version |
| 9.7.0.3
|
 |
| 9.7.0.3
|
|
