User Manual

Table 65 adprovconfig_1 Table (continued)
CommentTypeColumn
The schedule for when this adaptive optimization configuration should
be run. The format is a space-separated list of three items: the date
VARCHAR(200) NOT
NULL
ap_sched
list, the weekday list and the hour list. Each of these three lists is
either a “*” or a comma-separated list of individual dates, weekdays
and hours respectively.
The number of hours for which the region statistics should be
considered.
INTEGER NOT NULLstats_hours
One of three modes:VARCHAR(32) NOT
NULL
ao_mode
• Performance - Configuration is biased to move data towards faster
tiers.
• Balanced - Configuration determines appropriate distribution
between Performance and Cost.
• Cost - Configuration is biased to move data towards slower (less
costly) tiers.
0 - Configuration not active. 1 - Configuration is active.INTEGER NOT NULLap_active
The adprov_log Table
The adprov_log_1 table is used to keep track of when each adaptive optimization configuration
has been executed.
Table 66 adprov_log_1 Table
CommentTypeColumn
A unique identifier for each adaptive optimization configuration.INTEGER PRIMARY KEY
(AUTO_INCREMENT)
adprovid
Time in secs when the adaptive optimization configuration was started.
This is the Unix time and is the number of seconds since 0:00:00 Jan
1, 1970 GMT.
INTEGER NOT NULLstart_tsecs
Time in secs when the adaptive optimization configuration ended.
This is the Unix time and is the number of seconds since 0:00:00 Jan
1, 1970 GMT.
INTEGER NOT NULLend_tsecs
The status can be one of the following:VARCHAR(64) NOT NULLstatus
• started - Execution has started for the configuration.
• done - Execution completed without error for the configuration.
• error - Execution encountered an error.
The ldrgmoves Table
The ldrgmoves_1 table is used to keep track of the LD region moves generated for each adaptive
optimization configuration that has been executed.
Table 67 ldrgmoves_1 Table
CommentTypeColumn
Time in secs when the LD region move was scheduled. This is the
Unix time and is the number of seconds since 0:00:00 Jan 1, 1970
GMT.
INTEGER NOT NULLsched_tsecs
A unique identifier for the system instance that refers to the uniq_id
for the system instance in the system_3 table.
INTEGER NOT NULLsys_uid
196 Database Schema