Toad World® Forums

Space Calculation for indexes in Toad for DB2 LUW shows zero sizes

Total MB, Used MB, Percent free, Empty Leaf Pages, deleted RIDs are all zero for all indexes. Is this a bug or is it my novice usage. I have clicked the Reload the Index Information button near the bottom left.

I can’t imagine if it matters but I have only indexes in this tablespace.

Those values are obtained from the catalog and are updated in the catalog when RUNSTATS are run against the Indexes. Can you ensure RUNSTATS have been run against the indexes?