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

The statvvcmp Table
The statvvcmp__2 table holds VV cache performance data samples.
Table 90 statvvcmp__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 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 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 91 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_4 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.
216 Database Schema