RE: dostats problems with 9.4 and 10.0

> -----Original Message----- > From: owner-informix-list@iiug.org [SMTP:owner-informix-list@iiug.org] > On Behalf Of Jeff > Sent: Sunday, September 04, 2005 9:29 PM > To: informix-list@iiug.org > Subject: dostats problems with 9.4 and 10.0 > > 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. [Bill Dare] Try putting double quotes around the *. I use this every night and it works OK for me on 9.40.FC6X2. > 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. [Bill Dare] Bug 173898 UPDATE STATISTICS FOR SPECIFIC PROCEDURE COMPILES EVERYPROCEDURE IN THE DATABASE NOT THE SPECIFIC PROCEDURE THE USER HAS REQUESTED > [Bill Dare] Dostats uses the FOR SPECIFIC keywords and that's what causes the excessive log activity. If you check the logs with onlog you will see all of the logging activity is on the sysprocplan table. > > > 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 sending to informix-list