Rescheduling AUS

You can change when and for how long the Auto Update Statistics Refresh task runs.

Before you begin

Updating statistics is resource-intensive. Therefore, by default, statistics are automatically updated on Saturdays and Sundays between 1:00 AM and 5:00 AM. If you find that not all pending UPDATE STATISTICS statements can be run in this time period, or you want statistics to be refreshed more often, you can change the start time, the end time, and the days of the week to perform this task.

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

About this task

To change the schedule of the Auto Update Statistics Refresh task, update the ph_task table where the value of the tk_name column is Auto Update Statistics Refresh.

Example

The following example changes the ending time of the task to 6:00 AM:

UPDATE ph_task
SET tk_stop_time = "06:00:00"
WHERE tk_name = "Auto Update Statistics Refresh";

The following example changes the days that the task is run to every day of the week (Saturday and Sunday are enabled by default):

UPDATE ph_task
SET tk_monday = "T",
tk_tuesday = "T",
tk_wednesday = "T",
tk_thursday = "T",
tk_friday = "T"
WHERE tk_name = "Auto Update Statistics Refresh";