Example 2: Inbound Queue after a Series of Commands

Interpret an inbound queue containing different transactions.

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

Queue Dump

Dump the inbound queue of the primary Replication Server:

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

Output:

I. 2006/07/05 08:27:05. BLOCK BEGIN
q_number=102 q_type=1 blk=0:4 cnt=10
I. 2006/07/05 08:27:05. Begin Transaction
Origin User=sa Tran Name=rs_logexec
I. 2006/07/05 08:27:05. ENTRY ver=1100 len=216 orig=102
lorig=0 oqid=00000000000016c7000004ff0005000004ff0005
000097f5008af20b0000000000000000 lqid=0:4:0 st=4
tr= '00000000000016c70005' NYDSnydb comlen=97
begin transaction 
I. 2006/07/05 08:27:05. ENTRY ver=1100 len=204 orig=102
lorig=0 oqid=00000000000016c7000004ff0007000004ff0005
000097f5008af20b0000000000000000 lqid=0:4:1 st=1
tr= '00000000000016c70005' NYDSnydb comlen=86
commit transaction
I. 2006/07/05 08:27:05. Begin Transaction
Origin User=sa Tran Name=_ins
I. 2006/07/05 08:27:05. ENTRY ver=1100 len=208 orig=102
lorig=0 oqid=00000000000016c7000004ff0008000004ff0008
000097f5008af20b0000000000000000 lqid=0:4:2 st=4
tr= '00000000000016c70008' NYDSnydb comlen=91
begin transaction
I. 2006/07/05 08:27:05. ENTRY ver=1100 len=524 orig=102
lorig=0 oqid=00000000000016c7000004ff0009000004ff0008
000097f5008af20b0000000000000000 lqid=0:4:3 st=2097152
tr= '00000000000016c70008' NYDSnydb comlen=406
insert into dbo.emp_queue
 (emp_id, emp_first, emp_last, emp_title, emp_date, id)
 values ('123456789', 'Gen', 'Davis',
          'Process Engineer', '1/1/95', 1111)
I. 2006/07/05 08:27:05. ENTRY ver=1100 len=204 orig=102
lorig=0 oqid=00000000000016c7000004ff000a000004ff0008
000097f5008af20b0000000000000000 lqid=0:4:4 st=1
tr= '00000000000016c70008' NYDSnydb comlen=85
commit transaction
I. 2006/07/05 08:27:05. Begin Transaction
Origin User=sa Tran Name=_ins
I. 2006/07/05 08:27:05. ENTRY ver=1100 len=208 orig=102
lorig=0 oqid=00000000000016c7000004ff000b000004ff000b
000097f5008af20b0000000000000000 lqid=0:4:5 st=4
tr= '00000000000016c7000b' NYDSnydb comlen=91
begin transaction
I. 2006/07/05 08:27:05. ENTRY ver=1100 len=528 orig=102
lorig=0 oqid=00000000000016c7000004ff000c000004ff000b
000097f5008af20b0000000000000000 lqid=0:4:6 st=2097152
tr= '00000000000016c7000b' NYDSnydb comlen=409
insert into dbo.emp_queue
 (emp_id, emp_first, emp_last, emp_title, emp_date, id)
 values ('987654321', 'Ben', 'Irvine',
 'Microwave Engineer', '3/5/94', 2222)
I. 2006/07/05 08:27:05. ENTRY ver=1100 len=204 orig=102
lorig=0 oqid=00000000000016c7000004ff000d000004ff000b
000097f5008af20b0000000000000000 lqid=0:4:7 st=1
tr= '00000000000016c7000b' NYDSnydb comlen=85
commit transaction
I. 2006/07/05 08:27:05. Begin Transaction
Origin User=sa Tran Name=_grrev
I. 2006/07/05 08:27:05. ENTRY ver=1100 len=212 orig=102
lorig=0 oqid=00000000000016c7000004ff000e000004ff000e
000097f5008af20b0000000000000000 lqid=0:4:8 st=4
tr= '00000000000016c7000e' NYDSnydb comlen=93
begin transaction
I. 2006/07/05 08:27:05. ENTRY ver=1100 len=204 orig=102
lorig=0 oqid=00000000000016d2000005010016000004ff000e
000097f5008af20b0000000000000000 lqid=0:4:9 st=1
tr= '00000000000016c7000e' NYDSnydb comlen=85
commit transaction

Explanation

Q_type=1

An inbound queue.
Tran Name=rs_logexec

Name of the transaction sp_setreplicate.
Tran Name=_ins

Adaptive Server uses transaction name _ins for implicit insert transactions.
Tran Name=_grrev

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

Note: You see all begin, commit, and rollback commands, regardless of whether or not the transactions contain changes that need to be replicated. When the RepAgent reads the log, it does not know whether or not the transaction includes changes to objects that are marked for replication.