DB2 FOR LUW / DB2FORLUW / 970 - DB2

In DPF environment, changing data type of the distribution key 
column may cause the distribution hash value changing and 
hence DB2 returns wrong results. 
 
 
 
The following is an example: 
1. db2 connect to sample 
2. db2 "create table test (col1 bigint) " 
 
3. db2 "insert into test values (1234567890)" 
4. db2 "alter table test alter col1 set data type double" 
5. db2 "select * from test" 
 
COL1 
------------------------ 
 
  +1.23456789000000E+009 
 
  1 record(s) selected. 
 
 
6. db2 "select * from test where col1 = 1234567890" 
 
COL1 
------------------------ 
 
  0 record(s) selected

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Problem Description above.                               * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.7 Fix Pack 4.                       * 
****************************************************************

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

First fixed in DB2 Version 9.7 Fix Pack 4.

keiner bekannt / siehe Local-Fix

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

30.01.2011
02.05.2011
02.05.2011

9.7.FP4