Closed and unused sets

When a new set is created, a series of records are stored in the Distribution SX.e database. This includes the data for the Extraction Columns for the source records, and the definitions of the Selection Criteria.

Sets that are not acted on can become stale, or can accumulate and use database space unnecessarily. To avoid stale records, perform the final update shortly after you create the set. After a set is completed, it is often no longer needed. If the set is never completed, that is, the Final Update is never run, then the set should be deleted.

Actively managing your sets in this manner minimizes the number of records stored for that set or on the database. It is up to you to decide whether to retain previously processed mass maintenance sets on file for auditing or inquiry purposes. Remember, you are deleting sets, not records.

See Stale records.

You can manually delete a set at any time, or you can automatically delete a set during the final update.

See Performing the final update.

If you delete a set before you perform the final update, the records in the database table are not updated. You cannot recall a set after it is deleted. Records of deleted sets are not maintained in Distribution SX.e.

These are the methods available to delete sets:
  • The Delete Set functionality deletes one set at a time.
  • The SA Mass Maintenance Set Deletion Report utility is recommended when you have multiple sets to delete at one time. Control the accumulation of existing sets, based on date, status, or table name.