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
Column | Type | Comment |
|
|
|
adprovid | INTEGER PRIMARY | A unique identifier for each adaptive |
| KEY | optimization configuration. |
| (AUTO_INCREMENT) |
|
|
|
|
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 | The status can be one of the following: |
| NULL | ■ started - Execution has started for the |
|
| configuration. |
|
| ■ done - Execution completed without |
|
| error for the configuration. |
|
| ■ error - Execution encountered an error. |
|
|
|
Administrative Tables 10.11