Example 3: inbound queue

In this example, these commands were executed at a primary database, NYDS.nydb:

sp_setreplicate emp_queue, true

insert emp_queue values("123456789", "Davis", "Gen", "Process Engineer","1/1/95", 1111)

insert emp_queue values("987654321", "Irvine", "Ben", "Microwave Engineer","3/5/94", 2222)

grant all on emp_queue to public

To view the inbound queue of the primary Replication Server:

sysadmin dump_queue, 102,1,-1,1,-2

Output

I. 95/06/28 16:28:27. BLOCK BEGIN q_number=102  q_type=1 blk=0:35 cnt=2

I. 95/06/28 16:28:27.     Begin Transaction Origin User=sa Tran Name=user_transaction    I. 95/06/28 16:28:27.       ENTRY len=312 orig=102 oqid=0000000100000a5c0000028e00060000028e00060000883c010ca8890000000000000000 lqid=0:35:0 st=4 tr= '0000000100000a' \ '0006' NYDSnydb comlen=200 begin transaction user_transaction

I. 95/06/28 16:28:27.       ENTRY len=312 orig=102 oqid=0000000100000a5c0000028e0008ffffffff00000000883c010ca8890001000000000000 lqid=0:35:1 st=1 tr= '0000000100000a' \ '0006' NYDSnydb comlen=200 commit transaction

I. 95/06/28 16:28:27. BLOCK BEGIN q_number=102  q_type=1 blk=0:36 cnt=3

I. 95/06/28 16:28:27.     Begin Transaction Origin User=sa Tran Name=sub010000658000006f_ffffffff

I. 95/06/28 16:28:28.       ENTRY len=312 orig=102 oqid=0000000100000a5c0000028e00090000028e00090000883c010dd7000000000000000000 lqid=0:36:0 st=4 tr= '0000000100000a' \ '0009' NYDSnydb comlen=200 begin transaction sub010000658000006f_ffffffff

I. 95/06/28 16:28:28.       ENTRY len=156 orig=102 oqid=0000000100000a5c0000028e000b0000028e00090000883c010dd7000000000000000000 lqid=0:36:1 st=16 tr= '0000000100000a' \ '0009' NYDSnydb comlen=44 activate subscription 0x010000658000006f 0

I. 95/06/28 16:28:28.       ENTRY len=312 orig=102 oqid=0000000100000a5c0000028e000dffffffff00000000883c010dd7000001000000000000 lqid=0:36:2 st=1 tr= '0000000100000a' \ '0009' NYDSnydb comlen=200 commit transaction

I. 95/06/28 16:28:28. BLOCK BEGIN q_number=102  q_type=1 blk=0:37 cnt=2

I. 95/06/28 16:28:28.     Begin Transaction Origin User=sa Tran Name=grrev

I. 95/06/28 16:28:28.       ENTRY len=312 orig=102 oqid=0000000100000a5c0000028e000e0000028e000e0000883c010e29070000000000000000 lqid=0:37:0 st=4 tr= '0000000100000a' \ '000e' NYDSnydb comlen=200 begin transaction grrev

I. 95/06/28 16:28:28.       ENTRY len=312 orig=102 oqid=0000000100000a670000028f0001ffffffff00000000883c010e29070001000000000000 lqid=0:37:1 st=1 tr= '0000000100000a' \ '000e' NYDSnydb comlen=200 commit transaction

I. 95/06/28 16:28:28. END QUEUE DUMP FOR 102:1

Explanation

Tran Name=user_transaction

A transaction was started with the name user_transaction.
Q_type=1

An inbound queue.
Tran Name=sub010000658000006f_ffffffff

The Replication Server starts the activate subscription transaction with a generated name.
Tran Name=grrev

The grant and revoke permission commands get a special transaction name from the Adaptive Server.

You will see all begin, commit, and rollback commands regardless of whether or not the transactions contain changes that need to be replicated. When the LTM reads the log, it does not know whether or not the transaction includes changes to objects that are marked for replication. Because future versions of Replication Server may change this scheme to optimize for network traffic, you should check your current version of Replication Server for this behavior.