The statqos table – HP 3PAR System Reporter Software User Manual

Page 219

Advertising
background image

Table 97 space_timeinv_<res>_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_<res>_1 table holds the QoS Performance data samples

Table 98

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 show 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

The Sample Data and Inventory Tables

219

Advertising