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

Table 78 cpgspace_<res>_2 Table (continued)
Comment Type Column
The raw free space available for the CPG. DOUBLE PRECISION
NOT NULL rawfree_mb
The usable free space available for the CPG. DOUBLE PRECISION
NOT NULL usablefree_mb
The cpgspaceinv Table
The cpgspaceinv_<res>_2 table holds the inventory for the cpgspace_<res>2 table.
Table 79 cpgspace_<res>_2 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_4 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
This is to store the type of disk VARCHAR(32) NOT
NULL DISKTYPE
This is to store the raid level INTEGER(11) NOT
NULL RAID_TYPE
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 80 (page 208) .
Table 80 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.
208 Database Schema