Purging data

Use this procedure to purge data from the database. Performing this procedure permanently removes the specified data, and recovery is only possible through a backup. The associated framework managed data, such as audit snapshot data and user field storage, is deleted as well. No auditing is done on the purge and no LPL rules are fired.

  1. In the Administration Console, select Database > Purge Data.
  2. Specify this information:
    Business Class
    The name of the business class table from which you want to purge data.
    Set Name
    The name of the index to use. If none is specified, the primary index is used.
    Transaction Size
    The number of records to purge per transaction.
    Default Filter
    Select an option to control whether logically deleted records are included or excluded in the purge. Selecting to exclude or include logically deleted records only makes sense for business class tables that have a delete flag. When a table has a delete flag, if a record is deleted, it is marked as deleted but is still in the database.
    • Include Logically Deleted: Include both non-deleted and deleted records.
    • Exclude Logically Deleted: Include only non-deleted records.
    • Logically Deleted Only: Include only non-deleted records, leaving non-deleted records alone.
    Filter String

    Limit the output based on the specified filter value for the index keys of the file. You can use any filtering criteria that you could also do in LPL.

    See the Configuration Console Reference Guide: Landmark Pattern Language (LPL).

  3. Click Submit to process the data purge immediately or Schedule to schedule the data purge.