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

The cpgspaceinv Table
The cpgspaceinv__1 table holds the inventory for the cpgspace_1 table.
Table 76 cpgspaceinv__1 Table
Comment Type Column
Sample time in secs. This is the Unix time and is the number of seconds
since 0:00:00 Jan 1, 1970 GMT. INTEGER NOT NULL tsecs
A unique identifier for the system instance refers to the uniq_id for the
system instance in the system_3 table. INTEGER NOT NULL sys_uid
The domain name that the CPG belongs to. If the CPG is not assigned
to a domain, this column contains the value “-”. VARCHAR(32) NOT
NULL dom_name
The common provisioning group ID. INTEGER NOT NULL cpgid
The common provisioning group name. VARCHAR(32) NOT
NULL cpg_name
Common Performance Table Columns
The statport, statvlun, statld and statpd tables all have a common set of columns for the performance
data. These columns are described in
Table 77 (page 203) .
Table 77 Common Performance Columns
Comment Type Column
Timestamp value indicating when the counting started (typically when
the system was rebooted or the device was created). Two count DOUBLE PRECISION
NOT NULL begin_msec
samples should only be compared if the begin value is the same for
the two samples. For example, the difference between rcount values
of two samples represents the number of read operations in the interval
between those samples only if the begin values are the same for those
samples.
Difference between begin value from last sample for the same object. DOUBLE PRECISION
NOT NULL d_begin_msec
Timestamp value in microseconds. The difference in the now values
of two samples should be used in calculating the time interval between
two samples DOUBLE PRECISION
NOT NULL now_msec
Difference between now value from last sample for the same object. DOUBLE PRECISION
NOT NULL d_now_msec
Queue length at the time of the sample. qlen is an instantaneous
measure, not an average queue length over the sample period. DOUBLE PRECISION
NOT NULL qlen
qlen may not be available for all objects and its value will be negative
to indicate that it is invalid.
Difference between qlen value from last sample for the same object. DOUBLE PRECISION
NOT NULL d_qlen
Time in microsecs that the device has been busy. DOUBLE PRECISION
NOT NULL busy
Difference between busy value from last sample for the same object. DOUBLE PRECISION
NOT NULL d_busy
Total number of reads since the object was first created or restarted. DOUBLE PRECISION
NOT NULL rcount
Difference between rcount value from last sample for the same object. DOUBLE PRECISION
NOT NULL d_rcount
The Sample Data and Inventory Tables 203