Example 4: inbound queue

In this example, this update command was executed at the primary database:

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

Execute the sysadmin dump_queue command to view the inbound queue of the primary Replication Server:

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

Output

I. 95/06/28 16:46:42. BLOCK BEGIN q_number=102  q_type=1 blk=0:38 cnt=3

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

I. 95/06/28 16:46:42.       ENTRY len=312 orig=102 oqid=0000000100000a670000028f00020000028f00020000883c01131c100000000000000000 lqid=0:38:0 st=4 tr= '0000000100000a' g '0002' NYDSnydb comlen=200 begin transaction upd

I. 95/06/28 16:46:42.       ENTRY len=776 orig=102 oqid=0000000100000a670000028f00050000028f00020000883c01131c100000000000000000 lqid=0:38:1 st=0 tr= '0000000100000a' g '0002' NYDSnydb comlen=661 update emp_queue set emp_id='123456789',emp_last='Davis               ',emp_first='General             ',emp_title='Process Engineer              ',emp_date='Jan  1 1995 12:00:00:000AM',branch_id=1111 where emp_id='123456789'

I. 95/06/28 16:46:42.       ENTRY len=312 orig=102 oqid=0000000100000a670000028f0007ffffffff00000000883c01131c100001000000000000 lqid=0:38:2 st=1 tr= '0000000100000a' g '0002' NYDSnydb comlen=200 commit transaction

Explanation

Tran Name=upd

Adaptive Server uses transaction name upd for implicit update transactions. RepAgent reads this name from the log.