sysremoteusers / DBRemote

[Baron]

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.

[regdomaratzki · Accepted solution]

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.

[VolkerBarth]

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.

[VolkerBarth]

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.

[Baron]

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

[VolkerBarth]

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

[Baron]

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 😉