Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.0 » SQL Anywhere Server - Database Administration » Configuring Your Database » Database options » Introduction to database options » Alphabetical list of options

 

delete_old_logs option [MobiLink client] [SQL Remote] [Replication Agent]

Controls whether transaction logs are deleted when their transactions have been replicated or synchronized.

Allowed values

On, Off, Delay, n days

Default

Off

Remarks

This option is used by SQL Anywhere MobiLink clients, by SQL Remote, and by the SQL Anywhere Replication Agent. The default setting is Off. When it is set to On, each old transaction log is deleted when all the changes it contains have been replicated or synchronized successfully. When it is set to DELAY, each old transaction log with a file name indicating that it was created on the current day is not deleted, even if all changes have been sent and confirmed. When it is set to n days, logs that were created before n days ago are deleted.

For more information about how to use the delete_old_logs option in conjunction with the BACKUP statement to delete old copies of transaction logs, see BACKUP statement.

Example

If, on January 18 you run dbmlsync against a remote database that has set the delete_old_logs option to 10 days, dbmlsync deletes offline transaction logs that were created on or before January 7. The remote database would set the option as follows:

SET OPTION delete_old_logs = '10 days';
See also