Re: npused < 0 - alive and well in 7.11.UC1

I want to hear more about this one myself guys. It's caused me more grief then I want to convey. I'm in that number crunch mode, and begging for disk space (the part of being a DBA, no one enjoys). On 14 Nov 1995, Radio Spares wrote: } } Dear All, } } Remeber the old npused < 0 bug with update statistics (bug #14829) that was } meant to be fixed in 5.02. } } Well we have just installed 7.11.UC1 on a Sun running Solaris 2.4 and we have } this bug worse than before. It used to occur occasionally on 1 or 2 tables. } After the install we ran update statistics and we have about 10 tables with } npused < 0. } } I know we can update the systables entries but we have to do this each time we } run the update stats. Has anyone heard of another fix being out for this yet? } } BTW, we have the same O/S and Informix on our development machine and a copy } of almost exactly the same database but none of those tables have npused < 0. } } Nothing like an upgrade to really get your blood pumping heh? } } Jason Harris (RSWA) } }