24 the statldrg table, The statldrg table – HP 3PAR System Reporter Software User Manual

Page 347

Advertising
background image

10.55

The Sample Data and Inventory Tables

System Reporter 2.8

3PAR System Reporter User’s Guide

10.4.24 The statldrg Table

The statldrg_hourly_1 table holds the LD region performance data. Only hourly samples are

kept.

Table 10-35. statldrg_hourly_1 Table

Column

Type

Comment

tsecs

INTEGER NOT NULL

Sample time in secs. This is the Unix time

and is the number of seconds since

0:00:00 Jan 1, 1970 GMT.

sys_uid

INTEGER NOT NULL

A unique identifier for the InServ system

instance refers to the uniq_id for the

InServ system instance in the system_3

table.

ldid

INTEGER NOT NULL

The logical disk ID of the LD region.

ldoffmb

INTEGER NOT NULL

Offset in MiB of the LD region.

vvid

INTEGER NOT NULL

The VV ID for the LD region.

vvspace

VARCHAR(8) NOT NULL

The VV space of the LD region.

vvoffmb

INTEGER NOT NULL

Offset in MiB in the VV space of the

region.

tstamp

INTEGER NOT NULL

Time stamp in secs for the start of the

counts. This is the Unix time and is the

number of seconds since 0:00:00 Jan 1,

1970 GMT.

accesses

DOUBLE PRECISION NOT

NULL

Total number of accesses (reads and

writes) to this region.

Advertising