Sample RepAgent session

This section contains a sample dialog between a RepAgent and a Replication Server. The example transfers two transactions to the Replication Server.

The transaction log contains two concurrent transactions, “T1” and “T2”, with log records:

T1: begin transaction
T2: begin transaction
T1: insert into authors ('karsen', '510 534-9219')
T2: update authors set phone = '510 986-7020'
     where name = 'green' and phone = '415 986-7020'
T2: commit transaction
T1: commit transaction

distribute
     @origin_time='Dec 10 1992  8:48:12:750AM',
     @origin_qid=0x00000000000000000000000000000001,
     @tran_id=0x000000111111
     begin transaction 'T1' for 'user'/'password'

distribute
     @origin_time='Dec 10 1992  8:48:12:750AM',
     @origin_qid=0x00000000000000000000000000000002,
     @tran_id=0x000000222222
     begin transaction 'T2' for 'user'/'password'

distribute
     @origin_time='Dec 10 1992  8:48:13:750AM',
     @origin_qid=0x00000000000000000000000000000003,
     @tran_id=0x0000001111
     applied 'authors'.rs_insert yielding
         after @name='karsen', @phone='510 534-9219'

distribute
     @origin_time='Dec 10 1992  8:48:13:750AM',
     @origin_qid=0x00000000000000000000000000000004,
     @tran_id=0x000000222222
     applied 'authors'.rs_update yielding
         before @name='green', @phone='415 986-7020'
         after @name='green', @phone='510 986-7020'

distribute
     @origin_time='Dec 10 1992  8:48:14:750AM',
     @origin_qid=0x00000000000000000000000000000005,
     @tran_id=0x000000222222
     commit transaction

distribute
     @origin_time='Dec 10 1992  8:48:14:750AM',
     @origin_qid=0x00000000000000000000000000000006,
     @tran_id=0x000000111111
     commit transaction

You can use the get truncation command to verify that the truncation point is set to the origin_qid from the last distribute command.