DB2 FOR LUW / DB2FORLUW / 970 - DB2

In SMP when doing distinct or group by that includes timestamp 
columns, it is possible that duplicate rows will be returned. 
example: 
select distinct col1(varchar), col2(timestamp) from table 
might return duplicate rows if col1 has values that differ in 
trailing blanks only. (ex: 'A' and 'A    ') 
 
Conditions to encounter this problem: 
- must have SMP enabled (database manager config has the 
parameter INTRA_PARALLEL set to ON) 
- The query degree is > 1 (database config for DFT_DEGREE or the 
CURRENT QUERY DEGREE special register) 
- must have timestamp column as last column in the list , so it 
becomes first column in the hash key 
- must have rows that would have been considered identical and 
the only difference is varchar column that has spaces

**************************************************************** 
* USERS AFFECTED:                                              * 
* SMP only                                                     * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Install this fix                                             * 
****************************************************************

turn SMP off, remove trailing blanks or install this fix.

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

Install this fix

keiner bekannt / siehe Local-Fix

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

20.08.2012
20.10.2012
20.10.2012