|
Problem IC67758
|
Status: Closed |
INDEX PAGE CLEANUP INCORRECTLY MARKS DELETED KEY AS NOT DELETED WHEN USING INDEX COMPRESSION |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| 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 |
| Problem Summary: |
****************************************************************
* 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. *
**************************************************************** |
| Local Fix: |
Drop and recreate the affected index. |
| 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 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
|
| Solution |
The fix is contained in DB2 version 9.7.2. |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC67759
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 09.04.2010
23.04.2010
23.04.2010 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.2
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.2
|
 |
