DB2 FOR LUW / DB2FORLUW / 970 - DB2

Data trancation might happen during export if the codepages ued 
are unsupported. 
For eg : "unicode client to non-unicode server not supported" 
and the truncation event is known in such cases. 
 
Fix includes to give a global (i.e. not per-row) SQL3132W 
warning if a truncation may potentially occur.  This is the 
current behaviour for DB2 LUW that is not working with DB2 
z/OS, and the fix is to make DB2 z/OS work like DB2 LUW. 
 
Receiving a warning means "a truncation may occur with 
that column". 
With the fix, "no warning" will mean "there was no truncation", 
but a warning means "there may or may not be a truncation with 
user's actual data".

**************************************************************** 
* USERS AFFECTED:                                              * 
* Users using lower versions than V9.7 FP2                     * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* DATA TRUNCATION WITHOUT A WARNING MESSAGE WHEN EXPORTINGFROM * 
* DB2 V8 FOR Z/OS TO DB2 LUW V9.7.                             * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to  DB2 V9.7 FP2                                     * 
****************************************************************

Users should export data into the same codepage if possible so 
that there will be no codepage conversion issue during export. 
The import/load may need a codepage conversion though.

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 8 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a 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
 

First fixed in DB2 V9.7 FP2

keiner bekannt / siehe Local-Fix

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

11.02.2010
22.06.2010
22.06.2010

9.7.FP2