User Manual

Table 85 statvlun_<res>_3 Table (continued)
CommentTypeColumn
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 NULLport_n
The PCI slot in the node that the port is connected to (the “s” part of
n:s:p).
INTEGER NOT NULLport_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 NULLport_p
The rest of the columns are the common performance columns
described in “Common Performance Table Columns” (page 205)).
(common performance
columns)
The statvluninv Table
The statvluninv_<res>_4 table holds the inventory for statvlun_<res>_4 table.
Table 86 statvluninv_<res>_4 Table
CommentTypeColumn
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 NULLtsecs
A unique identifier for the system instance refers to the uniq_id for
the system instance in the system_3 table.
INTEGER NOT NULLsys_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 NULLdom_name
The VV name.VARCHAR(32) NOT NULLvv_name
The host name.VARCHAR(32) NOT NULLhost_name
The LUN number.INTEGER NOT NULLlun
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 NULLport_n
The PCI slot in the node that the port is connected to (the “s” part of
n:s:p).
INTEGER NOT NULLport_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 NULLport_p
The statvvcmp Table
The statvvcmp_<res>_2 table holds VV cache performance data samples.
Table 87 statvvcmp_<res>_2 Table
CommentTypeColumn
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 NULLtsecs
A unique identifier for the system instance refers to the uniq_id for
the system instance in the system_3 table.
INTEGER NOT NULLsys_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 NULLdom_name
The VV ID.INTEGER NOT NULLvvid
212 Database Schema