HP 3PAR System Reporter Software User Manual

Page 302

Advertising
background image

10.10

Administrative Tables

3PAR System Reporter User’s Guide

System Reporter 2.8

t0_cpg_name

VARCHAR(32) NOT

NULL

Tier 0 CPG name. If there is no tier 0, this

should be the empty string.

t1_cpg_name

VARCHAR(32) NOT

NULL

Tier 1 CPG name. If there is no tier 1, this

should be the empty string.

t2_cpg_name

VARCHAR(32) NOT

NULL

Tier 2 CPG name. If there is no tier 2, this

should be the empty string.

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.

Table 10-7. adprovconfig_1 Table

Column

Type

Comment

Advertising