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.

asked 25 Sep, 09:32

ontsnapt's gravatar image

ontsnapt
51339
accept rate: 0%

I don't understand the question.

(25 Sep, 09:48) Breck Carter

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

Thanks Eric

(25 Sep, 09:51) ontsnapt

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?

permanent link

answered 25 Sep, 11:34

Reg%20Domaratzki's gravatar image

Reg Domaratzki
5.8k33785
accept rate: 38%

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?

(26 Sep, 03:23) ontsnapt
Replies hidden
1

> 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.

(26 Sep, 05:30) Breck Carter
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×316

question asked: 25 Sep, 09:32

question was seen: 101 times

last updated: 26 Sep, 05:30