The recentsample table – HP 3PAR StoreServ 7000 Storage User Manual
Page 197
Table 67 ldrgmoves_1 Table (continued)
Comment
Type
Column
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
197