Disabling AUS

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

Before you begin

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

About this task

To disable AUS, you must disable both the Auto Update Statistics Evaluation task and the Auto Update Statistics Refresh task:

Procedure

  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.

Example

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";