Purge Data From Selected Tables

You can configure a data purge for specific tables. You can select multiple tables (rows) using the SHIFT or CTRL keys or click the top left-most grid box (to the left of the Table column heading) to select all tables (rows). Use the Apply button at the bottom of the dialog box to change the retention period or records per batch and to enable the purge configuration for the selected tables.

NOTE: The first time you purge data, if you are purging data from Deleted_Variables, it may be more efficient to first purge data from the Tests table, then purge data from the Deleted Variables table and any other tables.

You cannot search for and select units if you select one or more of the following tables. Furthermore, if you select units on the Units tab, the retention period and records per batch cannot be changed for the following tables:

  • Events

  • GB_RSum

  • Production_Starts

  • Timed_Event_Details

  • User_Defined_Events

  • Waste_Event_Details

You cannot search for and select variables if you select the following table. Furthermore, if you select variables on the Variables tab, the retention period and records per batch cannot be changed for the following table:

  • Tests

To configure a data purge for selected tables

  1. Click Start, point to All Programs, point to Proficy Plant Applications Database Purge, and click Plant Applications Database Purge. The Plant Applications Purge Configuration dialog box appears.

  1. In the Max Purge Time box, enter the maximum number of minutes you want the purge to run.

    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.

     

  2. On the Tables tab, edit the retention period and records per batch, if desired. For instructions on editing retention periods and records per batch, see the topic Edit retention periods and records per batch.

  3. For each row (table) from which data is to be purged, select the Enabled box.

  4. If desired, click the Units (Event Based) or Variables (Time Based) tabs to purge data associated with units or variables. For instructions on purging data associated with units, see the topic Purge event-based data for selected units. For instructions on purging data associated with variables, see the topic Purge time-based data for selected variables.

  5. After you have configured your purge, save your configuration. For detailed instruction on saving a configuration, see the topic Save a purge configuration.

NOTE: You must save your configuration before you can run a purge.

Show video