Online.log error

Hello all, Can anyone shed any light on the following error..... Thanks in Advance.... HP-UX sleepy B.11.11 U 9000/800 2262126760 unlimited-user license IBM Informix Dynamic Server Version 11.50.FC3 -- On-Line -- Up 4 days 14:30:46 -- 6999772 Kbytes 01:09:40 SCHAPI: Error -1215 Value exceeds limit of INTEGER precision 01:09:40 SCHAPI: Type: TASK, Name: Auto Update Statistics Evaluation, Location: NULL. 01:09:40 SCHAPI: Type: TASK, Name: Auto Update Statistics Evaluation,Error Message: Unable to execute function [ aus_evaluator(integer,integer) ] .

The version of the AUS Evaluator (Auto Update Statistics) that you have cannot handle values greater than 2^31-1. This was fixed in a later release of 11.50 IB, or perhaps not until 11.70 I don't remember. A call to IBM support will get you the correct version to shoot for. You can upgrade to that release, or, for an immediate fix, use my dostats utility instead of AUS. Dostats is included in the utils2_ak package which you can download from the IIUG Software Repository for free (www.iiug.org/software). You can see instructions on how to use dostats to replace AUS in my BLOG entry from May of last year (informix-myview.blogspot.com). Dostats is faster and uses fewer resources than any current release of AUS when it runs. I also believe that it does a better job of producing the best stats. If you are not already an IIUG member I would encourage you to join, it's free and you help support the Informix community by increasing our leverage over IBM. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Fri, May 4, 2012 at 6:13 AM, howie.lfc@googlemail.com < howie.lfc@gmail.com> wrote: > Hello all, > > Can anyone shed any light on the following error..... > > Thanks in Advance.... > > HP-UX sleepy B.11.11 U 9000/800 2262126760 unlimited-user license > > > IBM Informix Dynamic Server Version 11.50.FC3 -- On-Line -- Up 4 > days 14:30:46 -- 6999772 Kbytes> > > 01:09:40 SCHAPI: Error -1215 Value exceeds limit of INTEGER precision > 01:09:40 SCHAPI: Type: TASK, Name: Auto Update Statistics Evaluation, > Location: NULL. > 01:09:40 SCHAPI: Type: TASK, Name: Auto Update Statistics Evaluation,> Error Message: Unable to execute function > [ aus_evaluator(integer,integer) ] . > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list >