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

Baron
2.1k134146175
accept rate: 46%


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
7.7k343118
accept rate: 37%

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
40.1k361549819
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
BEGIN TRANSACTION
go
--REMOTE-1007-02520842565-0105-USER-NA-NA
--REMOTE-1007-02520842580-0105-RECEIVED_CONFIRM-02506172296-NA
--COMMIT-1007-02520842596
...
--CONNECT-1003-02520842599-RemUser-2017-05-08 09:50
--BEGIN TRANSACTION-1003-02520842614
BEGIN TRANSACTION
go
--REMOTE-1003-02520842617-0108-SENT_CONFIRM-02506536687-0007754361

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
40.1k361549819
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

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:

×78
×32

question asked: 21 Sep '17, 07:42

question was seen: 2,184 times

last updated: 24 Oct '19, 18:46