|
Problem IC76977
|
Status: Closed |
SORT RESULTS MAY BE INCORRECT FOR MALFORMED SINGLE BYTE UTF-8 CHARACTERS IN IDENTITY_16BIT COLLATOIN. |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
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 Summary: |
****************************************************************
* 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. |
| available fix packs: |
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
|
| Solution |
Fix in DB2 v9.7 fix pack 5. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 15.06.2011
07.12.2011
07.12.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP5
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.5
|
 |
