Figure 7-2 illustrates the typical message flow during the normal lifetime of a subscription.
Figure 7-2: Subscription resolution
During subscription resolution:
Adaptive Server RepAgent thread scans the log for updates.
The primary Replication Server uses its sort order to determine what rows qualify for the subscription. The primary Replication Server also adds the name of the primary Replication Server’s character set to the RSI message.
The replicate Replication Server converts the data to its character set, if necessary, and applies updates to the replicate data server.