|
Problem IC84233
|
Status: Closed |
THE DATA IS TRUNCATED WHEN THE CODEPAGES ARE DIFFERENT BETWEEN LOCAL DB2 DATABASE AND REMOTE DB2 DATABASE |
| product: |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 |
| Problem description: |
When local database codepage is different from remote database
codepage, the data might be truncated.
For example, the codepage of local database is 937 and the
codepage of remote database is 1208. That means DB2 need
to convert data from 937 to 1208.
In DB2 trace, you could find
...
1648344 exit DB2 UDB National Language Support sqlnlscpcv cei
(2.3.56.27.2)
pid 884760 tid 6684 cpid 958544 node 0 sec 85 nsec 359822716
rc = 0x870F00BC = -2029059908 = SQLO_BUFFSMALL
The error happens because it's not big enough to accomodate the
data expansion in different codepage environment. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* V10 *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 version v10 Fixpak 1 *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
DB2 Version 10.1 Fix Pack 1 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
|
| Solution |
First fixed in v10 Fixpak 1 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 13.06.2012
04.12.2012
04.12.2012 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.1.0.1
|
 |
| 10.5.0.1
|
|
