HP 3PAR StoreServ 7200 2-node HP 3PAR System Reporter 3.1.0 Software User& - Page 192
Database Schema, Using The Database Schema, Table Versions and Naming Conventions
View all HP 3PAR StoreServ 7200 2-node manuals
Add to My Manuals
Save this manual to your list of manuals |
Page 192 highlights
9 Database Schema Using The Database Schema The description of the database schema is provided as a convenience to those wishing to query the database directly instead of using the web queries described in "Web Queries" (page 127). However, if you wish to write your own applications that directly query the database, it is important to note the following caution: CAUTION: The database schema may change between releases of the System Reporter and users must be prepared to revise their applications accordingly. HP does not provide direct assistance in generating SQL queries and only users who are confident of their own database expertise to use the schema description in this chapter should attempt to use it to create applications. Users may only issue queries that read the database, not alter it. 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. Administrative Tables The administrative tables are used to control the behavior of System Reporter and to keep track of the systems that are to be sampled. 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 54 (page 113). Table 59 policy_1 Table Column name val Type VARCHAR(32) PRIMARY KEY VARCHAR(255) Comment Name of the policy parameter Value of the policy parameter The sampleinserv Table The sampleinserv_5 table contains a row for each of systems that the System Reporter must sample. 192 Database Schema