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
LTL commands are usually submitted to Replication Server
by a RepAgent using Open Client Client-Library routines. However,
you can submit LTL commands interactively using isql.
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.
