|
Problem IC76977
|
Status: Geschlossen |
SORT RESULTS MAY BE INCORRECT FOR MALFORMED SINGLE BYTE UTF-8 CHARACTERS IN IDENTITY_16BIT COLLATOIN. |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problembeschreibung: |
The user may see something wrong with their index or sort, such
as misordered rows or an error while trying to update the
indexes. Some known index manager related error messages which
may appear in db2diag.log for this include SQLI_NOKEY from the
function procLeaf2Del with probe 2, or SQLI_PRG_ERR from the
function sqlischa with probe 3202. Other index manager related
errors may be seen.
This problem only affects malformed single-byte UTF-8 characters
in IDENTITY_16BIT collation. |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* DB2 LUW *
****************************************************************
* PROBLEM DESCRIPTION: *
* Inconsistent sorting result with mal-formed UTF-8 characters *
* in IDENTITY_16BIT collation. *
****************************************************************
* RECOMMENDATION: *
* Update to DB2 v9.7 fix pack 5. *
**************************************************************** |
| Local-Fix: |
Recreate the affected indexes. |
| verfügbare FixPacks: |
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
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 |
Fix in DB2 v9.7 fix pack 5. |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 15.06.2011
07.12.2011
07.12.2011 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.7.FP5
|
| Problem behoben lt. FixList in der Version |
| 9.7.0.5
|
 |
