Sorter files are located on the data directory of the Replicate server.
Sample location:
C:\Program Files\Attunity\Replicate\data\tasks\<task name>\sorter
The twsp files are transactions that have not been applied to target yet. They are automatically purged after use.
Sorter files will accumulate if there if either:
- Big transactions from the source are not committed yet
- Target transactions are not applied yet
- Target transactions have been applied but no confirmation was returned
You cannot control the size of the sorter file however you can configure Replicate to use more memory and a longer transaction timeout.
Increasing the Transaction Offload Tuning values can help, especially the Transactions duration exceeds the default values.
Locate the settings in:
- Designer --> Task Settings --> Change Processing --> Change Processing Tuning -->
- Transaction Offload Tuning Total transactions memory size exceeds (MB):
Set this to a larger memory allocation, such as 4G, 8G etc, depending on the total memory of the AR server.
- Transactions duration exceeds (seconds):
Set to a longer time, eg 1 hour etc, depending on the transaction requirements.
It is not advisable to delete the tswp files in the sorter file as this will impact Replicate's ability to process the changes. It acts as a landing zone for changes which have not been applied to the target, so deleting those files can cause unexpected behaviour and possibly data loss.