|
Problem IC84233
|
Status: Geschlossen |
THE DATA IS TRUNCATED WHEN THE CODEPAGES ARE DIFFERENT BETWEEN LOCAL DB2 DATABASE AND REMOTE DB2 DATABASE |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 |
| Problembeschreibung: |
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-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* V10 *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 version v10 Fixpak 1 *
**************************************************************** |
| Local-Fix: |
|
| verfügbare FixPacks: |
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
|
| Lösung |
First fixed in v10 Fixpak 1 |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 13.06.2012
04.12.2012
04.12.2012 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
|
| Problem behoben lt. FixList in der Version |
| 10.1.0.1
|
 |
| 10.5.0.1
|
|
