Re: update statistics - large amount of log space
Posted in 2005
Topics: Connectivity: ESQL/C, 4GL & Embedded SQL, Platform-Specific Issues
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