Contents Index DELAYED_COMMITS option [database] DESCRIBE_JAVA_FORMAT option [ISQL]

ASA Database Administration Guide
  Database Options
    Alphabetical list of options

DELETE_OLD_LOGS option [replication]


Function 

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

Allowed values 

ON, OFF, DELAY

Default 

OFF

Description 

This option is used at MobiLink clients, by SQL Remote, and by the Adaptive Server 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 sent and confirmed as received. 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.

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 the BACKUP statement.


Contents Index DELAYED_COMMITS option [database] DESCRIBE_JAVA_FORMAT option [ISQL]