Download Embedding IBM Informix

9.5 Predefined tasks and sensors
Informix Version 11 comes with predefined tasks and sensors. They are used to
collect information from the system and to automate tasks such as updating table
statistics. Table 9-6 describes the current set of tasks that come with
Informix Version 11. New tasks may appear in future releases and updates of
Informix.
Table 9-6 Predefined tasks
Task
Description
add_storage
[task] Add storage.
Alert Cleanup
[task] Remove all old alert entries from ph_alert.
auto_crsd
[task] Automatic Compress/Repack/Shrink and
Defrag (the default is disabled).
autoreg exe
[task] Register a database extension on first use.
autoreg migrate-console
[startup sensor] Internal task used in upgrades.
autoreg vp
[task] Create a VP on first use.
auto_tune_cpu_vps
[startup task] Automatically allocate additional
CPU VPs at system start. (the default is disabled).
Auto Update Statistics Evaluation
[task] Evaluate which columns and tables should
have the statistics and distributions refreshed.
Auto Update Statistics Refresh
[task] Refreshes the statistics and distributions
that were recommended by the evaluator.
bad_index_alert
[task] Find indices marked as bad and create
alerts (the default is disabled).
check_backup
[task] Check to ensure a backup has been taken
of the data server.
check_for_ipa
[task] Find tables with outstanding in place alters
(the default is disabled).
idle_user_timeout
[task] Terminate idle users (the default is
disabled).
ifx_ha_monitor_log_replay_task
[task] Monitor HA secondary log replay position.
Job Results Cleanup
[task] Remove all old job results entries from the
system.
Chapter 9. Automating management through tasks and sensors
215