DB2 FOR LUW / DB2FORLUW / 970 - DB2

The problem occurs when running inserts, updates and deletes on 
a table with indexes that use index compression.  The index 
manager temporarily clears the deleted flag from a key before 
performing clean up on the page for the purpose of keeping that 
key on the page.  There is a scenario in which the index manager 
fails to reset the deleted flag on the key.  This can result in 
the following symptoms: 
- extra data being returned when using an index scan 
- index/data mismatches detected by DB2's INSPECT command

**************************************************************** 
* USERS AFFECTED:                                              * 
* Users of index compression.                                  * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* The problem occurs when running inserts, updates and deletes * 
* on a table with indexes that use index compression.  The     * 
* index manager temporarily clears the deleted flag from a key * 
* before performing clean up on the page for the purpose of    * 
* keeping that key on the page.  There is a scenario in which  * 
* the index manager fails to reset the deleted flag on the     * 
* key.  This can result in the following symptoms:             * 
* - extra data being returned when using an index scan         * 
* - index/data mismatches detected by DB2's INSPECT command    * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 version 9.7.2.                                * 
****************************************************************

Drop and recreate the affected index.

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 8 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a 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
 

The fix is contained in DB2 version 9.7.2.

keiner bekannt / siehe Local-Fix

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

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

09.04.2010
23.04.2010
23.04.2010

9.7.2