Re: Negative npused values

Christopher Cale writes: | I am running Online 5.01.UD3 on an RS/6000. I have the need to | know the amount of disk space that individual tables are using and | naturally thought that I could utilize the value of "npused" in the | systables table. However, I find that some of the tables show a | negative value for this column, even immediately after running | "update statistics". How should I interpret this? | And, if this is not the correct method to determine disk usage, | what is? This may be the result of Bug # 14829, which causes negative npused values after successive inserts/deletes in a table. The workaround is to calcultate the npused value manually and update the systables manually - if you run update statistics after this, it will be re-set to negative, however. This has caused us problems since it misleads the optimizer into sequential scans of possibly huge tables. I believe it has been fixed in version 5.02.UC1. Hope this helps, Richard Ridley DHL Asia Pacific