Truncating the transaction log

Sybase Replication Agent provides features for both automatic and manual log truncation.

Replication Agent provides two options for automatic transaction log truncation:

You also have the option to switch off automatic log truncation. By default, automatic log truncation is switched off.

To specify the automatic truncation option you want (including none), use the ra_config command to set the value of the truncation_type configuration parameter.

To truncate the transaction log automatically based on a time interval, use the ra_config command to set the value of the truncation_interval configuration parameter.

At any time, you can truncate the Replication Agent transaction log manually by invoking the pdb_truncate_xlog command at the Replication Agent administration port.

To truncate the transaction log at a specific time, use a scheduler utility to execute the pdb_truncate_xlog command automatically.