DB2 FOR LUW / DB2FORLUW / 970 - DB2

When the load utility with del option is executed from DB2 
Client on Windows and the data is stored to the DB2 Server on 
Unix, character type data put into a column could be tailed with 
0x0D. 
On Windows, 0x0D is CR control character and the data in del 
format could have 0x0D at end of the lines as 0x0D0A 
regularly. 
With the combination of DB2 Client on Windows and DB2 Server on 
Unix, the character type data loaded by load utility on Windows 
may put with 0x0D incorrectly to DB2 Server on Unix. 
 
Note that 0x0d is inserted by load utility executed in DB2 
Client or Server on Unix if the input del type data has 0x0d. 
This situation could happen when the del type data is created on 
Windows and the data is loaded from DB2 on Unix.

**************************************************************** 
* USERS AFFECTED:                                              * 
* User executing load utility in DB2 Client on Windows         * 
* platform connecting to DB2 Server on UNIX platform.          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.7 Fix Pack 11.                      * 
****************************************************************

Convert row delimiters in the data file to server-side format, 
i.e. from 0x0D0A to 0x0A, and Load again

Problem was first fixed in DB2 Version 9.7 Fix Pack 11.

keiner bekannt / siehe Local-Fix

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

15.10.2014
13.10.2015
13.10.2015

9.7.FP11