UDR syntax  Datatype compatibility

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. Datatype compatibility

View this book as PDF