HP 3PAR StoreServ 7000 Storage - Manual (Page 196)

Table 65 adprovconfig_1 Table (continued)
Comment Type Column
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 NULL stats_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 NULL ap_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
Comment Type Column
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 NULL start_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 NULL end_tsecs
The status can be one of the following: VARCHAR(64) NOT NULL status
•
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
Comment Type Column
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 NULL sched_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 NULL sys_uid
196 Database Schema