DB2 FOR LUW / DB2FORLUW / A50 - DB2

After successful REDISTRIBUTE operation (not all apply, see Note 
1:) on a table that has ADAPTIVE COMPRESSION enabled, table may 
become corrupt. Some records may appear twice (no more than 
twice) in table, but will be listed correctly (always once) in 
the index. 
 
Symptoms are either 
- db2dart errors saying that INX object has less records than 
DAT object, 
- table scan returns more rows than index scan 
 
Note 1: corruption can happen only on existing node that 
receives some data from another node as part of REDISTRIBUTE 
operation. That means DROP NODE, or rebalance. 
Unless target partition map is provided explicitly, REDISTRIBUTE 
ADD NODE is not affected by this corruption.

**************************************************************** 
* USERS AFFECTED:                                              * 
* DPF                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 version 10.5 Fix Pack 4                       * 
****************************************************************

Index contains correct info. EXPORT all data (SELECT *) from the 
table, prune it based on index entries. To do that export table 
data based on index scan and match record by record to the first 
output. 
 
Then DROP TABLE, re-create it, and populate from pruned file.

DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
 DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows
 

Fixed in v105fp4

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

16.08.2013
15.09.2014
15.09.2014