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

Table 87 statvvcmp__2 Table (continued)
Comment Type Column
The VV name. VARCHAR(32) NOT NULL vv_name
The number of read cache hits for the VV. DOUBLE PRECISION NOT
NULL rdhit
Difference between rdhit value from last sample for same VV. DOUBLE PRECISION NOT
NULL d_rdhit
The number of read cache misses for the VV. DOUBLE PRECISION NOT
NULL rdmiss
Difference between rdmiss value from last sample for same VV. DOUBLE PRECISION NOT
NULL d_rdmiss
The number of write cache hits for the VV. DOUBLE PRECISION NOT
NULL wrhit
Difference between wrhit value from last sample for same VV. DOUBLE PRECISION NOT
NULL d_wrhit
The number of write cache misses for the VV. DOUBLE PRECISION NOT
NULL wrmiss
Difference between wrmiss value from last sample for same VV. DOUBLE PRECISION NOT
NULL d_wrmiss
The statvvcmpinv Table
The statvvcmpinv__2 table holds the inventory for the statvvcmp__2 table.
Table 88 statvvcmpinv__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_3 table. INTEGER NOT NULL sys_uid
The domain name that the VV belongs to. If the VV is not assigned
to a domain, this column contains the value “-”. VARCHAR(32) NOT NULL dom_name
The VV ID. INTEGER NOT NULL vvid
The VV name. VARCHAR(32) NOT NULL vv_name
The statcpu Table
The statcpu__1 table holds CPU performance data samples.
Table 89 statcpu__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 node number. INTEGER NOT NULL node
The CPU number in the node. INTEGER NOT NULL cpu
Jiffies (0.01 sec) in user mode. DOUBLE PRECISION NOT
NULL usert
The Sample Data and Inventory Tables 211