DB2 FOR LUW / DB2FORLUW / B10 - DB2

AUTOMATIC REORG can keep occurring on tables if there is a
single Index Page and is pseudo empty.

The index will keep being reorg due to violation of formula 8,
which is caused by we can't free the last page of an index.

Reproduce this problem are the following:
db2start
db2createdb MYDB
db2 "create table t1(c1 int, c2 int)"
db2 "create index i1 on t1(c1)"
db2 "insert into t1 values (1,1)"
db2 "delete from t1 where c1=1"
db2 runstats on table t1 with distribution and detailed indexes
all
db2 "select NLEAF, NUM_EMPTY_LEAFS  from SYSCAT.INDEXES where
TABNAME='T1'"
db2 REORG INDEXES ALL FOR TABLE t1 ALLOW WRITE ACCESS CLEANUP
PAGES
db2 runstats on table t1 with distribution and detailed indexes
all
db2 "select NLEAF, NUM_EMPTY_LEAFS  from SYSCAT.INDEXES where
TABNAME='T1'"
## will see 1 , 1. but ideally, this should be 1, 0

****************************************************************
* USERS AFFECTED:                                              *
* ALL                                                          *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to Db2 11.1 Mod 2 Fix Pack 2 or higher               *
****************************************************************

Disable Automatic REORG for the table(s).

not known / see Local fix

forerunner  : IT15573 
follow-up : 

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

02.10.2017
24.10.2017
24.10.2017