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 - Server Administration » MobiLink Monitor

Customizing your statistics Next Page

MobiLink statistical properties


Following is a list of the properties that are available in the MobiLink Monitor. These statistics can be viewed in the New Watch dialog, the Details Table pane, or the Synchronization Properties. In Synchronization Properties, the property names do not contain underscores.

For more information about the New Watch dialog, see Customizing your statistics.

For more information about the Details Table, see Details Table pane.

For more information about the Synchronization Properties dialog, see Synchronization properties.

Synchronization statistics

MobiLink statistical properties return the following information for synchronizations when not using forced conflict mode.

For information about forced conflict mode, see Forced conflict statistics.

Property

Description

active

True if the synchronization is in progress.

authenticate_userTotal time to perform user authentication, including executing the authenticate_* events.

begin_sync

Total time for the begin_synchronization event.

completed

True if the synchronization completed successfully.

conflicted_deletes

Always zero.

conflicted_inserts

Always zero.

conflicted_updates

Number of update rows that caused conflict. A row is included only when a resolve conflict script was successfully called for it.

connection_retries

Number of times the MobiLink server retried the connection to the consolidated database.

download

Total time for the download.

download_bytes

Amount of memory used within the MobiLink server to store the download. This provides a good indication of the impact on server memory of a synchronization.

download_deleted_rows

Number of row deletions fetched from the consolidated database by the MobiLink server (using download_delete_cursor scripts).

download_errors

Number of errors that occurred during the download.

download_fetched_rows

Number of rows fetched from the consolidated database by the MobiLink server (using download_cursor scripts).

download_filtered_rows

Number of fetched rows that were not downloaded to the MobiLink client because they matched rows that the client uploaded.

download_warnings

Number of warnings that occurred during the download.

duration

Total time for the synchronization, as measured by the MobiLink server.

end_sync

Total time for the end_synchronization event.

ignored_deletes

Number of upload delete rows that caused errors while the upload_delete script was invoked, when the handle_error or handle_odbc_error are defined and returned 1000, or when there is no upload_delete script defined for the given table.

ignored_inserts

The total number of upload insert rows that were ignored. They were ignored because 1) there is no upload_insert script in normal mode or no upload_new_row_insert script in forced conflict mode; or 2) errors occurred when the MobiLink server was invoking the corresponding script and the handle_error or handle_odbc_error event returned 1000.

ignored_updates

Number of upload update rows that caused conflict but a resolve conflict script was not successfully called or no upload_update script was defined.

prepare_for_download

Total time for the prepare_for_download event.

start_time

Date-time (in ISO-8601 extended format) for the start of the synchronization.

sync

A number uniquely identifying the synchronization within the Monitor session.

sync_deadlocks

Number of deadlocks in the consolidated database that were detected for the synchronization.

sync_errors

Total number of errors that occurred for the synchronization.

sync_requestThe time the synchronization request was first noticed by the MobiLink server.

sync_tables

Number of client tables that were involved in the synchronization.

sync_warnings

Number of warnings that occurred for the synchronization.

upload

Total time for data to be uploaded to the consolidated database.

upload_bytes

Amount of memory used within the MobiLink server to store the upload. This provides a good indication of the impact on server memory of a synchronization.

upload_deadlocks

Number of deadlocks in the consolidated database that were detected during the upload.

upload_deleted_rows

Number of rows that were successfully deleted from the consolidated database.

upload_errors

Number of errors that occurred during the upload.

upload_inserted_rows

Number of rows that were successfully inserted in the consolidated database.

upload_updated_rows

Number of rows that were successfully updated in the consolidated database.

upload_warnings

Number of warnings that occurred during the upload.

user

MobiLink user name.

version

Name of the synchronization version.

Forced conflict statistics

When you are in forced conflict mode, MobiLink statistical properties return the following information.

Statistical propertyDescription
conflicted_deletesNumber of upload delete rows that were successfully inserted into the consolidated database using the upload_old_row_insert script.
conflicted_insertsNumber of upload insert rows that were inserted into the consolidated database using the upload_new_row_insert script.
conflicted_updatesNumber of upload update rows that were successfully applied using the upload_new_row_insert or upload_old_row_insert scripts.
ignored_deletesNumber of upload delete rows that caused errors while the upload_old_row_insert script was invoked, when the handle_error or handle_odbc_error are defined and returned 1000, or when there is no upload_old_row_insert script defined for the given table.
ignored_insertsNumber of upload insert rows that caused errors while the upload_new_row_insert script was invoked, when the handle_error or handle_odbc_error are defined and returned 1000, or when there is no upload_new_row_insert script defined for the given table.
ignored_updatesNumber of upload update rows that caused errors while the upload_new_row_insert or upload_old_row_insert scripts were invoked, when the handle_error or handle_odbc_error are defined and returned 1000, or when there is no upload_new_row_insert and upload_old_row_insert script defined for the given table.
upload_deleted_rowsAlways zero.
upload_inserted_rowsAlways zero.
upload_updated_rowsAlways zero.