Auto Update Stats
Hi,
I want to implement AUS in informix 11.70.UC7X3.
Here I have the below configuration set in mon_table_profile:
sysadmin> select
tk_id,tk_name,tk_result_table,tk_start_time,tk_stop_time,tk_frequency,tk_next_ex
ecution,tk_total_executions,tk_total_time,tk_enable,tk_attributes from ph_task
where tk_name like 'mon_table_profile%';
tk_id tk_name tk_result_table tk_start_time tk_stop_time tk_frequency
tk_next_execution tk_total_executions tk_total_time tk_enable tk_attributes
----- ----------------- ----------------- ------------- ------------
---------------- ------------------- ------------------- -------------
--------- -------------
9 mon_table_profile mon_table_profile None None 1 00:00:00.00000 2013-07-01
08:00:00 47 4.85406121705 True 405
So my mon_table_profile task runs at 8AM daily.
The configuration of Auto Update Statistics Evaluation and Auto Update
Statistics Refresh is given below:
sysadmin> select
tk_id,tk_name,tk_result_table,tk_start_time,tk_stop_time,tk_frequency,tk_next_ex
ecution,tk_total_executions,tk_total_time,tk_enable,tk_attributes from ph_task
where tk_name like 'Auto%';
tk_id tk_name tk_result_table tk_start_time tk_stop_time tk_frequency
tk_next_execution tk_total_executions tk_total_time tk_enable tk_attributes
----- --------------------------------- --------------- -------------------
------------------- ---------------- ------------------- -------------------
------------- --------- -------------
32 Auto Update Statistics Evaluation None 0001-01-01 01:00:00 0001-01-01
01:10:00 0 00:02:00.00000 2013-07-01 01:00:00 17 61.9927676091 True 412
33 Auto Update Statistics Refresh None 0001-01-01 00:30:00 0001-01-01 23:00:00
0 00:05:00.00000 2013-06-30 11:20:00 567 2386.74130546 True 412
Here Auto Update Statistics Evaluation task runs every 2 minutes between 1AM
and 1:10 AM.
Auto Update Statistics Refresh task runs every 5 minutes between 12:30AM to
11PM daily
These configurations settings are just for testing purpose.
Now when i check the ph_run for task mon_table_profile then it consists of
below data:
2061 9 36 0 2013-06-29 01:00:00 0.0476851274542 1372263685 1372263685
1372447800
2063 9 37 0 2013-06-29 01:02:00 0.0272944318896 1372263685 1372263685
1372447920
2065 9 38 0 2013-06-29 01:04:00 0.0240780813374 1372263685 1372263685
1372448040
2068 9 39 0 2013-06-29 01:06:00 0.0306654601532 1372263685 1372263685
1372448160
2070 9 40 0 2013-06-29 01:08:00 0.0272276235958 1372263685 1372263685
1372448280
2205 9 41 0 2013-06-29 08:00:00 0.0338935623897 1372263685 1372263685
1372473000
2514 9 42 0 2013-06-30 01:00:00 0.0260356434164 1372263685 1372263685
1372534200
2516 9 43 0 2013-06-30 01:02:00 0.0366764198257 1372263685 1372263685
1372534320
2518 9 44 0 2013-06-30 01:04:00 0.0305241866686 1372263685 1372263685
1372534440
2521 9 45 0 2013-06-30 01:06:00 0.0816177633482 1372263685 1372263685
1372534560
2523 9 46 0 2013-06-30 01:08:00 0.0747336227492 1372263685 1372263685
1372534680
2658 9 47 0 2013-06-30 08:00:00 0.0339980172957 1372263685 1372263685
1372559400
Now my question is although my mon_table_profile is set at 8 AM daily then why
there is an entry for 1AM to 1:08AM as well in ph_run. is it because of Auto
Update Statistics Evaluation means when Evaluation task runs thenmon_table_profile task also runs. Please confirm