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

Page 303

Advertising
background image

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.

Advertising