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

Table 85 statvlun__3 Table (continued)
Comment Type Column
The host WWN (world wide name) or iscsi name. VARCHAR(128) NOT
NULL host_wwn
The node that the port is connected to (the “n” part of n:s:p). INTEGER NOT NULL port_n
The PCI slot in the node that the port is connected to (the “s” part of
n:s:p). INTEGER NOT NULL port_s
The port number in the PCI slot in the node that the port is connected
to (the “p” part of n:s:p). INTEGER NOT NULL port_p
The rest of the columns are the common performance columns
described in
“Common Performance Table Columns” (page 203) ).
(common performance
columns)
The statvluninv Table
The statvluninv__4 table holds the inventory for statvlun__4 table.
Table 86 statvluninv__4 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 VLUN belongs to. If the VLUN is not
assigned to a domain, this column contains the value “-”. VARCHAR(32) NOT NULL dom_name
The VV name. VARCHAR(32) NOT NULL vv_name
The host name. VARCHAR(32) NOT NULL host_name
The LUN number. INTEGER NOT NULL lun
The host WWN (world wide name) or iscsi name. VARCHAR(128) NOT
NULL host_wwn
The node that the port is connected to (the “n” part of n:s:p). INTEGER NOT NULL port_n
The PCI slot in the node that the port is connected to (the “s” part of
n:s:p). INTEGER NOT NULL port_s
The port number in the PCI slot in the node that the port is connected
to (the “p” part of n:s:p). INTEGER NOT NULL port_p
The statvvcmp Table
The statvvcmp__2 table holds VV cache performance data samples.
Table 87 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_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
210 Database Schema