When a SQL Anywhere 11.0.1 database is participating as the middle level tier in a three-level replication/synchronization structure, and synchronization with the top level is being performed via MobiLink for upload and Replication Server for download, and replication with the bottom level is being performed by SQL Remote, do the two clients dbremote.exe and dbmlsync.exe play nice with respect to the delete_old_logs option on the middle level database?

In other words, will they each preserve log files needed by the other?

asked 13 Jul '11, 11:22

Breck%20Carter's gravatar image

Breck Carter
27.3k424585836
accept rate: 21%

edited 06 Aug '11, 17:16

Nice tags, BTW:)

(13 Jul '11, 11:36) Volker Barth

Yes. Logs are only deleted when no subscription (dbremote nor dbmlsync) nor dbltm requires the log.

permanent link

answered 13 Jul '11, 11:37

RussC_FromSAP's gravatar image

RussC_FromSAP
1.3k11030
accept rate: 20%

Well, I had used v8 in a three-tier setup (with MobiLink against a MS SQL Server and with SQL Remote against ASA 8 remotes) for years. Option delete_old_logs was (and is) set to "delay". Never had issues with this option. Note that in our case, the ML log truncation point was always higher than the SQL Remote truncation offset so in practise it was SQL Remote's part to delete old logs.

Since some time, the MS SQL consolidated could be omitted, and now the system is a simple two-tier setup. Much easier when it comes to schema updates:)

permanent link

answered 13 Jul '11, 11:36

Volker%20Barth's gravatar image

Volker Barth
29.9k294446654
accept rate: 32%

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:

×284
×76
×19

question asked: 13 Jul '11, 11:22

question was seen: 1,118 times

last updated: 06 Aug '11, 17:16