Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.

Hi,

I'm trying to find out how I can check which remotes are out of sync? I know that sysremoteuser gives some data, but I don't know how to interpret this data.

On of there reason I want to know this is because my transactionlog files are not getting cleaned up. I still have a files from 2 years ago. I have set the option that deletes the the log files when they are not needed anymore. Since they are not getting deleted I assume that the synchronisation has a need for that file.

asked 23 Apr '20, 02:05

MichaelMangelschots's gravatar image

MichaelMange...
1255615
accept rate: 0%

The following link describes the purpose of all the columns in the sysremoteuser table :

https://help.sap.com/viewer/93079d4ba8e44920ae63ffb4def91f5b/17.0/en-US/3be9ff0f6c5f1014937ee9f5500be619.html

(23 Apr '20, 10:49) Reg Domaratzki

Here's a small query we have used to find remotes that have not sync'ed lately, i.e. ordered by the maximum difference between log_sent and confirm_sent:

select  user_name, time_received, log_sent, confirm_sent, log_sent-confirm_sent as NotYetConfirmed,
resend_count
from sys.sysremoteusers
order by NotYetConfirmed desc, user_name;

So the first entries show the most inactive remotes, possibly because they have not sync'ed at all or it was not successful.

permanent link

answered 23 Apr '20, 05:45

Volker%20Barth's gravatar image

Volker Barth
40.3k363552824
accept rate: 34%

edited 23 Apr '20, 05:46

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:

×84
×78

question asked: 23 Apr '20, 02:05

question was seen: 1,280 times

last updated: 23 Apr '20, 10:49