3PAR System Reporter User’s Guide

System Reporter 2.8

Table 10-7.adprovconfig_1 Table

 

Column

Type

Comment

 

 

 

t0_cpg_name

VARCHAR(32) NOT

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

 

NULL

should be the empty string.

 

 

 

t1_cpg_name

VARCHAR(32) NOT

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

 

NULL

should be the empty string.

 

 

 

t2_cpg_name

VARCHAR(32) NOT

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

 

NULL

should be the empty string.

 

 

 

ap_sched

VARCHAR(200) NOT

The schedule for when this adaptive

 

NULL

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

One of three modes:

 

NULL

■ 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.

 

 

 

10.10 Administrative Tables