Step 2.4. Configure Logging Maintenance Events

Maintenance Events define when export, purge, and command actions will be performed on the table.

You can specify that maintenance be triggered when:

  • A condition, such as low disk space, occurs or
  • On a periodic or gated interval

Any specified event will trigger maintenance actions.

Select the Maintenance Events tab in a data Table Properties dialog box.

Configuration options are as follows.

1 Timed/gated maintenance
2 Triggered maintenance
1 Timed/gated maintenance

Specifies when maintenance will be triggered.

Use any combination of the options.

Option Description
Periodic Triggers maintenance at regular intervals. Configuration for the Periodic configuration group includes:
Checkbox Checked enables periodic maintenance.
Value field Enter the time value.
Interval field Select the time interval. Valid intervals are
  • minutes
  • hours
  • days
Synchronized Triggers maintenance at a selected time of day. Configuration for the Synchronized group includes:
Checkbox Checked enables synchronizing.
Time boxes Select hour (12 hours) and minutes.
AM/PM Select AM or PM from the drop-down list.
On digital point state Logs data while a digital point is in a selected state. Configuration for the On digital point state group includes:
Checkbox Checked enables On digital point state.
State Valid states in the drop-down list are:
  • high
  • low
  • transition (high or low state)
If a periodic time interval is specified Maintenance actions will be executed when the selected digital point is in the selected state. If a periodic time interval is not specified Maintenance actions are triggered when the specified digital point transitions to the selected state, or any time the digital point transitions (if transition is selected).
Point Valid states are HIGH, LOW, and TRANSITION. If a periodic time interval is specified, maintenance actions will be executed when the digital point you choose is in the selected state. If a periodic time interval is not specified, the maintenance actions are triggered when the specified digital point transitions to the selected state, or any time the digital point transitions (if transition is selected).

Up

2 Triggered maintenance

Specify if and when maintenance events should be triggered.

Use either or both of the following conditions.

Condition Description
Disk space low A drive's space falls below a specified size. Configuration for the Disk space low group includes:
Check box Checked enables Disk space low.
Drive Select the drive.
Space remaining Megabytes Maintenance events occur when space falls below the threshold specified in this field.
Note: The disk is checked at an interval that you specify on the Parameters tab the Logging Properties dialog box.
Logging count The logging count exceeds a specified number.
Check box Checked enables Logging count.
Field Number of records. Maintenance actions will be executed when the number of records logged to the table reaches a multiple of this number. Example You specify 500. Maintenance actions are executed when the count reaches 500, 1000, 1500, etc. Note: If you check both conditions maintenance is triggered when either condition occurs.
Important: Record deletion may not actually free disk space; this can depend your DBMS. Consult your DBMS documentation.

Up