dostats problems with 9.4 and 10.0
Posted in 2005
Jeff — — source: Usenet: comp.databases.informix
dostats: Features Version 4.12, Source Revision: 1.101 !
Running "dostats -d <dbname> -t *" on a 9.4 instance does nothing. It just says
"Working on database: <dbname>." and quits. I need this option to skip
procedures because for some reason, when dostats updates stats for procedures,
It runs through about 100 logical logs. This, in turn, eats up a lot of my disk
space where my logical logs are backed up. A normal day of processing for us
uses about 20-30 logs.
On a 10.0 instance it has a problem with a function based index. It generates
the statement:
UPDATE STATISTICS HIGH FOR TABLE ticket_postscript ();
Art, do you have any plans to update dostats?
Thanks,
--
Jeff
jlar310 at yahoo