HP 3PAR StoreServ 7000 Storage - Manual (Page 210)

Table 81 statld__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__4 table holds the inventory for the statld__5 table
.
Table 82 statldinv__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__4 table holds port performance data samples.
Table 83 statport__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