Auto Update Statstics

IDS 11.5 FC5 Linux (suse 10.2) I get the following errors when I try to run auto update stats... any ideas? (I have already restarted the instance.) 09:21:52 SCHAPI: Error -214 Cannot remove file for table (informix.aus_command). 09:21:52 SCHAPI: Type: TASK, Name: Auto Update Statistics Evaluation, Location: NULL. 09:21:52 SCHAPI: Error -106 ISAM error: non-exclusive access. 09:21:52 SCHAPI: Type: TASK, Name: Auto Update Statistics Evaluation, Location: NULL. 09:21:52 SCHAPI: Type: TASK, Name: Auto Update Statistics Evaluation, Error Message: Unable to execute function [ aus_evaluator(integer,integer) ] . Thanks Laurie Laurie Gustin IT Programmer Analyst Department of Public Safety lgustin@utah.gov 801-965-4410

Had you recently upgraded to 11.50.FC5 from an earlier version? If that´s your case, reconstruct your sysadmin database could solve the question. Regards. Alexandre Marini Tecnologia da Informação - DBA SEFAZ-MS / SGI-UIMP / Sistemas IBM-Informix IIUG Member <http://www.iiug.org>; Laurie Gustin escreveu: > IDS 11.5 FC5 > Linux (suse 10.2) > > I get the following errors when I try to run auto update stats... any ideas? > (I have already restarted the instance.) > > 09:21:52 SCHAPI: Error -214 Cannot remove file for table > (informix.aus_command). > 09:21:52 SCHAPI: Type: TASK, Name: Auto Update Statistics Evaluation, > Location: NULL. > 09:21:52 SCHAPI: Error -106 ISAM error: non-exclusive access. > 09:21:52 SCHAPI: Type: TASK, Name: Auto Update Statistics Evaluation, > Location: NULL. > 09:21:52 SCHAPI: Type: TASK, Name: Auto Update Statistics Evaluation, Error > Message: Unable to execute function [ aus_evaluator(integer,integer) ] . > Thanks > Laurie > > Laurie Gustin > IT Programmer Analyst > Department of Public Safety > lgustin@utah.gov > 801-965-4410 > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > > >