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

10.15 The Sample Data and Inventory Tables
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__3 table holds physical disk (PD) space data samples.
Table 10-11. pdspace__3 Table
Column Type Comment
tsecs INTEGER NOT
NULL
Sample time in secs. This is the Unix time
and is the number of seconds since
0:00:00 Jan 1, 1970 GMT.
sys_uid INTEGER NOT
NULL
A unique identifier for the InServ system
instance refers to the uniq_id for the
InServ system instance in the system_3
table
pdid INTEGER NOT
NULL
The physical disk ID.
cageid INTEGER NOT
NULL
The cage ID that the PD is in
cageside INTEGER NOT
NULL
The side of the disk chassis that the cage
is in.
mag INTEGER NOT
NULL
The magazine number in the cage that
the PD is in.
disk INTEGER NOT
NULL
The disk number in the magazine.