Update Stats not updating for all the Tables

[KalpanaPai]

Hi All

We are running Update statistics high for the whole database every
night as a cron job, as our database is small of 1.5 GB. When i run
the following query
next day

Select distinct tabname,b.constructed,b.mode
from systables a,sysdistrib b
where a.tabid = b.tabid
order by 1

for the database, i found few tables especially the tables which has
more inserts everyday , one tables has 50000 rows and another had
10000 records, have been updated 3 months ago , but for rest of the
tables it shows the current date.

Why only few tables not updating on the production box but the same
cron runs and updates the test box????????
Any suggestions would be highly appreciated.

Thanks in Advance
Kalpana Pai

[Murray Wood \(IList\)]

If you run "update statistics high" and the constructed date for statistics
is not current, thus suggests that the table(s) concerned were open and
update statistics could not be run on them. Under some circumstances, the
statistics for some tables being updated do not get their statistics
updated.

If this is the case for many weeks then I would change the time of the
update stats - unless some process has this table (almost) permanently
locked.

MW

> -----Original Message-----
> From: [email]owner-informix-list@iiug.org[/email]
> [mailto:owner-informix-list@iiug.org]On Behalf Of KalpanaPai
> Sent: Monday, 8 September 2003 11:06 a.m.
> To: [email]informix-list@iiug.org[/email]
> Subject: Update Stats not updating for all the Tables
>
>
> Hi All
>
> We are running Update statistics high for the whole database every
> night as a cron job, as our database is small of 1.5 GB. When i run
> the following query
> next day
>
> Select distinct tabname,b.constructed,b.mode
> from systables a,sysdistrib b
> where a.tabid = b.tabid
> order by 1
>
> for the database, i found few tables especially the tables which has
> more inserts everyday , one tables has 50000 rows and another had
> 10000 records, have been updated 3 months ago , but for rest of the
> tables it shows the current date.
>
> Why only few tables not updating on the production box but the same
> cron runs and updates the test box????????
> Any suggestions would be highly appreciated.
>
> Thanks in Advance
> Kalpana Pai

sending to informix-list