Re: update statistics - large amount of log space

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