8 the adprov_log table, The adprov_log table – HP 3PAR System Reporter Software User Manual
Page 303

10.11
Administrative Tables
System Reporter 2.8
3PAR System Reporter User’s Guide
10.3.8 The adprov_log Table
The adprov_log_1 table is used to keep track of when each adaptive optimization
configuration has been executed.
Table 10-8. adprov_log_1 Table
Column
Type
Comment
adprovid
INTEGER PRIMARY
KEY
(AUTO_INCREMENT)
A unique identifier for each adaptive
optimization configuration.
start_tsecs
INTEGER NOT NULL
Time in secs when the adaptive
optimization configuration was started.
This is the Unix time and is the number
of seconds since 0:00:00 Jan 1, 1970
GMT.
end_tsecs
INTEGER NOT NULL
Time in secs when the adaptive
optimization configuration ended. This
is the Unix time and is the number of
seconds since 0:00:00 Jan 1, 1970 GMT.
status
VARCHAR(64) NOT
NULL
The status can be one of the following:
■
started - Execution has started for the
configuration.
■
done - Execution completed without
error for the configuration.
■
error - Execution encountered an error.