DB2 FOR LUW / DB2FORLUW / 970 - DB2

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

**************************************************************** 
* 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                                      * 
****************************************************************

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.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
 

first fixed in DB2 version 9.7 FP2

keiner bekannt / siehe Local-Fix

Vorgänger  : APAR is sysrouted TO one or more of the following: IC67684 
Nachfolger : 

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

07.04.2010
10.05.2010
10.05.2010

9.7.FP2