home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IC68563 Status: Closed

.NET DB2 BULK COPY FOR LOAD OPERATION PRODUCES INCORRECT RESULTS

product:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
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.
Problem Summary:
**************************************************************** 
* 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:
available fix packs:
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

Solution
The issue was fixed in V9.7FP3 release.  After the fix, correct 
 
 
data is written by bulk copy under specified conditions.
Workaround
not known / see Local fix
BUG-Tracking
forerunner  : APAR is sysrouted TO one or more of the following: IC68586 
follow-up : 
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
11.05.2010
06.07.2011
06.07.2011
Problem solved at the following versions (IBM BugInfos)
9.7.FP3
Problem solved according to the fixlist(s) of the following version(s)
9.7.0.3 FixList
9.7.0.3 FixList