The statldrg_timeinv table, The perf_timeinv table, The space_timeinv table – HP 3PAR StoreServ 7000 Storage User Manual
Page 216
Table 93 statldrg_hourly_2 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 logical disk ID of the LD region.
INTEGER NOT NULL
ldid
Offset in MiB of the LD region.
INTEGER NOT NULL
ldoffmb
The VV ID for the LD region.
INTEGER NOT NULL
vvid
The VV space of the LD region.
VARCHAR(8) NOT NULL
vvspace
Offset in MiB in the VV space of the region.
INTEGER NOT NULL
vvoffmb
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.
INTEGER NOT NULL
tstamp
Total number of writes on the HP 3PAR StoreServ Storage.
WRITES DOUBLE
PRECISION NOT NULL
accesses
The statldrg_timeinv Table
The statldrg_timeinv_1 table holds the time inventory for the statldrg_hourly_2 table.
Table 94 statldrg_timeinv_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 perf_timeinv Table
The perf_timeinv_<res>_1 table holds the sample times for performance samples for each system.
Table 95 perf_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 space_timeinv Table
The space_timeinv_<res>_1 table holds the sample times for space samples for each system.
Table 96 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
216
Database Schema