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

10.2 Table Versions and Naming Conventions
3PAR System Reporter User’s Guide System Reporter 2.8
10.2 Table Versions and Naming Conventions
All tables are versioned and their version number appears at the end of the table names.
Administrative tables contain only the base name and version number. For example policy_1
is the policy table and it is version 1.
The sample data tables and the inventory tables include the base name, sampling resolution
and the version number. For example, pdspace_hourly_3 contains the PD (physical disk)
space data for hourly resolution samples and the table is version 3. Similarly, the
pdspaceinv_hourly_2 table contains the inventory of the distinct PDs in the
pdspace_hourly_3 table and is of revision 2. Note that the revision number of the inventory
table need not be the same as the revision number of the data table whose inventory it
contains.
When System Reporter is upgraded some tables may need to be converted to new version
numbers. This is done automatically by the System Reporter when the sampling service starts.
10.3 Administrative Tables
The administrative tables are used to control the behavior of System Reporter and to keep
track of the InServ systems that are to be sampled.
10.3.1 The policy Table
The policy_1 table stores the names and values of the sampling policy parameters. There are a
fixed number of rows, one per parameter. The parameters are described in Table 7-1 on
page 7.2 .
Table 10-1. policy_1 Table
Column Type Comment
name VARCHAR(32)
PRIMARY KEY
Name of the policy parameter
val VARCHAR(255) Value of the policy parameter