HP 3PAR System Reporter 3.1 MU2 Software User Guide

Table 99 space_timeinv_<res>_1 Table
CommentTypeColumn
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 NULLtsecs
A unique identifier for the system instance that refers to the uniq_id
for the system instance in the system_3 table.
INTEGER NOT NULLsys_uid
The statqos Table
The statqos_<res>_1 table holds the QoS Performance data samples
Table 100 statqos_<res>_1 Table
CommentTypeColumn
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 NULLtsecs
A unique identifier for the system instance refers to the uniq_id for
the system instance in the system_4 table.
INTEGER NOT NULLsys_uid
A unique identifier for QoS Rule.INTEGER NOT NULLid
QoS Rule target type.VARCHAR(32) NOT NULLtarget
QoS Rule NameVARCHAR(32) NOT NULLqos_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 NULLdom_name
QoS rule status (On/Off)INTEGER NOT NULLactive
QoS rule priority.INTEGER NOT NULLpriority
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 ValueINTEGER NOT NULLtl_min
Throttle Maximum ValueINTEGER NOT NULLtl_max
I/O Limit Value set created during QoS Rule.DOUBLE PRECISION NOT
NULL
io_limit
Guaranteed IODOUBLE PRECISION NOT
NULL
io_guarantee
Bandwidth Limit Value set created during QoS Rule.DOUBLE PRECISION NOT
NULL
bw_limit
Guaranteed BandwidthDOUBLE PRECISION NOT
NULL
bw_guarantee
Delayed I/O limit factorDOUBLE PRECISION NOT
NULL
io_delay_limit
220 Database Schema