HP 3PAR System Reporter Software - Manual (Page 194)

Table 65 adprovconfig_1 Table
Comment Type Column
A unique identifier for each adaptive optimization configuration. INTEGER PRIMARY KEY
(AUTO_INCREMENT) adprovid
The system name. VARCHAR(32) NOT
NULL sysname
Tier 0 CPG name. If there is no tier 0, this should be the empty string. VARCHAR(32) NULL t0_cpg_name
Tier 1 CPG name. If there is no tier 1, this should be the empty string. VARCHAR(32) NULL t1_cpg_name
Tier 2 CPG name. If there is no tier 2, this should be the empty string. VARCHAR(32) NULL t2_cpg_name
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.
194 Database Schema