SYSIBM.SYSINDEXES

[Hattusas]

Suppose I have a table named as finance.invoice with more than one index (one of the index is primary key of course).
When I reorganize my table with my index ,after checking with update statistics option DB2 updates the values and
mostly clusterratio becomes 100 at that time for this index.

What I wonder is if I neglect checking my table and my table
has had many updates what will be value of clusterratio field on sysibm.sysindexes table?Still 100?If it shows a value below 100 (or -1 that must mean there are no statistics collected yet) how does DB2 understand that clusterratio decreases as time goes by?

If it still shows 100 as a value then how will I understand if everything is going right?Do I have to check my tables by running the command "reorgchk on table all"

Thanks.

Salih Sipahi
Software Engineer.
City of Istanbul Turkey
s.sipahi@sahinlerholding.com.tr

 

[grofaty]

Hi,

Try running the runstats on tables regulary. When exectuting this command data in sysibm.sysindexes are refresed.

When runing reorgchk then runstats in automaticaly applied before getting statistics data.

Hope this helps,
Grofaty