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

Table 68 adprovconfig_1 Table (continued)
Comment Type Column
Maximum size of the storage space that can be used for the T0 tier INTEGER NOT NULL T0_GB
Maximum size of the storage space that can be used for the T1 tier INTEGER NOT NULL T1_GB
Maximum size of the storage space that can be used for the T2 tier INTEGER NOT NULL T2_GB
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 69 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.
Administrative Tables 199