Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
William Harris — — source: Informix-list mailing list archive (1991-1998)
In article <403mhv$9ej@newsbf02.news.aol.com>, plkapp@aol.com says...
>
>Version 5.01 of Online has a bug in Update Statistics. I
>have found my copy of the proposed work-around from Informix
>Tech Support. (Bug #14829 - Scheduled Fix 5.02.UC1) This bug
>affects tables that undergo bulk inserts and bulk deletes to
>get negative values in np_used statistics (in systables),
Whatever the fix is scheduled for, the bug still appears to exist in
5.03.UC1.
Script:
select npused from systables where tabname="glatemp_rec";
update statistics for table glatemp_rec;
select npused from systables where tabname="glatemp_rec";
Output:
npused
-27
1 row(s) retrieved.
Statistics updated.
npused
-27
1 row(s) retrieved.
But thanks for the workaround. One comment:
LET numpgs = numrows / (2020/(rowsz+4));
I think the 2020 given here should be based on the system's page size.
--
William Harris william@carsinfo.com
CARS Information Systems http://www.carsinfo.com/~william/
4000 Executive Park Drive
Cincinnati, OH (USA) 45241
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.