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

SQL Anywhere 17 » MobiLink and SAP HANA Remote Data Sync - Client Administration » SQL Anywhere clients for MobiLink

MobiLink SQL Anywhere client utility (dbmlsync) syntax

Use the dbmlsync utility to synchronize SQL Anywhere remote databases with a consolidated database. To run dbmlsync you must have the SYS_RUN_REPLICATION_ROLE system privilege.

dbmlsync [ options ] [ transaction-logs-directory ]
Option Description
@ data Read in options from the specified environment variable or configuration file.
-a Do not prompt for input again on error.
-ap parameter,... Specify authentication parameters.
-ba filename Apply a download file.
-bc filename Create a download file.
-be string When creating a download file, add a string.
-bg When creating a download file, make it suitable for new remotes.
-bk Enables background synchronization.
-bkr number Specifies the number of times dbmlsync will retry synchronization after a background synchronization is interrupted.
-c connection-string Supply database connection parameters in the form parm1=value1; parm2=value2,... that are used to connect to the remote database. If you do not supply this option, a window appears and you must supply connection information.
-ci size Sets the initial size of the dbmlsync cache.
-cl size Set the minimum size threshold for the dbmlsync cache file.
-cm size Set the maximum size limit for the dbmlsync cache file.
-d Drop any other connections to the database whose locks conflict with the articles to be synchronized.
-dc Continue a previously failed download.
-dl Display log messages on the dbmlsync messages window.
-do Disables scanning of offline transaction logs. This utility option cannot be used with the -x utility option.
-drs bytes For restartable downloads, specify the maximum amount of data that may need to be re-sent after a communications failure.


Perform a download-only synchronization.
-e "keyword=value"... Specify extended options.
-eh Ignore errors that occur in hook functions.
-ek key Specify the remote database encryption key.
-ep "keyword=value" Prompt for the remote database encryption key.
-eu Specify extended options for upload defined by most recent -n option.
-is Ignore schedule.
-k Close window on completion.
-kpd In the event of a download failure, saves the information required to attempt restarting the download.
-l List available extended options.

-mn password

Specify new MobiLink password.

-mp password

Specify MobiLink password.
-n "name,..." Specify synchronization publication name(s).
-o filename Log output messages to this file.
-os size Specify a maximum size for the message log file, at which point the log is renamed.
-ot logfile Delete the contents of the message log file and then log output messages to it.
-p Disable logscan polling.
-pc[ + | - ] Maintain an open connection to the MobiLink server between synchronizations.
-pi Test that you can connect to MobiLink.
-po port Specifies the port on which dbmlsync listens.
-pp number Set logscan polling period.
-q Run in minimized window.
-qc Shut down dbmlsync when synchronization is finished.
-qi Starts dbmlsync in quiet mode with the window completely hidden.
-r[ a | b ] Use client progress values for upload retry.
-s name Specify synchronization subscription name(s).
-sc Reload schema information before each synchronization.
-sm Causes dbmlsync to start in server mode.
-sp sync-profile Add options from the synchronization profile to the synchronization options specified on the command line.
-ts session-name(session-option=option-value[;...]) Sets up a MobiLink client tracing session.
-tu Perform transactional upload.
-u ml_username Specify the MobiLink user to synchronize.
-ud For Unix only. Run dbmlsync as a daemon.
-ui For Linux with X window, starts dbmlsync in shell mode if a usable display isn't available.
-uo Perform upload-only synchronization.
-urc row-estimate Specify an estimate of the number of rows to upload.
-ux For Solaris and Linux, open the dbmlsync messages window.
-v[ levels ] Verbose operation.
-wc classname Specify a window class name.
-x [ size ] Rename and restart the transaction log. Use the optional size parameter with the -x option to control the size of the transaction log.
transaction-logs-directory Specify the location of the transaction log. See Transaction Log File, below.

Run dbmlsync to synchronize a SQL Anywhere remote database with a consolidated database.

To locate and connect to the MobiLink server, dbmlsync uses the information from the publication, synchronization user, synchronization subscription, or the dbmlsync command line.

  • Transaction log file

    The transaction-logs-directory is the directory that contains the transaction log for the SQL Anywhere remote database. There is an active transaction log and zero or more transaction log archive files, all of which may be required by dbmlsync to determine what to upload. Specify this parameter if the transaction log archive files are in a different directory than the active transaction log.

  • dbmlsync event hooks

    There are also dbmlsync client stored procedures that can help you customize the synchronization process.

  • Using dbmlsync

    For more information about using dbmlsync, see the documentation for synchronization initiation.