Re: Implict Update Statistics

Posted in 2004

scottishpoet — 6 Aug 2004 05:42:14 -0700 — source: Usenet: comp.databases.informix

check your cron jobs!!! "Shannon Sellers" <sellesd@hotmail.com> wrote in message news:<exAQc.233147$JR4.39937@attbi_s54>... > Within the last few weeks one of our WEB applications hangs because the DB > never responds. After some investigation we have found that the connection > is running an update statistics on a large table. The update statistics run > for almost an hour. We have run OnCheck -cI on the table and it did not > find eny problems. > > There is no update statistics in the program so I do not know where the > update statistics is coming from. I am working with our DBAs and we are> stuck and would appreciate any help. > > Database system: > Informix 7.31 on MPRAS UNIX > > Client System: > Visual Basic 6.0 dll in MTS > Informix ODBC driver 3.34 > > Thanks, Shannon