The statvvcmpinv table, The statcpu table – HP 3PAR StoreServ 7000 Storage User Manual

Page 213

Advertising
background image

Table 87 statvvcmp_<res>_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_<res>_2 table holds the inventory for the statvvcmp_<res>_2 table.

Table 88 statvvcmpinv_<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_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_<res>_1 table holds CPU performance data samples.

Table 89 statcpu_<res>_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

213

Advertising