Difference in INDEX statistics in SYSIBM.SYSINDEXES

[dib...@gmail.com]

Hi,

I am encountering a strange problem for a Table in production vs test.
The table has same number of records in both test and production. It
has 5 indexes and SYSIBM.SYSINDEXES shows CLUSTERED=Y for the first
index in production while in test CLUSTERED=Y shows up for the first
three index.

The production table goes thru REORG-RUNSTAT-BIND every Sunday and is
then copied over to test followed by a RUNSTAT in test. I wonder what
makes DB2 assign CLUSTERED=N to a index in prodcution but CLUSTERED=Y
to the same Index in test.

Index Name CLUSTERING CLUSTERED in Production CLUSTERED in Test
----------------------------------------------------------------------------------------------------------------------
IXHB1 Y Y Y
IXHB2 N N Y
IXHB3 N N Y
IXHB4 N N N
IXHB5 N N N