How to Turn Off Automated Update Statistics in IDS 11.50
Is there a way, or are there ways (GUI + command line/SQL API) to turn off AUS?
In sysadmin.ph_task set the column tk_enable to 'f'alse for all of the records with tk_group = 'PERFORMANCE' AND tk_name matches 'Auto Update Statistics*' Art Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. 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 Thu, Jun 11, 2009 at 11:17 AM, red_valsen@yahoo.com <red_valsen@yahoo.com > wrote: > Is there a way, or are there ways (GUI + command line/SQL API) to turn > off AUS? > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list >
red_valsen@yahoo.com schrieb: > Is there a way, or are there ways (GUI + command line/SQL API) to turn > off AUS? Hi, as I am testing IDS11.50.UC4 in the virtual appliance, where OAT is preistalled, I did what Art just posted and also was able switch it off and on using the OAT, tab 'schedules' Art's approach is the better one, as I cannot see me using OAT in a customer environment, which is under security auditing. So far I could not find any logging of what was done using OAT, 'inside OAT' or near it (that is: on the front end). Of course one can enable auditing for the sysadmin db But I am not finished with my exploring & testing. But if you use a shell script to run your updates on the sysadmin database, it is easy to log what was done when and even why. And as I described in the previous post, it is sufficient to bypass the startup of dbScheduler and dbWorker threads by creating a file named 'stop' in directory $INFORMIXDIR/etc/sysadmin and there will be no automatic update statistic. dic_k -- Richard Kofler SOLID STATE EDV Dienstleistungen GmbH Vienna/Austria/Europe