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.

I am wondering how to find the equivalent procedure to 'sa_sync_sub' which is responsible for writing in SYSREMOTEUSERS. While translating the Transaction log file of synchronised DB using Mobilink I can find how Mobilink is writing in SYSSYNC but can't find it while using dbremote.

asked 21 Sep '17, 07:42

Baron's gravatar image

accept rate: 48%

dbremote is the only process that should be making changes to the SYS.SYSREMOTEUSER table. We do not document or broadcast how to make changes to this system table other than running dbremote.

permanent link

answered 11 Oct '17, 11:12

Reg%20Domaratzki's gravatar image

Reg Domaratzki
accept rate: 36%

So you are asking for a stored procedure with 'remoteuser' as part of the name?

Find out yourself...

Note, if that would exist, I would not know if is is called by the message agent.

permanent link

answered 21 Sep '17, 09:22

Volker%20Barth's gravatar image

Volker Barth
accept rate: 34%

No, I don't mean that the name of the procedre should include 'remoteuser', but I ask how are the progress values written in SYSREMOTEUSERS (log_sent, confirm_sent...etc.)

(21 Sep '17, 09:47) Baron
Replies hidden

Well, it's officially undocumented, and I won't reveal that, so I just tried to help you find out yourself...

(21 Sep '17, 10:31) Volker Barth

If it is not documented then is not possible to figure out. I found it by chance while unloading a database!

Now I have it ;)

(24 Oct '19, 18:46) Baron

I guess you can use DBTRAN with the -sr option and possibly with -u for the user running the message agent to capture these values.

Note, in my tests with v12.0.1, an accordingly translated log has comment lines like the following, containing the log offset information:

--CONNECT-1007-02520842547-RemUser-2017-05-08 09:50
--BEGIN TRANSACTION-1007-02520842562
--CONNECT-1003-02520842599-RemUser-2017-05-08 09:50
--BEGIN TRANSACTION-1003-02520842614

In other words:

In my understanding, the modifications on system table SYSREMOTEUSER are not contained as DML statements (nor as stored procedure call, as I had suspected) but as comments. Nevertheless I guess you should be able to read the relevant values from those comment lines.

permanent link

answered 26 Sep '17, 08:08

Volker%20Barth's gravatar image

Volker Barth
accept rate: 34%

edited 27 Sep '17, 04:57

Your answer
toggle preview

Follow this question

By Email:

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



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "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:


question asked: 21 Sep '17, 07:42

question was seen: 2,244 times

last updated: 24 Oct '19, 18:46