The Integration Service stores message IDs in a recovery table for real-time sessions that are enabled for recovery and include the following source and target types:
JMS source with relational targets
WebSphere MQ source with relational targets
The Integration Service temporarily stores message IDs and commit numbers in a recovery table on each target database. The commit number indicates the number of commits that the Integration Service committed to the target. During recovery, the Integration Service uses the commit number to determine if it wrote the same amount of messages to all targets. The messages IDs and commit numbers are verified against the recovery table to ensure that no data is lost or duplicated.
The source must use unique message IDs and provide access to the messages through the message ID.