| Latest versions | fixlist |
| 11.1.0.7 |
 |
| 10.5.0.9 |
|
| 10.1.0.6 |
|
| 9.8.0.5 |
|
| 9.7.0.11 |
|
| 9.5.0.10 |
|
| 9.1.0.12 |
|
| Have problems? - contact us. | |
| Register for free |
|
| Contact form |
|
DB2 - Problem description
| Problem IC87013 | Status: Closed |
LOAD WITH STATS COLLECTION MIGHT GENERATE NLEVEL VALUE AS 0 IN CERTAIN SCENARIO FOR PARTITIONED INDEXES. | |
| product: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
| Problem description: | |
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 | |
| Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * All users of version 9.7 * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * upgrade to v97 fp8 * **************************************************************** | |
| Local Fix: | |
Perform another statistics collection via the runstats command, for example, RUNSTATS ON TABLE sahanant.test1 USE PROFILE | |
| available fix packs: | |
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows | |
| Solution | |
fix is included in v97 fp8. | |
| Workaround | |
not known / see Local fix | |
| BUG-Tracking | |
forerunner : APAR is sysrouted TO one or more of the following: IC89696 follow-up : | |
| Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 05.10.2012 01.04.2013 01.04.2013 |
| Problem solved at the following versions (IBM BugInfos) | |
9.7.FP8 | |
| Problem solved according to the fixlist(s) of the following version(s) | |
| 9.7.0.8 |
|