beautypg.com

The statportinv table, The statvlun table, The statportinv table the statvlun table – HP 3PAR StoreServ 7000 Storage User Manual

Page 211

background image

Table 83 statport__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__4 table holds the inventory for the statport__4 table.

Table 84 statportinv__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__3 table holds VLUN performance data samples.

Table 85 statvlun__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