The statldinv table, The statport table, The statldinv table the statport table – HP 3PAR StoreServ 7000 Storage User Manual
Page 210
Table 81 statld_<res>_5 Table (continued)
Comment
Type
Column
The node that owns the LD
INTEGER NOT NULL
node
The name of the CPG that the LD belongs to. If the LD is not in a CPG,
this column contains the value “----”.
VARCHAR(32) NOT
NULL
cpg_name
The rest of the columns are the common performance columns described
in
“Common Performance Table Columns” (page 205)
).
(common performance
columns)
The statldinv Table
The statldinv_<res>_4 table holds the inventory for the statld_<res>_5 table
.
Table 82 statldinv_<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 domain name that the LD belongs to. If the LD is not assigned
to a domain, this column contains the value “-”.
VARCHAR(32) NOT
NULL
dom_name
The logical disk ID.
INTEGER NOT NULL
ldid
The node that owns the LD.
INTEGER NOT NULL
node
The name of the CPG that the LD belongs to. If the LD is not in a
CPG, this column contains the value “----”.
VARCHAR(32) NOT
NULL
cpg_name
The statport Table
The statport_<res>_4 table holds port performance data samples.
Table 83 statport_<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 - 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.
210
Database Schema