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

Table 82 statld__5 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 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
This is to preserve the LD. VARCHAR(32) NULL LD_NAME
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 207) ).
(common performance
columns)
The statldinv Table
The statldinv__4 table holds the inventory for the statld__5 table
.
Table 83 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_4 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 84 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
This is to store the port speed in Giga bits per second. INTEGER(11) NOT NULL GBITPS
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
212 Database Schema