|
Problem IC67684
|
Status: Closed |
SQL0803N "DUPLICATE VALUES FOR THE INDEX KEY" IN EXPLAIN_DIAGNOSTIC TABLE |
| product: |
DB2 FOR LUW / DB2FORLUW / 980 - DB2 |
| Problem description: |
EXPLAIN of some statements might result in SQL0803N "duplicate
values for the index key" in EXPLAIN_DIAGNOSTIC table. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* all *
****************************************************************
* PROBLEM DESCRIPTION: *
* see error description *
****************************************************************
* RECOMMENDATION: *
* upgrade to DB2 Version 9.8 Fix Pack 3 *
**************************************************************** |
| Local Fix: |
There are 2 workarounds identified:
1) drop the 2 diagnostic tables,
2) drop the primary key for explain_diagnostic and the foreign
key for explain_diagnostic_data, then manually delete duplicates
diagostic_id if it is desired to use db2exfmt to format the
explained data.
However, both workarounds involve changing objects where the
customer should take care to undo the change at an appropriate
time. |
| available fix packs: |
DB2 Version 9.8 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.8 Fix Pack 4 for AIX and Linux
DB2 Version 9.8 Fix Pack 5 for AIX and Linux
|
| Solution |
The problem is first fixed in DB2 Version 9.8 Fix Pack 3. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 07.04.2010
27.12.2010
27.12.2010 |
| Problem solved at the following versions (IBM BugInfos) |
9.8.FP3
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.8.0.3
|
 |
