Re: Question: UPDATE STATISTICS and CPU usage

tim_lim@dalsys.com.au wrote: > >georg@cyberdude.com wrote: > > > > While running UPDATE STATISTICS HIGH FOR table (colname) on a big > > table we have the effect that nobody can connect to the informix engine > > anymore (no matter to which database). We are running Informix 7.23 on a > > single processor HP machine. It seems that it is not a locking problem. > > Could it be that the Update Statistics statement uses up all the CPU > > power? > > Has anybody had similar experiences and had found a solution to the > > problem? > > The only way to avoid this situation is do not run update statistics > while the DB is being used by user. I can see in the 7.23 release note > that refer to bug # 62002 relating to update statistics. Bug 62002 is fixed in 7.23. I don't know what the problem is, but if it really is because the UPDATE STATISTICS is hogging the CPU VP, try adding another CPU VP (this should only happen if you only have one CPU VP in the first place -- then the UPDATE STATS could monopolize the CPU VP). When you say that no one else can connect, no matter which database, do you mean other databases within the same instance? -- June ---- June Tong Informix Software ---- ---- Senior Consultant (650) 926-6140 ---- ---- International Support junet@informix.com ---- ---- Location-du-jour: Menlo Park ----