Logical-logs filling fast on IDS 11.5FC1

Hello everybody. I decided to start a new subject ´cause I´ve found on my logical-log several informix transactions, and I need to know if the sql trace impacts on my logical-logs, or if a common error that´s on my online.log is impacting: ------------------------------------------------- 14:05:37 SCHAPI: Error -214 Cannot remove file for table (informix.aus_cmd_list). 14:05:37 SCHAPI: Type: TASK, Name: Auto Update Statistics Evaluation, Location: NULL. 14:05:37 SCHAPI: Error -106 ISAM error: non-exclusive access. 14:05:37 SCHAPI: Type: TASK, Name: Auto Update Statistics Evaluation, Location: NULL. 14:05:37 SCHAPI: Type: TASK, Name: Auto Update Statistics Evaluation, Error Message: Unable to execute function [ aus_evaluator(integer,integer) ] . -------------------------------------------------- Obs: that error about auto update statitstics eval happens because the other process (auto update refresh) is running??? Regards for all.

Hmmmm.... You probably noticed an increment of logical logs because of the db scheduler. It's probably launching several scripts for information gathering... You have to check wha't happening with your sysadmin database... and the information collecting tables. If you don't use it, you can just stop the scheduler. Regards. On Wed, Sep 3, 2008 at 7:52 PM, ALEXANDRE MARINI <amarini@fazenda.ms.gov.br>wrote: > Hello everybody. > I decided to start a new subject ´cause I´ve found on my logical-log > several > informix transactions, and I need to know if the sql trace impacts on my > logical-logs, or if a common error that´s on my online.log is impacting: > ------------------------------------------------- > 14:05:37 SCHAPI: Error -214 Cannot remove file for table > (informix.aus_cmd_list). > 14:05:37 SCHAPI: Type: TASK, Name: Auto Update Statistics Evaluation, > Location: NULL. > 14:05:37 SCHAPI: Error -106 ISAM error: non-exclusive access. > 14:05:37 SCHAPI: Type: TASK, Name: Auto Update Statistics Evaluation, > Location: NULL. > 14:05:37 SCHAPI: Type: TASK, Name: Auto Update Statistics Evaluation, Error > Message: Unable to execute function [ aus_evaluator(integer,integer) ] . > -------------------------------------------------- > Obs: that error about auto update statitstics eval happens because the > other > process (auto update refresh) is running??? > > Regards for all. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently...