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

Table 99 space_timeinv__1 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 that refers to the uniq_id
for the system instance in the system_3 table. INTEGER NOT NULL sys_uid
The statqos Table
The statqos__1 table holds the QoS Performance data samples
Table 100 statqos__1 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
A unique identifier for QoS Rule. INTEGER NOT NULL id
QoS Rule target type. VARCHAR(32) NOT NULL target
QoS Rule Name VARCHAR(32) NOT NULL qos_name
The domain name that the QoS Rule belongs to. If the QoS Rule
is not assigned to a domain, this column contains the value “-”. VARCHAR(32) NOT NULL dom_name
QoS rule status (On/Off) INTEGER NOT NULL active
QoS rule priority. INTEGER NOT NULL priority
I/O limit value set created during QoS Rule (used in future release
to show the permanent value). DOUBLE PRECISION NOT
NULL io_limit_p
Guaranteed IO (used in future release shows the permanent value). DOUBLE PRECISION NOT
NULL io_guarantee_p
Bandwidth limit (used in future release for permanent value). DOUBLE PRECISION NOT
NULL bw_limit_p
Guaranteed bandwidth (used in future to show permanent value). DOUBLE PRECISION NOT
NULL bw_guarantee_p
Latency target (used in future to show permanent value). DOUBLE PRECISION NOT
NULL lt_target_p
Throttle Minimum Value INTEGER NOT NULL tl_min
Throttle Maximum Value INTEGER NOT NULL tl_max
I/O Limit Value set created during QoS Rule. DOUBLE PRECISION NOT
NULL io_limit
Guaranteed IO DOUBLE PRECISION NOT
NULL io_guarantee
Bandwidth Limit Value set created during QoS Rule. DOUBLE PRECISION NOT
NULL bw_limit
Guaranteed Bandwidth DOUBLE PRECISION NOT
NULL bw_guarantee
Delayed I/O limit factor DOUBLE PRECISION NOT
NULL io_delay_limit
220 Database Schema