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

SQL Anywhere 10.0.1 » MobiLink - Client Administration » MobiLink SQL Anywhere Client Extended Options

SendColumnNames (scn) extended option Next Page

SendDownloadACK (sa) extended option


Specifies that a download acknowledgement should be sent from the client to the server.

Syntax

sa={ ON | OFF }; ...

Remarks

Turning the acknowledgement off (the default) can lead to less contention in the consolidated database and also increased throughput due to shorter download transactions. Download transactions are shorter because they are committed or rolled back as soon as possible, since MobiLink doesn't need to keep these transactions open for as long as it takes the remote client to apply the download. Enable client side download buffering to get the most performance out of eliminating the download acknowledgement. It is recommended that SendDownloadAck be set to OFF. If the download fails, the remote will upload the same timestamp over again, and no data will be lost.

For more information about improving performance by turning off the download acknowledgement, see Do not enable download acknowledgement.

Note: When SendDownloadAck is set to ON and you are in verbose mode, an acknowledgement line is written to the client log.

The default is OFF.

This option has a short form and long form: you can use sa or SendDownloadACK.

You can also store extended options in the database. For more information about dbmlsync extended options, see Introduction to dbmlsync extended options.

Example

The following dbmlsync command line illustrates how you can set this option when you start dbmlsync:

dbmlsync -e "sa=off"

The following SQL statement illustrates how you can store this option in the database:

CREATE SYNCHRONIZATION SUBSCRIPTION
   TO sales_publication
   FOR ml_user1
   OPTION sa='off';