DB2 FOR LUW / DB2FORLUW / 980 - DB2

EXPLAIN of some statements might result in SQL0803N "duplicate 
values for the index key" in EXPLAIN_DIAGNOSTIC table.

**************************************************************** 
* USERS AFFECTED:                                              * 
* all                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* see error description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* upgrade to DB2 Version 9.8 Fix Pack 3                        * 
****************************************************************

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.

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
 

The problem is first fixed in DB2 Version 9.8 Fix Pack 3.

keiner bekannt / siehe Local-Fix

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

07.04.2010
27.12.2010
27.12.2010

9.8.FP3