Each record in the transaction log is identified by an origin queue ID that consists of 64 hexadecimal characters (32 bytes). The format of the origin queue ID is determined by the Replication Agent instance, and it varies according to the primary database type.
Table 2-1 illustrates the format of the origin queue ID for the Replication Agent for Microsoft SQL Server.
Character |
Bytes |
Description |
|---|---|---|
0-3 |
2 |
Database generation ID |
4-19 |
8 |
Transaction max sequence |
20-35 |
8 |
Operation sequence |
36-43 |
2 |
Operation type (begin = 0, data/LOB = 1, commit/rollback = 7FFF) |
44-59 |
8 |
Transaction ID |
60-63 |
4 |
LOB sequence ID |
