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

Table 84 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 208) ).
(common performance
columns)
The statldinv Table
The statldinv__4 table holds the inventory for the statld__4 table
.
Table 85 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
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 statport Table
The statport__4 table holds port performance data samples.
Table 86 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_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 Sample Data and Inventory Tables 213