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 IC70409 Status: Closed

SQL3132W COLUMN TRUNCATION WARNING MESSAGE MIGHT NOT BE DISPLAYED WHEN
USING EXPORT IXF WITH CODEPAGE=X MODIFIER.

product:
DB2 FOR LUW / DB2FORLUW / 950 - DB2
Problem description:
When the Export utility is invoked with the CODEPAGE=x modifier 
specified with multi-byte codepage (like 1208), and IXF file 
type is specified, and the database codepage and application 
codepage are both single-byte codepages, then Export may not 
display a SQL3132W column truncation warning message.
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All.                                                         * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* Abstract: SQL3132W COLUMN TRUNCATION WARNING MESSAGE MIGHT   * 
* NOT BE DISPLAYED WHEN USING EXPORT IXF WITH CODEPAGE=X       * 
* MODIFIER.                                                    * 
*                                                              * 
* Description:                                                 * 
* When the Export utility is invoked with the CODEPAGE=x       * 
* modifier specified with multi-byte codepage (like 1208), and * 
* IXF file type is specified, and the database codepage and    * 
* application codepage are both single-byte codepages, then    * 
* Export may not display a SQL3132W column truncation warning  * 
* message.                                                     * 
*                                                              * 
* Workaround:                                                  * 
* Do not use the Export CODEPAGE=x modifier, instead change    * 
* the application codepage using the 'db2codepage' registry    * 
* variable.                                                    * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Update to v95fp8 or later fixpacks.                          * 
****************************************************************
Local Fix:
Do not use the Export CODEPAGE=x modifier, instead change the 
application codepage using the 'db2codepage' registry variable.
available fix packs:
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows

Solution
This problem is first fixed in db2 version 9.5 fixpack 8.
Workaround
not known / see Local fix
BUG-Tracking
forerunner  : APAR is sysrouted TO one or more of the following: IC70427 IC73335 
follow-up : 
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
05.08.2010
05.07.2011
05.07.2011
Problem solved at the following versions (IBM BugInfos)
9.5.FP8
Problem solved according to the fixlist(s) of the following version(s)
9.5.0.8 FixList