sysremoteusers / DBRemote

[#1]

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.

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