|
Problem IC78124
|
Status: Geschlossen |
THE DATA IS TRUNCATED WHEN THE CODEPAGES ARE DIFFERENT BETWEEN LOCAL DB2 DATABASE AND REMOTE DB2 DATABASE |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 970 - 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: *
* Users below V97 FP6 *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 V9.7 Fixpak 6 *
**************************************************************** |
| Local-Fix: |
|
| verfügbare FixPacks: |
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
|
| Lösung |
Fisrt fixed in DB2 V9.7 Fixpak 6 |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 14.08.2011
28.08.2012
28.08.2012 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.7.
|
| Problem behoben lt. FixList in der Version |
| 9.7.0.6
|
 |
