Mobilink SQLAnywhere 12

[former_SQLA_member1694909]

Data from our consolidated database (SQL anywhere 12) is downloaded to a other SQL Anywhere 12 database with mobilink.

In mobilink monitor we see:

Download 1: fetch download: 2.358,187 send download: 18.687,516 (5613499 bytes)

Download 2: fetch download: 2.295,485 send download: 365,844 (29233006 bytes)

In some cases we see after about 6 hours active No and completed No. The data seems to be downloaded.

My questions is what happens during the send download and how can we monitor this.

[Breck_Carter]

I don't understand the question.

[former_SQLA_member1694909]

The question is why the send_download (Mobilink Monitor) takes sometimes 6 hours and somtimes 3 minutes.

Thanks Eric

[regdomaratzki]

The send_download phase includes both the time it takes the ML Server to write the data to the stream and the time it takes for the remote database to apply the download. Is it possible that there was a lock on a row in the table in the remote database that was preventing the download from applying?

[former_SQLA_member1694909]

Thanks for the answer. The send_download (Mobilink Monitor) is now running for 21 hours. In the remote database there are 0 connections. The data seems up to date.

I suppose that the remote will send something to the consolidated when the download is applied. Will the send_download ever stop when nothing is received?

[Breck_Carter]

> In the remote database there are 0 connections.

It seems strange that a download is running even though dbmlsync.exe is not connected to the remote database.