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

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.