
Chapter 2: Replication Agent for Informix
Format of origin queue ID
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 Informix
with Informix Dynamic Server version 7.x and 2000.
Table 2-1: Replication Agent for Informix origin
queue ID for Dynamic Server version 7.x
Character
|
Bytes
|
Description
|
0-3
|
2
|
Database generation ID
|
4-19
|
8
|
Transaction max sequence
|
20-27
|
4
|
Operationid HI
|
28-35
|
4
|
Operationid LO
|
36-39
|
2
|
Operation type
(begin = 0, data/LOB = 1, commit/rollback = 7FFF)
|
40-55
|
8
|
Transaction ID
|
56-63
|
4
|
LOB sequence ID
|
Table 2-2 illustrates
the format of the origin queue ID for the Replication Agent for Informix
with Informix Dynamic Server 2000 (version 9.2).
Table 2-2: Replication Agent for Informix origin
queue ID for Dynamic Server 2000 version 9.2
Character
|
Bytes
|
Description
|
0-3
|
2
|
Database generation ID
|
4-19
|
8
|
Transaction max sequence
|
20-35
|
8
|
Operationid
|
36-39
|
2
|
Operation type
(begin = 0, data/LOB = 1, commit/rollback = 7FFF)
|
40-55
|
8
|
Transaction ID
|
56-63
|
4
|
LOB sequence ID
|
Copyright © 2005. Sybase Inc. All rights reserved.
|
|
View this book as PDF 