are you doing an update statistics medium distributions only?
if yes the only table involved is sysdistrib
if not, systables, syscolumns, sysindexes also to name a few.
also sysdistrib does not get updated, rather update statistics deletes the old
distributions for each table/column pair it is invoked on, and then inserts
new distributions.

malcolm weallans wrote:
> I am getting problems with update statistics and the
> amount of log space used. We are filling 14 logs of
> 20Mbytes each time that we run update statistics
> medium. The system has a number of databases and
> their are 44,554 tables in the whole system. I also
> checked and their are a total of 36,000 sysdistrib
> records. The row size for systables is 469 so the
> amount of log space needed for systables is 44,554 * 2
> * 469 plus about 10% overhead. The row size for
> sysdistrib is 305 so the amount of log space needed
> for that is 36,000 *2 *305 plus about10% overhead.
> The calculation can account for about 70 Mbytes
> whereas we ar using 280 Mbytes. What else does update
> statistics change?
>
> regards
>
> Malcol,m
> sending to informix-list
>


--
Ciao,
Marco
__________________________________________________ ____________________________
Marco Greco /UK /IBM Standard disclaimers apply!

Informix faq http://www.iiug.org/techinfo/faq/informix.htm
4glworks http://www.4glworks.com
Informix on Linux http://www.4glworks.com/ifmxlinux.htm

sending to informix-list

Marco Greco <marco@4glworks.com> wrote in message news:<1109013054.ee39576dda64e5c68c2c154e5ac97f48@ teranews>...
> are you doing an update statistics medium distributions only?
> if yes the only table involved is sysdistrib
> if not, systables, syscolumns, sysindexes also to name a few.
> also sysdistrib does not get updated, rather update statistics deletes the old
> distributions for each table/column pair it is invoked on, and then inserts
> new distributions.
>
> malcolm weallans wrote:
> > I am getting problems with update statistics and the
> > amount of log space used. We are filling 14 logs of
> > 20Mbytes each time that we run update statistics
> > medium. The system has a number of databases and
> > their are 44,554 tables in the whole system. I also
> > checked and their are a total of 36,000 sysdistrib
> > records. The row size for systables is 469 so the
> > amount of log space needed for systables is 44,554 * 2
> > * 469 plus about 10% overhead. The row size for
> > sysdistrib is 305 so the amount of log space needed
> > for that is 36,000 *2 *305 plus about10% overhead.
> > The calculation can account for about 70 Mbytes
> > whereas we ar using 280 Mbytes. What else does update
> > statistics change?
> >
> > regards
> >
> > Malcol,m
> > sending to informix-list
> >
>
>
> --
> Ciao,
> Marco
> __________________________________________________ ____________________________
> Marco Greco /UK /IBM Standard disclaimers apply!
>
> Informix faq http://www.iiug.org/techinfo/faq/informix.htm
> 4glworks http://www.4glworks.com
> Informix on Linux http://www.4glworks.com/ifmxlinux.htm
>
> sending to informix-list

Hi folks

I user to run a statement:

SET ISOLATION TO DIRTY READ ;

before 'update statistics [high | medium} for table ' using or not
'distributions only'.

could be a good idea to don't generate logs.

BR,

R Ferronato