Re: Implict Update Statistics

I don't remember full details but I've ran into this problem myself. I believe it was an ODBC configuration issue on the windows side, having an Auto Commit Optimization flag turned on or something of that nature. HTH Dave Griffen "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 > >