System Reporter 2.8 | 3PAR System Reporter User’s Guide |
indexes on the data tables. To improve the efficiency of these queries, a separate set of inventory tables is maintained, one for each sample data table. The inventory tables contain a row for each distinct object in the corresponding sample data table. When the sampler inserts new samples into a table, or removes older samples from a table, it also updates the corresponding inventory table.
10.4.1 The pdspace Table
The pdspace_<res>_3 table holds physical disk (PD) space data samples.
Table
Column | Type | Comment |
|
|
|
tsecs | INTEGER NOT | Sample time in secs. This is the Unix time |
| NULL | and is the number of seconds since |
|
| 0:00:00 Jan 1, 1970 GMT. |
|
|
|
sys_uid | INTEGER NOT | A unique identifier for the InServ system |
| NULL | instance refers to the uniq_id for the |
|
| InServ system instance in the system_3 |
|
| table |
|
|
|
pdid | INTEGER NOT | The physical disk ID. |
| NULL |
|
|
|
|
cageid | INTEGER NOT | The cage ID that the PD is in |
| NULL |
|
|
|
|
cageside | INTEGER NOT | The side of the disk chassis that the cage |
| NULL | is in. |
|
|
|
mag | INTEGER NOT | The magazine number in the cage that |
| NULL | the PD is in. |
|
|
|
disk | INTEGER NOT | The disk number in the magazine. |
| NULL |
|
|
|
|
The Sample Data and Inventory Tables 10.15