MobiLink Synchronization User's Guide
  Adaptive Server Anywhere Clients

Scheduling synchronization

Instead of running dbmlsync in a batch fashion, where it synchronizes and then shuts down, you can set up an Adaptive Server Anywhere client so that dbmlsync runs continuously, synchronizing at predetermined times.

You specify the synchronization schedule as an extended option. It can be specified either on the dbmlsync command line or it can be stored in the database for the synchronization user, subscription, or publication.

For information about extended options, see -e extended options or -eu option. For more information about how to set scheduling, see Schedule (sch) extended option.

To add scheduling to the synchronization subscription

• Set the Schedule extended option in the synchronization subscription. For example,

  CREATE SYNCHRONIZATION SUBSCRIPTION TO mypub
  FOR mluser
  ADDRESS 'host=localhost'
  OPTION schedule='weekday@11:30am-12:30pm'

  For more information about scheduling syntax, see Schedule (sch) extended option.

  You can override scheduling instructions and synchronize immediately using the dbmlsync -is option. The -is option instructs dbmlsync to ignore all scheduling information. For more information, see -is option.

To add scheduling from the dbmlsync command line

• Set the schedule extended option. Extended options are set with -e or -eu. For example,

  dbmlsync -e sch=weekday@11:30am-12:30pm ...

If scheduled synchronization is specified in either place, dbmlsync does not shut down after synchronizing, but runs continuously.

Hovering 

When scheduling options are specified, dbmlsync goes into hovering mode. Hovering is a feature that reduces the amount of time spent scanning the log. You can improve the performance benefits of hovering by setting the dbmlsync extended option HoverRescanThreshold or by using the dbmlsync stored procedure sp_hook_dbmlsync_log_rescan.

For more information, see HoverRescanThreshold (hrt) extended option and sp_hook_dbmlsync_log_rescan.