Purging Data

Use this procedure to purge data from the database. This procedure will remove the specified data permanently. That is, it cannot be recovered except via 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. Select Administration Console > Database > Purge Data.
  2. Specify this information:
    Business Class
    The name of the business class table that you want to purge data from.
    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 now, or Schedule if you want to schedule the data purge.