Previous Topic: Extend the TWA Object

Next Topic: TWA GRLoader Command Options

Archive and Purge of the TWA

To maintain the TWA, CA SDM provides the following archive/purge rules:

CI Inactive Transactions

Archives and purges CI transactions that are marked for deletion.

CI Successful Transactions

Archives and purges CI transactions that have completed successfully.

Relationship Inactive Transactions

Archives and purges relationship transactions that are marked for deletion.

Relationship Successful Transactions

Archives and purges relationship transactions that have completed successfully.

You can select how often the rules run or whether they are enabled.

You can customize and enable the rules for enabling archive and purge of the TWA. If you are a heavy user of the TWA, be aware of the limitations on the number of records in the TWA imposed by the DBMS.

If you have to reinitialize the TWA to clear out all data in the TWA, do the following:

Important! Do not use SQL to delete all records in the TWA because it deletes required header records.