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
Table
Column | Type | Comment |
|
|
|
name | VARCHAR(32) | Name of the policy parameter |
| PRIMARY KEY |
|
|
|
|
val | VARCHAR(255) | Value of the policy parameter |
|
|
|
10.2 | Table Versions and Naming Conventions |