Getting a -1 value for one metric when you get an actual value for the other
is normal behavior. Setting one metric to a value causes the other to
be -1.
As to your actual values, I'm puzzled. Your warning and alarm settings seem
to be very low. Ithought the one wants to know when cluster ratio is =< 80
(percent) so 10% would mean you really don't care. I may be wrong as to how
to specify for storage manager but I know that it's the value 80 that the
optimizer will start to question whether to use the index or not.
With normal stats, a value of 4 would mean that your index clusters to 4% of
the rowid sequence which basically means the clustering is useless. But atr
4%, you woulf get your warnings and alrms because they're set to 10%.
For detailed stats., the value means 0.223 as the cluster factor is between
0 and 1. I'm puzzled, 4% normal and 22.3% (0,223) detailed. You're right
you may have found a bug !!!!
Regards, Pierre.
--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
"dunleav1" <jm*@dunleavyenterprises.coma écrit dans le message de news:
11**********************@30g2000cwc.googlegroups.c om...
With normal stats I get a cluster ration of 4 and cluster factor of
-1.
With detailed stats I get a cluster ratio of -1 and cluster factor of .
223.
The warning level I set within storage manager for cluster ratio is
10% and alram level is 10%.
I think this is another bug I've found with one of the DB2 gui tools.
I'll just ignore the warning.
Thanks,
JD