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