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 varies according to the primary database type.
Character |
Bytes |
Description |
---|---|---|
0–3 |
2 |
Database generation ID |
4–11 |
4 |
Virtual file sequence number |
12–19 |
4 |
Page start offset |
20–23 |
2 |
Operation number |
24–31 |
4 |
Available for specifying uniqueness |
32–39 |
4 |
Oldest active transaction: virtual file sequence number |
40–47 |
4 |
Oldest active transaction: page start offset |
48–51 |
2 |
Oldest active transaction: operation number |
52–59 |
4 |
Latest committed transaction: page start offset |
60–63 |
2 |
Latest committed transaction: operation number |