HP 3PAR StoreServ 7400 2-node HP 3PAR System Reporter 3.1.0 Software User& - Page 196
The adprov_log Table, The ldrgmoves Table, Table 67 ldrgmoves_1 Table
View all HP 3PAR StoreServ 7400 2-node manuals
Add to My Manuals
Save this manual to your list of manuals |
Page 196 highlights
Table 65 adprovconfig_1 Table (continued) Column Type Comment ap_sched VARCHAR(200) NOT NULL The schedule for when this adaptive optimization configuration should be run. The format is a space-separated list of three items: the date 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. stats_hours INTEGER NOT NULL The number of hours for which the region statistics should be considered. ao_mode VARCHAR(32) NOT NULL One of three modes: • 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. ap_active INTEGER NOT NULL 0 - Configuration not active. 1 - Configuration is 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 Column adprovid start_tsecs end_tsecs status Type Comment INTEGER PRIMARY KEY A unique identifier for each adaptive optimization configuration. (AUTO_INCREMENT) INTEGER NOT NULL 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 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. VARCHAR(64) NOT NULL The status can be one of the following: • 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 Column sched_tsecs sys_uid Type INTEGER NOT NULL INTEGER NOT NULL Comment 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. A unique identifier for the system instance that refers to the uniq_id for the system instance in the system_3 table. 196 Database Schema