DB2 FOR LUW / DB2FORLUW / A10 - DB2

Memory corruption during runstats 'update profile' option if 
duplicate column groups are involved 
 
runstats 'update profile' command fails with error -1224, 
generating FODC and trap file. 
 
Ex: 
 
create table s1.t1 (c1 int, c2 int, c3 varchar(122), c4 
varchar(123)); 
 
runstats on table s1.t1 on columns ((c1,c2), (c1,c2)) set 
profile only 
 
runstats on table s1.t1 on columns ((c1,c2), (c2,c1)) update 
profile only; 
SQL2310N  The utility could not generate statistics.  Error 
"-1224" was 
returned. 
 
In runstats set profile we have specified columns group (c1,c2) 
twice. When update profile also contain the same column group 
(c1,c2) it will result in memory corruption.

**************************************************************** 
* USERS AFFECTED:                                              * 
* software                                                     * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* upgrade to v10.1 fp5                                         * 
****************************************************************

not known / see Local fix

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

04.02.2015
13.07.2015
13.07.2015