|
Problem IC67683
|
Status: Closed |
SQL0803N "DUPLICATE VALUES FOR THE INDEX KEY" IN EXPLAIN_DIAGNOSTIC TABLE |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - 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 versions 9.7 and up. *
****************************************************************
* PROBLEM DESCRIPTION: *
* EXPLAIN of some statements might result in SQL0803N *
* "duplicate values for the index key" in EXPLAIN_DIAGNOSTIC *
* table. *
****************************************************************
* RECOMMENDATION: *
* Install version 9.7 FP2 *
**************************************************************** |
| 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.7 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
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 9a 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 10 for Linux, UNIX, and Windows
|
| Solution |
first fixed in DB2 version 9.7 FP2 |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC67684
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 07.04.2010
10.05.2010
10.05.2010 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP2
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.2
|
 |
