npused < 0 - alive and well in 7.11.UC1

Posted in 1995

Radio Spares — 14 Nov 1995 10:20:24 +0800 — source: Informix-list mailing list archive (1991-1998)

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)