DB2 FOR LUW / DB2FORLUW / 970 - DB2

The issue can be reproduced in the following scenario: 
 
1. 
create table test1( a BIGINT NOT NULL, 
                    b INTEGER NOT NULL) 
                    distribute by hash(a) 
                    partition by range (b) 
                    (PART "PART0" STARTING('1')  ENDING('10'), 
                     PART "PART1" STARTING('11') ENDING('20')); 
 
create index indx1 on sahanant.test1 (b); 
runstats on table sahanant.test1 and indexes all set profile 
only; 
load from data.del of del MESSAGES "msgfile" REPLACE into 
sahanant.test1 statistics use profile; 
 
 
select substr(indname, 1, 10), nlevels, indcard, numrids from 
syscat.indexpartitions where indname='INDX1' 
 
1          NLEVELS INDCARD              NUMRIDS 
---------- ------- -------------------- -------------------- 
INDX1            0                    3                    3 
INDX1            1                    0                    0 
 
  2 record(s) selected. 
 
 
select substr(indname, 1, 10), nlevels, indcard, numrids from 
syscat.indexes where indname='INDX1' 
 
1          NLEVELS INDCARD              NUMRIDS 
---------- ------- -------------------- -------------------- 
INDX1            0                    1                    1 
 
  1 record(s) selected. 
 
 
 
 
>cat data.del 
0,1 
1,2 
2,3

**************************************************************** 
* USERS AFFECTED:                                              * 
* All users of version 9.7                                     * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* upgrade to v97 fp8                                           * 
****************************************************************

Perform another statistics collection via the runstats command, 
for example, 
RUNSTATS ON TABLE sahanant.test1 USE PROFILE

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
 

fix is included in v97 fp8.

keiner bekannt / siehe Local-Fix

Vorgänger  : APAR is sysrouted TO one or more of the following: IC89696 
Nachfolger : 

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

05.10.2012
01.04.2013
01.04.2013

9.7.FP8