User Manual

Table 87 statvvcmp_<res>_2 Table (continued)
CommentTypeColumn
The VV name.VARCHAR(32) NOT NULLvv_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_<res>_2 table holds the inventory for the statvvcmp_<res>_2 table.
Table 88 statvvcmpinv_<res>_2 Table
CommentTypeColumn
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 NULLtsecs
A unique identifier for the system instance refers to the uniq_id for
the system instance in the system_3 table.
INTEGER NOT NULLsys_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 NULLdom_name
The VV ID.INTEGER NOT NULLvvid
The VV name.VARCHAR(32) NOT NULLvv_name
The statcpu Table
The statcpu_<res>_1 table holds CPU performance data samples.
Table 89 statcpu_<res>_1 Table
CommentTypeColumn
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 NULLtsecs
A unique identifier for the system instance refers to the uniq_id for
the system instance in the system_3 table.
INTEGER NOT NULLsys_uid
The node number.INTEGER NOT NULLnode
The CPU number in the node.INTEGER NOT NULLcpu
Jiffies (0.01 sec) in user mode.DOUBLE PRECISION NOT
NULL
usert
The Sample Data and Inventory Tables 213