3PAR System Reporter User’s Guide | System Reporter 2.8 |
10.3.10 The recentsample Table
The recentsample_1 table contains a row for each sample resolution containing the time of the most recent sample for that resolution.
Beginning with the 2.4.1 release System Reporter inserts data from each InServ system into the database separately. Consequently, a given data table at a specific time may contain data from only some of the systems since the remaining systems’ data may not have been inserted yet. In order to avoid reporting on such partial samples, System Reporter updates the recentsample table with the time of the most recent complete sample for each resolution.
Table
Column | Type | Comment |
|
|
|
resolution | VARCHAR(32) NOT | The sample resolution, one of hires, hourly or |
| NULL | daily. |
|
|
|
tsecs | INTEGER NOT | Sample time in secs of the most recent complete |
| NULL | sample of the resolution. This is the Unix time |
|
| and is the number of seconds since 0:00:00 Jan 1, |
|
| 1970 GMT. |
|
|
|
10.4 The Sample Data and Inventory Tables
The sample data tables include the space and performance samples of various objects in the InServ systems. For each type of sample, there are three separate tables, one for each sampling resolution:
■hires - High resolution samples
■hourly - Hourly samples
■daily - Daily sample.
The tables for the different resolutions are identical in their structure. In the table names, the substring <res> can be replaced by either hires, hourly or daily.
The database often needs to be queried to determine all the objects that are present in the table. Often, this information is used to populate the menus in a web browser or Excel client. Since the data tables can be very large, this type of query can take a long time in spite of
10.14 The Sample Data and Inventory Tables