|
Problem IC76121
|
Status: Closed |
CREATE INDEX MAY GET SQL0901N IF COLUMN HAS INVALID UTF8 CHARACTERS. |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
If the column on which index is created has invalid UTF
characters, reate index statement may get SQL0901N with reason
"Key data mismatch
encountered during key delete".
Simple repro:
#!/bin/ksh
export DB2OPTIONS="-ctv"
dbName="xxxxxx"
db2start
db2 "create db $dbName collate using SYSTEM_819_US"
db2 "connect to $dbName"
db2 "create table t1 (v1 varchar(3), i2 int)"
db2 "insert into t1 values (x'45C3A8',1), (x'4599EB',2)"
db2 "create index i1 on t1 (v1)"
SQL0901N The SQL statement failed because of a non-severe
system error.
Subsequent SQL statements can be processed. (Reason "Key data
mismatch
encountered during key delete".) SQLSTATE=58004 |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All *
****************************************************************
* PROBLEM DESCRIPTION: *
* f the column on which index is created has invalid UTF *
* *
* characters, reate index statement may get SQL0901N with *
* reason *
* "Key data mismatch *
* *
* encountered during key delete". *
****************************************************************
* RECOMMENDATION: *
* Upgrade server to v9.7.5 *
**************************************************************** |
| Local Fix: |
DB2SET DB2_BINSORT=NO; and recreate the indexes in { {13;21},
{10;23}, {10;35}, {13;14}, {13;30}, {16;12} } |
| 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 |
f the column on which index is created has invalid UTF
characters, reate index statement may get SQL0901N with reason
"Key data mismatch
encountered during key delete". |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 02.05.2011
08.12.2011
08.12.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.5
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.5
|
 |
