DB2 FOR LUW / DB2FORLUW / B10 - DB2

An export from a table using codeunits32 will produce extra 
spaces in the output file. 
 
For example: 
 
$ db2 "CREATE TABLE MYTABLE(C1 CHAR (10 CODEUNITS32), C2 
VARCHAR(20)) 
 
$ db2 "INSERT INTO MYTABLE VALUES('HALLO', 'MYNAME')" 
 
 
$ db2 "EXPORT TO exp.del of DEL MODIFIED BY COLDEL0x7c NOCHARDEL 
select 
* from MYTABLE" 
 
$ less exp.del 
 
HALLO                                   |MYNAME     << 35 spaces 
 
 
 
In the case above, the output should only have 5 spaces since 
the total length of the string should always be equal to what 
was defined on the table.

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to Db2 11.1 Mod 2 Fix Pack 2 iFix002 or higher       * 
****************************************************************

Db2 Version 11.1 Mod2 Fix Pack2 iFix002 for Linux, UNIX, and Windows
 Db2 Version 11.1 Mod 3 Fix Pack 3 for Linux, UNIX, and Windows
 Db2 Version 11.1 Mod3 Fix Pack3 iFix001 for Linux, UNIX, and Windows
 Db2 Version 11.1 Mod3 Fix Pack3 iFix002 for Linux, UNIX, and Windows
 

First fixed in Db2 11.1 Mod 2 Fix Pack 2 iFix002

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

07.12.2017
22.12.2017
22.12.2017