In this example, the create subscription command at the replicate Replication Server starts the materialization process by selecting from the primary database:
create subscription emp_queue_sub for emp_queue with replicate at LNDS.lndb
To view the entire queue:
sysadmin dump_queue, 103, 0,-1,1,-2
95/06/28 16:24:15. BLOCK BEGIN q_number=103 q_type=0 blk=0:20 cnt=1
I. 95/06/28 16:24:15. Begin Transaction Origin User= Tran Name=
I. 95/06/28 16:24:15. ENTRY len=176 orig=102 oqid=0000000100000a5c0000028e000dffffffff00000000883c010dd7000001000000000000 lqid=0:20:0 st=21 tr= '0000000100000a' \ '0009' NYDSnydb comlen=61 activate subscription 0x010000658000006f 0
BLOCK BEGIN
The beginning of a 16K block.
q_number=103
The queue ID.
q_type=0
The queue type (0 = outbound, 1 = inbound).
blk=0:20
Block identifier (segment 0: block 20).
cnt=1
The number of entries (commands) in this block.
Begin Transaction Origin User= Tran Name=
Beginning of a transaction with originating user and the transaction name. Tran Name is empty when the original transaction at the primary database was explicitly started with a begin transaction without supplying a transaction name.
ENTRY
The actual message.
len=176 orig=102
The message length and the originating site ID.
oqid=0000000100000a5c0000028e000dffffffff00000000883c010dd7000001000000000000
The origin queue ID: the queue ID assigned to the command string at the place the command originated from. This ID is used for duplicate detection.
Lqid=0:20:0
Local queue ID: Commands logged by an SQM are assigned a local queue ID. This queue ID is sent to the next queue as the sender queue ID and is used by the destination to acknowledge the command. Lqid consists of segment number, block number and row number. Row numbers start at 0.
St=21
Status and command type. The field is a bitmask which has status and command type set. This bit’s settings are 0x01 and 0x20, a commit and materialization command.
0x01 = status of a commit
0x02 = status of a rollback
0x04 = status of a begin
0x08 = status of a orphan statement
0x10 = status of a materialization statement
0x20 = status of a materialization statement
0x40 = status of a tran going to primary
0x80 = ignore duplicates for DDL commands
0x0100 = status of a materialization command
0x0200 = dump/load message
0x0400 = routing message
0x0800 = flag for DDL generation
0x1000 = DDL generation at DSI flag
0x2000 = special SQM message
0x4000 = SQT mini-abort
0x8000 = message has been zapped
tr= '0000000100000a' \ '0009' NYDSnydb comlen=61 activate subscription 0x010000658000006f 0
Transaction ID and command, comlen indicates the length of the command.
