beautypg.com

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

Page 213

background image

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

213