The statportinv table, The statvlun table, The statportinv table the statvlun table – HP 3PAR StoreServ 7000 Storage User Manual
Page 211
Table 83 statport_<res>_4 Table (continued)
Comment
Type
Column
•
iscsi - iSCSI host ports.
•
free - ports that are not connected.
The rest of the columns are the common performance columns
described in
“Common Performance Table Columns” (page 205)
).
(common performance
columns)
The statportinv Table
The statportinv_<res>_4 table holds the inventory for the statport_<res>_4 table.
Table 84 statportinv_<res>_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 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 port type. Currently, the port types are:
VARCHAR(32) NOT
NULL
porttype
•
disk - fiber channel ports that disks are connected to.
•
host -.fiber channel ports that hosts are connected to (directly or
through a fabric.
•
rcip - Remote Copy IP ports.
•
rcfc - Remote Copy fiber channel ports.
•
iscsi - iSCSI host ports.
•
free - ports that are not connected.
The statvlun Table
The statvlun_<res>_3 table holds VLUN performance data samples.
Table 85 statvlun_<res>_3 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 Sample Data and Inventory Tables
211