WARNING! For UDB, Replication Agent deletes the primary database log files it no longer needs.
Truncating of the transaction log is performed:
Automatically, by setting the configuration property truncation_interval to a value greater than “0” (zero), which will cause the log files to be deleted at the designated interval.
Manually, using the pdb_truncate_xlog, where Sybase Replication Agent immediately truncates the transaction log based on the most recent truncation point received from the primary Replication Server.
When UDB truncate runs, the oldest LSN for which Replication Agent has not processed a commit/rollback (oldest active LSN) is obtained and the transaction log file that contains the LSN is determined. Then, all log files up to but not including the file with the oldest active LSN are deleted.If automatically deleting log files on an interval is not desirable, a cronjob can be used that logs into Replication Agent and issues the pdb_truncate_xlog command immediately after the system backup job runs.
For more information on these properties refer to the Replication Agent Reference Manual. For a more detailed description of truncating, see “Chapter 3, Administering Sybase Replication Agent” of the Replication Agent Administration Guide.
