Purge Configuration dialog box

The data purge is configured through the Plant Applications Purge Configuration dialog box. There are three tabs that enable you to purge data:

  • Tables

  • Units (Event Based)

  • Variables (Time Based)

You can select tables or units or variables or a combination. When you select units or variables, the retention period and records per batch for certain tables cannot be edited on the Tables tab.

IMPORTANT: Before you start a data purge, you must stop the Plant Applications Manager service. When you stop this service, it will automatically stop all other services that must no be running during a data purge. For more information, see the topic Stop Plant Applications Manager in this help file.

Purge Configuration dialog box

A

The title bar displays the name of the configured purge ("Test Purge" in the preceding image). If no purge is configured, the title displays "Untitled."

B

The Server box displays the name of the server where the data to be purged resides. Click the drop-down arrow to select another server or click the Browse button to add a server.

C

The three tabs enable you to select how you want to purge data. You can purge data from tables, data associated with units, and data associated with time-based variables.

D

Max Purge Time is the maximum number of minutes that the purge will run. The program checks the maximum purge time only after the number of records per batch has been purged for a selected table, unit or variable. Even if the maximum purge time expires before the specified number of records has been purged, the batch will still complete.

E

Use the SHIFT key or CTRL key to select multiple rows, or click the top left-most grid box (to the left of the Table column heading) to select all rows.

F

If you select units or variables, you will not be able to edit the retention period or records per batch for some tables.

G

Clicking Apply will apply the values in Retention (Months) (H), Records Per Batch (I), and Enabled (J) for selected items. Keep in mind that clicking Apply will change every row that you have selected

H

Retention (Months) is the number of months of data you want to keep. Everything older will be purged when you run a configured purge. Used with the Apply button (G). When you add units or variables, the number in this box is the default.

I

Records Per Batch is the number of records per table or unit or variable that will be purged. Used with the Apply button (G). When you add units or variables, the number in this box is the default.

J

Select Enabled to enable purging for the selected tables when using the Apply button (G). This option is available only on the Tables tab.