The cpgspaceinv table, Common performance table columns – HP 3PAR StoreServ 7000 Storage User Manual

Page 205

Advertising
background image

The cpgspaceinv Table

The cpgspaceinv_<res>_1 table holds the inventory for the cpgspace_<res>1 table.

Table 76 cpgspaceinv_<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 refers to the uniq_id for the
system instance in the system_3 table.

INTEGER NOT NULL

sys_uid

The domain name that the CPG belongs to. If the CPG is not assigned
to a domain, this column contains the value “-”.

VARCHAR(32) NOT
NULL

dom_name

The common provisioning group ID.

INTEGER NOT NULL

cpgid

The common provisioning group name.

VARCHAR(32) NOT
NULL

cpg_name

Common Performance Table Columns

The statport, statvlun, statld and statpd tables all have a common set of columns for the performance
data. These columns are described in

Table 77 (page 205)

.

Table 77 Common Performance Columns

Comment

Type

Column

Timestamp value indicating when the counting started (typically when
the system was rebooted or the device was created). Two count

DOUBLE PRECISION
NOT NULL

begin_msec

samples should only be compared if the begin value is the same for
the two samples. For example, the difference between rcount values
of two samples represents the number of read operations in the interval
between those samples only if the begin values are the same for those
samples.

Difference between begin value from last sample for the same object.

DOUBLE PRECISION
NOT NULL

d_begin_msec

Timestamp value in microseconds. The difference in the now values
of two samples should be used in calculating the time interval between
two samples

DOUBLE PRECISION
NOT NULL

now_msec

Difference between now value from last sample for the same object.

DOUBLE PRECISION
NOT NULL

d_now_msec

Queue length at the time of the sample. qlen is an instantaneous
measure, not an average queue length over the sample period.

DOUBLE PRECISION
NOT NULL

qlen

qlen may not be available for all objects and its value will be negative
to indicate that it is invalid.

Difference between qlen value from last sample for the same object.

DOUBLE PRECISION
NOT NULL

d_qlen

Time in microsecs that the device has been busy.

DOUBLE PRECISION
NOT NULL

busy

Difference between busy value from last sample for the same object.

DOUBLE PRECISION
NOT NULL

d_busy

Total number of reads since the object was first created or restarted.

DOUBLE PRECISION
NOT NULL

rcount

Difference between rcount value from last sample for the same object.

DOUBLE PRECISION
NOT NULL

d_rcount

The Sample Data and Inventory Tables 205

Advertising