HP 3PAR System Reporter Software - Manual (Page 214)

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 inServ. 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__1 table holds the sample times for performance samples for each system.
Table 95 perf_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 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__1 table holds the sample times for space samples for each system.
Table 96 space_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 that refers to the uniq_id
for the system instance in the system_3 table. INTEGER NOT NULL sys_uid
214 Database Schema