Renames and restarts the transaction log after it has been scanned for outgoing messages.

Syntax

dbmlsync -x [ size [ K | M | G ] ...

Remarks

The optional size means that the transaction log is renamed only if it is larger than the specified size. Use the suffix k, m or g to specify units of kilobytes, megabytes or gigabytes, respectively. The default size is 0.

In some circumstances, synchronizing data to a consolidated database can take the place of backing up remote databases, or renaming the transaction log when the database server is shut down.

If backups are not routinely performed at the remote database, the transaction log continues to grow. As an alternative to using the -x option to control transaction log size, you can use a SQL Anywhere event handler to control the size of the transaction log.

See also

• Automating tasks using schedules and events
• delete_old_logs option [MobiLink client] [SQL Remote] [Replication Agent]
• CREATE EVENT statement