18 the statvvcmp table, The statvvcmp table – HP 3PAR System Reporter Software User Manual
Page 339

10.47
The Sample Data and Inventory Tables
System Reporter 2.8
3PAR System Reporter User’s Guide
10.4.18 The statvvcmp Table
The statvvcmp_<res>_2 table holds VV cache performance data samples.
host_name
VARCHAR(32) NOT
NULL
The host name.
lun
INTEGER NOT
NULL
The LUN number.
host_wwn
VARCHAR(128)
NOT NULL
The host WWN (world wide name) or
iscsi name.
port_n
INTEGER NOT
NULL
The node that the port is connected to
(the “n” part of n:s:p).
port_s
INTEGER NOT
NULL
The PCI slot in the node that the port is
connected to (the “s” part of n:s:p).
port_p
INTEGER NOT
NULL
The port number in the PCI slot in the
node that the port is connected to (the
“p” part of n:s:p).
Table 10-28. statvluninv_<res>_2 Table
Column
Type
Comment
Table 10-29. statvvcmp_<res>_2 Table
Column
Type
Comment
tsecs
INTEGER NOT NULL
Sample time in secs. This is the Unix time
and is the number of seconds since
0:00:00 Jan 1, 1970 GMT.
sys_uid
INTEGER NOT NULL
A unique identifier for the InServ system
instance refers to the uniq_id for the
InServ system instance in the system_3
table.