Use snapshot isolation for uploads.

Syntax

mlsrv11 -c "connection-string" -esu ...

Remarks

By default, MobiLink uses the SQL_TXN_READ_COMMITTED isolation level for uploads. In most cases, this is the optimal isolation level.

If you use snapshot isolation for uploads, you may generate conflicts on snapshot transactions during upload updates. If this happens, the MobiLink server rolls back the entire upload and retries it. In this case, you might want to adjust your settings for the MobiLink server options -r or -rd to specify the delay time between retries and the maximum number of retries.

You can change the default isolation level in a script. To change the upload isolation level, you would typically use the begin_upload script.

This option only applies to SQL Anywhere version 10 and Microsoft SQL Server 2005 consolidated databases.

See also

• MobiLink isolation levels
• -dsd option
• -dt option
• -r option
• -rd option