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

Table 67 ldrgmoves_1 Table
Comment Type Column
Time in secs when the LD region move was scheduled. This is the
Unix time and is the number of seconds since 0:00:00 Jan 1, 1970
GMT. INTEGER NOT NULL sched_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
A unique identifier for each adaptive optimization configuration. INTEGER PRIMARY KEY
(AUTO_INCREMENT) adprovid
The logical disk ID of the source LD region. INTEGER NOT NULL ldid
The LD name of the source LD region. VARCHAR(32) NOT NULL ld_name
Offset in MiBs of the source LD region. INTEGER NOT NULL ldoffmb
The VV ID for the source LD region. INTEGER NOT NULL vvid
The VV space of the source LD region. VARCHAR(8) NOT NULL vvspace
Offset in MiBs in the VV space of the region. INTEGER NOT NULL vvoffmb
Specifies the source tier. INTEGER NOT NULL src_tier
Specifies the destination tier. INTEGER NOT NULL dst_tier
Specifies the destination CPG name. VARCHAR(32) NOT NULL dst_cpgname
The reason for the move, can be one of the following: VARCHAR(32) NOT NULL move_reason
•
busy_space - Busy region moved to faster tier because of lack
of space in source tier.
• busiest - Busiest region moved to faster tier since it met movement
criteria.
•
idle_space - Idle region moved to slower tier because of lack of
space in source tier.
•
idlest - Idlest region moved to slower tier since it met movement
criteria.
•
zero - Regions not accessed at all moved to slowest tier.
The status can be one of the following VARCHAR(64) NOT NULL status
• scheduled - The LD region move has been scheduled.
•
issued - The CLI command to execute the LD region move has
been issued.
• done - The LD region move has completed.
•
cancelled - The LD region move has been cancelled.
Time in secs when the LD region move was done. This is the Unix
time and is the number of seconds since 0:00:00 Jan 1, 1970
GMT. INTEGER NOT NULL done_tsecs
The recentsample Table
The recentsample_1 table contains a row for each sample resolution containing the time of the
most recent sample for that resolution.
Beginning with the 2.4.1 release System Reporter inserts data from each system into the database
separately. Consequently, a given data table at a specific time may contain data from only some
of the systems since the remaining systems’ data may not have been inserted yet. In order to avoid
reporting on such partial samples, System Reporter updates the recentsample table with the time
of the most recent complete sample for each resolution.
Administrative Tables 195