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 | |
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 |