Re: dostats problems with 9.4 and 10.0
Jeff wrote:
> 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?
Your main problem, the update stats on procedures with the SPECIFIC keyword,
which dostats uses, is, as Bill Dare points out, a known 9.xx/10.00 bug. I
have an update version of dostats with an option to disable the SPECIFIC
keyword, which I'll send you. Note that if you use that option (-N) there
may be some overloaded functions that will fail to recompile.
Your immediate problem is that you need to quote the asterisk '*' so that
the shell does not expand it to a list of files. When that happens dostats
thinks you want to update stats for a table that has the name of the first
file listed and ignores the rest of the commandline silently (I hate progs
that complain about extra args, just one of my pet peeves - though in this
case it obviously caused some confusion).
Jeff, please send me a valid email address that you monitor so I can forward
the dostats update to you.
Art S. Kagel
sending to informix-list
The quoting of the asterisk was definitely a Homer "Doh!" moment. But the
SPECIFIC bug was news to me.
Since, of course, I have the dostats source code, I simply removed the
"SPECIFIC" keyword and recompiled. Things are working fine now...
Thanks,
Jeff
ART KAGEL, BLOOMBERG/ 731 LEXIN wrote:
> Jeff wrote:
>> 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?
>
> Your main problem, the update stats on procedures with the SPECIFIC keyword,
> which dostats uses, is, as Bill Dare points out, a known 9.xx/10.00 bug. I
> have an update version of dostats with an option to disable the SPECIFIC
> keyword, which I'll send you. Note that if you use that option (-N) there
> may be some overloaded functions that will fail to recompile.
>
> Your immediate problem is that you need to quote the asterisk '*' so that
> the shell does not expand it to a list of files. When that happens dostats
> thinks you want to update stats for a table that has the name of the first
> file listed and ignores the rest of the commandline silently (I hate progs
> that complain about extra args, just one of my pet peeves - though in this
> case it obviously caused some confusion).
>
> Jeff, please send me a valid email address that you monitor so I can forward
> the dostats update to you.
>
> Art S. Kagel
> sending to informix-list