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

Table 86 statport_<res>_4 Table (continued)
Comment Type Column
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 - Fibre channel ports that disks are connected to.
•
host -.Fibre channel ports that hosts are connected to (directly or
through a fabric).
•
rcip - Remote Copy IP ports.
•
rcfc - Remote Copy fibre channel ports.
• iscsi - iSCSI host ports.
•
free - ports that are not connected.
This is to store the port speed in Giga bits per second. INTEGER(11) NOT NULL gbitps
The rest of the columns are the common performance columns
described in
“Common Performance Table Columns” (page 208) ).
(common performance
columns)
The statportinv Table
The statportinv_<res>_4 table holds the inventory for the statport_<res>_4 table.
Table 87 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_4 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.
This is to store the port speed in Giga bits per second. INTEGER(11) NOT NULL gbitps
The statvlun Table
The statvlun_<res>_4 table holds VLUN performance data samples.
214 Database Schema