|
Problem IC78124
|
Status: Closed |
THE DATA IS TRUNCATED WHEN THE CODEPAGES ARE DIFFERENT BETWEEN LOCAL DB2 DATABASE AND REMOTE DB2 DATABASE |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - 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: *
* Users below V97 FP6 *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 V9.7 Fixpak 6 *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
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 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
Fisrt fixed in DB2 V9.7 Fixpak 6 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 14.08.2011
28.08.2012
28.08.2012 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.6
|
 |
