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

SQL Anywhere 12.0.0 » Context-Sensitive Help » MobiLink Monitor help

 

Synchronization Properties window: General tab

This tab has the following components:

Overall Synchronization Statistics   These statistics provide general information about the selected synchronization.

  • Sync   A unique number assigned to each synchronization within a session by the MobiLink Monitor.

  • Remote ID   The remote ID that uniquely identifies the remote database.

  • User   The name of the MobiLink client.

  • Version   The name of the synchronization version.

  • Start time   Date-time (in ISO-8601 extended format) for the start of the synchronization. The format is either YYYY-MM-DD hh:mm:ss.sss or YYYY-MM-DD hh:mm:ss,sss, depending on your locale setting.

    This time may be later than when the synchronization was requested by the client.

  • End time   Date-time (in ISO-8601 extended format) for the end of the synchronization. The format is either YYYY-MM-DD hh:mm:ss.sss or YYYY-MM-DD hh:mm:ss,sss, depending on your locale setting.

  • Active   Yes if the synchronization is in progress, otherwise no.

  • Download Ack   The download acknowledgement type. The values are None, Non blocking, and Blocking. See Download acknowledgement.

  • Completed   Yes if the synchronization completed successfully, otherwise no.

Synchronization Phase Statistics   These statistics provide information about each phase of the synchronization.

  • Synchronization request   The time taken between creating the network connection between the remote database and the MobiLink server, up to receiving the first bytes of the upload stream. This time is insignificant unless you have set -sm to a smaller value than -nc, in which case this time can include the time that a synchronization is paused, when the number of synchronizations is larger than the maximum number of active synchronizations that were specified with -sm.

  • Receive upload   The time taken from the first bytes of the upload stream being received by the MobiLink server until the upload stream from the remote database has been completely received. The upload stream includes table definitions and the remote database rows being uploaded, so the time may be significant even for a download-only synchronization. The time depends on the size of the upload stream and the network bandwidth for the transfer.

  • Get DB worker   The time required to acquire a free database worker thread.

  • Connect   The time required by the database worker thread to make a database connection if a new database connection is needed. For example, after an error or if the script version has changed.

  • Authenticate user   The time required to authenticate the user.

  • Begin synchronization   The time required for the begin_synchronization event.

  • Apply upload   The time required for the uploaded data to be applied to the consolidated database.

  • Prepare for download   The time required for the prepare_for_download event.

  • Fetch download   The time required to fetch the rows to be downloaded from the consolidated database to create the download stream.

  • End synchronization   The time required for the end_synchronization event, after which the database worker thread is released. This phase occurs before the download stream is sent to the remote database.

  • Send download   The time required to send the download stream to the remote database. The time depends on the size of the download stream and the network bandwidth for the transfer. For an upload-only synchronization, the download stream is simply an upload acknowledgement. This phase statistic applies when the download acknowledgement type is non blocking.

  • Wait for download ack   The time spent waiting for the download to be applied to the remote database and for the remote database to send the download acknowledgement. This phase statistic is only shown when the remote database has enabled download acknowledgement and the MobiLink server is using non-blocking download acknowledgement.

  • Get DB worker for download ack   The time spent waiting for a free database worker thread after the download acknowledgement has been received. This phase statistic is only shown when the remote database has enabled download acknowledgement and the MobiLink server is using non-blocking download acknowledgement.

  • Connect for download ack   The time required by the database worker thread to make a database connection if a new database connection is needed. This phase statistic is only shown when the remote database has enabled download acknowledgement and the MobiLink server is using non-blocking download acknowledgement.

  • Non-blocking download ack   The time required for the publication_nonblocking_download_ack connection and nonblocking_download_ack connection events. This phase statistic is only shown when the remote database has enabled download acknowledgement and the MobiLink server is using non-blocking download acknowledgement.

 See also