Disabling AUS

You can prevent statistics from being updated automatically by disabling the AUS maintenance system.

You must be connected to the sysadmin database as user informix or another authorized user.

To disable AUS, you must disable both the Auto Update Statistics Evaluation task and the Auto Update Statistics Refresh task:
  1. Update the value of the tk_enable column of the ph_task table to F where the value of the tk_name column is Auto Update Statistics Evaluation.
  2. Update the value of the tk_enable column of the ph_task table to F where the value of the tk_name column is Auto Update Statistics Refresh.
The following example disables both tasks:
UPDATE ph_task
SET tk_enable = "F"
WHERE tk_name = "Auto Update Statistics Evaluation";

UPDATE ph_task
SET tk_enable = "F"
WHERE tk_name = "Auto Update Statistics Refresh";

Copyright© 2018 HCL Technologies Limited