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

SQL Anywhere 17 » MobiLink - Server Administration » MobiLink server options

-dt mlsrv17 option

For Microsoft SQL Server, SAP Adaptive Server Enterprise, and Oracle databases only. Causes MobiLink to detect transactions only within the current database.

Syntax
mlsrv17 -c "connection-string" -dt ...
Remarks

This option makes MobiLink ignore all transactions except ones within the current database. It increases throughput and reduces duplication of rows that are downloaded.

This option only affects timestamp-based downloads.

Use this option if:

  • Your consolidated database is running on Microsoft SQL Server, SAP Adaptive Server Enterprise, or Oracle that is also running other databases.

  • You are using snapshot isolation for uploads or downloads with Microsoft SQL Server.

  • You are using the DataRow locking scheme for synchronizing tables with Adaptive Server Enterprise.

  • Your upload or download scripts do not access any other databases on the server.

This option only applies to Microsoft SQL Server databases using snapshot isolation, and Adaptive Server Enterprise databases using the DataRow locking scheme for tables involved in synchronization.

For Oracle consolidated databases, the MobiLink user that connects to the Oracle database must have select permission on the following global view in the Oracle database: GV$TRANSACTION, GV$SESSION, and GV$LOCKED_OBJECT>