DB2 FOR LUW / DB2FORLUW / A50 - 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:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* move to v105 fp7                                             * 
****************************************************************

v105 fp7

keiner bekannt / siehe Local-Fix

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

15.04.2015
21.01.2016
21.01.2016