
Table 62 alertconfig_2 Table (continued)
CommentTypeColumn
Defines an additional condition that must be met for certain alerts
to be generated. See “Condition” (page 121).
VARCHAR(32)condition_code
Defines a value used in conjunction with condition_code. See
“Condition Value” (page 121).
DOUBLE PRECISION
NOT NULL
condition_val
The email address to which alerts for this rule should be sent.VARCHAR(64)recipient
The scheduled_report Table
The scheduled_report_2 table contains a row for each scheduled report and defines where the
report should be stored, when it should be run and parameters used to generate the report.
Table 63 scheduled_report_2 Table
CommentTypeColumn
A unique identifier for each scheduled report.INTEGER PRIMARY KEY
(AUTO_INCREMENT)
rpt_id
The top level report directory (under the 3par/
scheduledreports/ directory).
VARCHAR(64) NOT NULLrpt_dir
The report name. A sub-directory of this name is created (under
the rpt_dir directory) in which all scheduled reports are created.
VARCHAR(64) NOT NULLrpt_name
The schedule for this report. The format is a space-separated list
of three items: the date list, the weekday list and the hour list.
VARCHAR(200) NOT
NULL
rpt_sched
Each of these three lists is either a “*” or a comma-separated list
of individual dates, weekdays and hours respectively.
The report’s URL parameters (after the “?” in the URL).VARCHAR(4000) NOT
NULL
rpt_url
0 - Report is not active. 1 - Report is active.INTEGER NOT NULLrpt_active
The time when this scheduled report was created.VARCHAR(64) NOT NULLrpt_createtime
The number of days for which created reports should be kept.
Reports that are older are automatically deleted.
INTEGER NOT NULLrpt_retentiondays
The email address for delivery of scheduled reports.VARCHAR(1000)
COMMA SEPARATED
RPT_EMAIL
The scheduled_report_log Table
The scheduled_report_log_1 table is used to keep track of when each scheduled report has run.
Table 64 scheduled_report_log_1 Table
CommentTypeColumn
A unique identifier for each scheduled
report.
INTEGER PRIMARY KEY
(AUTO_INCREMENT)
rpt_id
The time the report was started.VARCHAR(64) NOT NULLrpt_run_start_time
The time the report finished executing.VARCHAR(64) NOT NULLrpt_run_end_time
The hour that the report ran.INTEGERrpt_run_hr
The status for the report.INTEGERrpt_run_status
The adprovconfig Table
The adprovconfig_1 table has a row for each adaptive optimization configuration.
Administrative Tables 193
Comentarios a estos manuales