QIDs, transaction IDs, and interleaving transactions

The origin queue ID is a unique, ascending binary number associated with each log record. Origin queue IDs must always be ascending. Replication Server ignores operations that have origin queue IDs equal to or lower than the queue ID of the most recent transaction operation received.

The transaction ID contains part of the DB2 subsystem ID, the URID, the MEMID, and a DB2 timestamp.

Log records for multiple transactions can be interleaved. The following example shows valid interleaving of log records (where Qxxx is the queue ID, and Txxx is the transaction ID):

Q200T200update, Q201T200insert, Q202T202insert, Q203T200delete, Q204T202update, Q205T205insert, Q206T200insert, Q207T205delete...

See the Replication Server Design Guide for origin queue IDs and transaction IDs.