Example 4: Outbound Queue after update

Interpret an outboud queue containing an update transaction.

An update has been performed at the primary database. The minimal column feature has not been set for the replication definition:

update emp_queue
   set emp_first = "General"
   where emp_id = "123456789"

Queue Dump

Dump the outbound queue or the replicate:

sysadmin dump_queue, 103, 0, -1,1,-2

Output:

I. 2006/07/05 08:31:32. BLOCK BEGIN
q_number=103 q_type=0 blk=0:3 cnt=3
I. 2006/07/05 08:31:32. Begin Transaction
Origin User=sa Tran Name=_upd
I. 2006/07/05 08:31:32. ENTRY ver=1100 len=204 orig=102
lorig=0 oqid=00000000000016e3000005020005000005020002
000097f5008bedfe0000000000000001 lqid=0:3:0 st=4
tr='00000000000016e30002' NYDSnydb comlen=88
begin transaction
I. 2006/07/05 08:31:32. ENTRY ver=1100 len=268 orig=102
lorig=0 oqid=00000000000016e3000005020005000005020002
000097f5008bedfe0000000000000002 lqid=0:3:1 st=0
tr= '00000000000016e30002' NYDSnydb comlen=149
update emp_queue
   set emp_id='123456789', emp_first='General',
       emp_last='Davis', emp_title='Process Engineer',
       emp_date='1/1/95', id=1111
   where id=1111
I. 2006/07/05 08:31:32. ENTRY ver=1100 len=180 orig=102
lorig=0 oqid=00000000000016e3000005020005000005020002
000097f5008bedfe0000000000000003 lqid=0:3:2 st=1
tr= '00000000000016e30002' NYDSnydb comlen=63
commit transaction

Explanation

cnt=3

There are 3 rows in this block.
Tran Name=_upd

If you perform an update and did not explicitly start a transaction, Adaptive Server uses _upd as the transaction name. Likewise, Adaptive Server uses _del for a delete command and _ins for an insert command.
st=4, st=0, st=1

Status for begin, other, and commit.