Re: ERROR?? in systables for npused - fsextern.txt [1/1]
Posted in 1996
Steve Goldberg — — source: Informix-list mailing list archive (1991-1998)
In article <4m3is9$2v4@netservices.nzsakl.bhp.com.au>, schouten.frits.jf@bhp.com.au (Frits Schouten) says: > >On tables which are only growing the 'npused' is always correct. >But as soon as one record is deleted from a table, the 'npused' >for that table is not going up anymore when records are added. >In fact it continues to count down on records deleted. This is a known bug. It is also in some V5 Online versions. It is corrected in a later release. Just wait until you get to negative pages used. :( I think if you set it to 0 then update stats again it may be correct. Just be aware of the problem and don't depend on the numbers. Steve Goldberg Landata RE-Source steveg@landata.com